I am hoping some one can help me with this...
I have a form for participants of an event.  I have another form for
registrations for that event.  When I click my register button, I want to be
able to carry forward some of the information from the participant form to

I would like to loop through a list of files in a particular folder and
assign them to variables.  I will have the path of the folder, so the only
thing that I need is to loop through each, individual file and assign
variables (file1, file2, et al.) to each.

I have a user log table of:
NetUserName (e.g. mmiller)
LoginDate
LoginTime

I have a form that has a toggle button it.  I would like to include some code
on the toggle button that if the button is 'yes' it would change the
background color of the form to one color, but if it is 'no' it would use the
default color of the form.

I am trying to check controls for "IsNull" on the Control's BeforeUpdate, but
the system seems to simply blow by my logic.
Here is my code:
Private Sub Title_BeforeUpdate(Cancel As Integer)

I'm having a problem sending email from an Access application.  It seems to
work for a while and then stops working for reasons unclear to me.  Here are
the details:
The Access 2000 application runs continually and unattended on a machine

We're looking at building a MySql db with a Access front end for a small
group of people.  Can anyone tell me the best place to get information
on programming the forms to work with the DB?
Thanks!

New at vb here and am making a database in access. I am having a
problem trying to update the state of a button on a form. The button
should be enabled only if all three textboxes have text in them and the
button should be disabled if at least one of the textboxes becomes

I need to know if there is an evaluate command for strings in Access?
For example, if I create a variable lsSQL that contains the value:
lsSQL = "[Field1] = ' " & rsRecordset(""Field1"") & " ' "
and then I open a recordset and want to use the lsSQL as a parameter for the

Is there a way for my event procedure to know if the Find dialogue box is
open? I'd like to perform one action if it is, a different action if it is
not.
I'm using Access 2003.

This is related to a previous post on 7/01/05.  I have a query which works in
one control but is picking up the control's value.  As suggested, I created a
new unbound control and then copied the code from the first control into the
new control.  In this control the variable ...

When my application starts on another pc, it seems like the run time version
of access takes alittle bit to load before ever showing my form, can I hide
that window until my switchboard loads or is there a way to do a custom form
to use at that time?

How can I stop the user from closing the form when a required field is left
blank (null).
I have a table with one required field, (the field is set to required in the
table and there is no default value) and some optional fields. I have a

I seem to have backed myself into a corner here, ive got a form called
ReceiptForm which asks the user what a customer can be charged for from a
drop down list. The selection opens a popup form that the user can fill in
and save and each form is based on a table for that type of ...

Hey Guys,
Anyone know if it's possible to search and remove any redundant code in an
application?
TIA