form events
Sat, 6 Dec 2008 02:49:15 -0800 (PST)
can anyone tell me
1) in which event a Filter that is placed in the form property sheet
(eg- Filter = SQL statement) would take place?
2) If I use a RunCmd Recordsgotonew in an event on a form, to where
does this place the already-open form in the sequence of 'opening'
events for the form?
Thanks in advance.
...
|
form filter
Sat, 6 Dec 2008 02:17:09 -0800 (PST)
Anyone know in what form event a form filter gets applied?
Thanks
RL ...
|
subform or hidden fields.....i'm confused???
Fri, 5 Dec 2008 19:07:09 -0800 (PST)
I have a form where I collect data for Truck Tickets. The trucks
carry
a load to a site. Up until now we have one ticket (or one record) per
truck per site. Now there is a requirement to where there might be
one
truck ticket, but there could be multiple sites where the truck
drops.
I thought, if possible, t ...
|
Custom Collection in Form Module not working
Fri, 5 Dec 2008 18:20:10 -0800
Access 2003
I am unable to get a custom collection to work in a Form module. The code
snippets are:
Dim colBaseThemes as Collection
Set colBaseThemes = New Collection
Dim strBaseRef as String
open the recordset (it works)
With rstBaseSectionThemes
.Find strBaseRef (it works)
Do While Not .EOF
...
|
Return to record on main form
Fri, 5 Dec 2008 17:14:00 -0800
Man, here it is 5pm on a Friday and I'm stuck!
Here's my problem. I click a button on one form, frmIntegration, to launch
a 2nd form, frmUse_Case. After I'm done editing and close frmUse_Case I want
to do two things: requery frmIntegration (which I know how to do) AND return
to the record that I was on wh ...
|
how to call sub
Fri, 5 Dec 2008 16:46:39 -0800 (PST)
Hope someone can remind me how to do the following.
From an after_update event of a control on a form, I'd like to call
the 'on current' sub of the same form.
richard ...
|
Remove filter before comboBox finds record
Fri, 5 Dec 2008 16:28:01 -0800
I have a unbound combo box used to find a record on a My form F_Parts
it uses the rs.FindFirst "[PartNumberID] code that the Wizard Supplies on
the after Update,
I also have code on my forms "On Current" that keeps the combo displaying
the correct info if navigation buttons are used Me.SelectByPNID_Combo ...
|
|
|
Data table on a web server
Fri, 5 Dec 2008 13:54:01 -0800 (PST)
Is there a way to have a data table saved on a web server and have it
constantly updated by individuals submitting data via the web as an
XLS file? I'm guessing there would be some scripting involved with
this. Does anyone know if this can be done, and if so, is there a
resource somewhere to help with it? ...
|
Inbox issues
Fri, 5 Dec 2008 11:09:01 -0800
I have a form with a button used to open a second form. The SQL code behind
the button opens an input box for user input of an "FCSI Number". When the
user enters a valid FCSI number, the second form opens correctly. There are
two instances during which I recieve an error. The first is if the user
cancels t ...
|
IsLoaded compliance error
Fri, 5 Dec 2008 09:54:02 -0800
I need to have one subform automatically filter information based on the
"filter by selection" of another subform that is open. I copied the
following code and put it in the codebuilder for the form called frmClients.
When I try to filter by selection on frmClients I get the following
Compliance error mess ...
|
