I have the following controls in a form: DateCompleted, Margin1 and Margin2.
I need to set up the form so that anytime a date is populated in the
DateCompleted control, the form will require that the controls Margin1 and
Margin2 are not null.

Does anyone know how I would go about creating a macro that when I click it,
it will backup the latest data onto a usb storage device. Any help is
appreciated.

I know that when a record is saved the dirty property is set to False, but
does setting the dirty property to false save the record?

I have a form which writes to a temporary table.  When I hit the submit
button, a macro runs an append query, writing the data to a permanent table
and deleting the record in the temporary table.
This works great, but all the sudden my form has 'deleted?" in each of my

I have an unbound combo box that when a selection is made needs to insert a
record to a related table. I can only do this if the record is 'dirty' and my
primary key has been generated. If they click the combo box before this
happens, I need to somehow get the primary key so I ...

Im having some strange behaviour with the OpenForm method now my mdb is
upsized to adp.
I have a continuous form to display a list of records, the user selects a
record and clicks an edit button. The code behinf the edit button is below;

I have a subform were the user inputs Qty received . The form has the total
qty received were it sums the qty recieved and displays. The problem  I am
facing is, when there are no items received yet the Qty received displays as
0 and the total is blank which is correct. ...

I am trying to make  a search engine form for  one table of mine
because it has long descriptions for each record and there are 5000
records its kind of hard to use a combo box search.  I was wondering
if anyone out there had an example of a keyword search engine so I

A client is currently using a QBF to select an employee to register for a
training class. Now, we want to allow for multiple employees to be selected
to register them at the same time for one class. Looking for examples, sample
code, or even a basic layout of how to approach this ...

Hi. I've had this error before, and have had no luck fixing it this
time....although I've narrowed it down. The problem lies here
somewhere:
strSQL = "SELECT [Disk Information].[File Name], [Disk Information].

I have a control on a form with a default value of "0" that users have
occasionally started to change the value in the control, but then exit the
form with a Null value.  This affects various reports that include this data.
I'd like to have the value return to 0 either in the event ...

How can i move focus from one form to another

I recently became a member of a small community savings group. I am
developing a database for entering payments made into the savings group by
the members. This has always been done using a spreadsheet in the past.
Unfortunately when a copy of each days payments has been printed ...

I have a form that has fields about customers.  I'm trying to automate a
couple fields using conditions in a macro.
In the City field, if a person enters "Cleveland" I want the Region field to
populate "OH" and the Country field to populate "US".  Is this possible using

How Does One Create Like a User Wizard for inputting data into a table
which holds about 30 fields
The Aim Its to have the Wizard fill in the Projects Table in like 3
seperate Windows