I've got the following code in one of my forms:
If Me.dispo.Value < 0 Then
    Me.dispo.ForeColor = "255"
Else: Me.dispo.ForeColor = "000"

I want to do a report of some of the data on the system, and I have created
various reports.
I have figured out how to export the data to an existing excel spreadsheet
using:

Information: Access2007
Requirement: I have four text box's. The first one I would like to auto fill
based on a selection made in another form. Once the auto fill is done, I want
the three corresponding box's to auto fill based off of the first box's

I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty)
Example of data
Iteml | InQty| OutQty| TotalQty
ABC 4 1 3

I am trying to call the itemnamecb afterupdate event from another open
form
I have made that event public
the contol name is itemnameCb.

We've just migrated to Access 2003.  I noticed the entire Menu Bar is missing
that normally shows (File, Edit, View,Tools, etc)
I clicked on customize, and on toolbars l looked for "menu bar" but it's not
listed to do the reset.

I'm trying to add a pop-up comment when the user enters a certain number in
the text box.
The code below I added to the text box but it does nothing.
Any suggestions.

I have a form on which there are several "Flag" text fields which users use
to mark records.  Next to each flag field there is a clear button that runs
the following code:
Private Sub btn_ClSA1Flag1_Click()

I created a Access db when I was on MS Office 2000. Upgrading to 2003 was
painless, but now that I upgraded to 2007 all of a sudden my coding won't run
anymore.
I get a runtime 2447 error.

I have a form with a command button that opens a second form and
populates it with data from the initial form.  That part is fine.
What I want to do is use that data in an On Open event (or something)
that will execute *after* the data is loaded by the first procedure.

Thanks for taking the time to read my question.
How can I get the computer settings for Date and Time?  I want to apply a
date filter on my report, but it will only work on PC's with m/dd/yyyy
format, not dd/mm/yyyy format.

OK, my question is this.
I have a form/subform.  The subform is based on a table where I can do data
entry until it is time to save that captured data.  My question is what is
the best way to delete a selected record on the subform?  Should I query the

Trying to code a "clear" flag field button on a form using Update SQL
statement.  Please see the following code:
Private Sub btn_ClFlag_Click()
On Error GoTo Err_btn_ClFlag_Click

Hi
I develped a simple Access application to track projects.  Application has a
fron-end file (with forms, queries, modules) and a back-end file with data
only.  All tables are linked tables from the front-end file.

I have a database that works great on my laptop where it was created.
I placed it on our server but I am the only one who can access and
work with it. Everyone else gets an error for the String.
Any suggestions? This is the actual error: