I have a form that I am using Condiftional formatting to create a
dashboard to indicate if there are records for each weekday of the
selected week.  I have inserted requery commands on AfterUpdate events
of the fields, but the nature of the lookups that I am using for the

I'm updating a field by saying;
me.txtName = varName
But if I step through the code and do a dlookup on this field it's null.
Looking at table while the code is running also show the field to be null.

I am creating a training database for my company and I have come across a
minor problem.
I have a table called "Courses" which has the following information
//////////////////////////////////////////////////////////

Setting form's Picture property to another file from within
VBA doesn't repaint the form with new bitmap - for instance...
Me.Picture = "c:\pics\MyNewPic.jpg"
I tried

I have this shell command:
Call Shell("""" & ShellPath & """""NETWORK AND FILENAME""""""")
and also:
Debug.print ("""" & ShellPath & """""NETWORK AND FILENAME""""""")

One of the people here at work has designed a database that students
will be using to enter data.  She has Yes/No selection buttons, which
start out grayed out with no value.  If a student selects the Yes or
No in error, is there any simple way to allow for the boxes to be

First and foremost I would like to mention that I have a DB schema set
up for what I would like to do and I do understand all the terminology
and practices, so please spare me the "If you have to ask then you
shouldn't be doing it in the first place" speech.

Really dumb question but I don't know how to resolve it. Looked in help and
evry book I have.
I have a table where the primary key was set as an Integer and its reached
over 140K worth of records and the numbering has restarted from 1.

I have built a serch form for users to edit records. I only want them
to pull up the record they need, and I want to check for nulls. There
should not be dupes becasue the underlying tables are indexed. So the
user will pull up either one record or none. Here is my problem:

I did find reference to the question in a search of google groups, but
I couldn't find a clear answer.
I need, essentially,
      if rs.Fields("X") exists Then _

Thanks in advance for the help... should be an easy one for you all.
I have a access table where I have the following fields:
Product
Sales

I need to assign sequential invoice numbers to orders starting from the last
highest number + 1. I have tried the following code;
UPDATE Orders SET Orders.[Invoice No] = DMax("[Invoice No]","Orders")+1
WHERE Orders.[Invoice No]) Is Null AND ...

Is there any possibility to suppress a message box from Access ? I have
a  complicated but a good code that calculates the possibilities in the
before update event, and if a condition is met, then it exits the
sub.In short, if this condition is met, then after  the exit sub I get

Hello all,  we finally upgraded our system so now our data is on a SQL
2000 database and our front end is on an Access 2000 database.
Everything's looking good so far, but there's this little issue that's
been bugging us ever since we upgraded.

I am having a hard time trying to code around this.  I have a checkbox
field in a MSAccess table called "100Fund" which is identical in
structure to other checkbox fields in the same table.  I have a combo
box listing the various fields in the table for the user to select as a