In our application there are many processes that take more than 5 seconds to
complete (eg imports and exports). In these cases we present users with
status screens like showing text what is going on or a progressbar.
After 5-10 seconds these screens freeze while the program is still ...

To filter subform recordsource, is it better to use filter property or SQL
statement ?
Which one is fastest ?
Thanks.

Can anyone suggest suitable code to insert into an existing piece of code,
which will allow  it to  run only between certain hours each day.
Thanks

I don't remember how to load an unbound combo
box. In a loop through a directory path, I've isolated
the foldernames from that path. As I find each
folder, I want to insert the folder name into the combo

I am wanting to update a particular field in a form based on the data entered
in another field and write it to the underlying table.
ie
Field 1 Date: 01/12/2006

I need to add the ability to import a lot of data from another database.  
I've created a form and allow the user to select the database to import from.
Now since the imported data is supposed to replace the existing data, I need
to remove all the existing data.  That I can do, ...

Is it possible to pass a variable from a list box using openargs?

Hiya,
I had posted this about a week ago and got an answer that unfortunately
didn't help out.  Since then, I had another project to work on, and have gone
back to this to find I'm still stumped.

I have a People form that allows editting of a specific record in the People
table. I would like to add a control button that opens up the matching
Volunteer Form (based on the Volunteer table).  If there is no volunteer
record for this individual, I'd like the control button to ...

Can a query be hidden using the visible = false command?
Thanks in advance

I have an update query that combines the data of 4 fields from the current
table into one when the form is closed. Right now it runs an update on every
record in the table.  What is the criteria I can use to update only the
current record displayed in the form??

I am setting up a database in Access.
I have a drop down menu with "other" as a choice (For example: How would you
describe your race? Caucasian/Asian/African American/Other). I want to have a
text box appear when "other" is chosen, so that the person filling out the

The form is called: frmMain.
The tab control is called tabMain.
The subform placed on one of the tabs is called: frmProjDtl
The field on frmProjDtl is called: dteClosed.

I have a form which has a control box on it. I have a query as the
recordsource for this form, which has a number of different fields in it -
one of which is called "PMRS#". I want to be able to use my combo box to jump
to a specific PMRS#, however i keep getting the error message ...

I'm BaaAAaaack!
Well, thanks to all the folks who have helped me by posting their questions
and getting answers etc, I can now set up a basic search using a combobox to
pick the criteria. :-)