What is 'Dirty', I believe that it can be used to save changes to a record

I am trying to create code to delete the current record in my form when the
user closes the form if a particular field is null.  If the field is null, it
would indicate that the user didn't complete enough information for the
record to be "real."  Following is the code in the On ...

Hello group,
I am trying to search using several search keys. In my case I want t
search by Last Name and First Name.
Heres the code that I am using: (on Query x: Last Name Sorted (ASC)

I have a combo box on a form. It contains the line numbers for a specific
invoice. the control source is aa query from a table. I want to view the
line numbers in Descending order(Highest number to smallest number). When I
run the query alone it looks fine. When I use the combo ...

I have a main form with a subforms. I need to find a way when display a
record in the mainform while i am browsing the subform with store all the
records.
The main form can also be used to in put new record for the subform.

Is there an advantage of using RunSQL over Execute?
What are the differences here?
Thanks,
Fred

I have a need to be able to view emails that are stored on various computer
in the office, if it is possible, how?

I am creating a database in access and want to create a control button on the
switchboard form that allows me to open a word file. Do you know if this is
possible? I know its possible to open the "word" application.

This is really odd...
I have a piece of code that tabs from one control to another and as it
executes, it opens a form in my database that is not even being called.
I thought maybe the database was corrupt (since there is no code to open

I have a quick quesion I hope someone might have an answer to.
I am trying to a dcount on a form. I am trying to use criteria that uses two
different fields. I have never done it with two different criteria and can
not get it to work. Here is the code: =DCount("[event_id]","All ...

I have a main startup form
When you click a button, it brings up the "companies" form
when I click the "done" command button, it tests to see if the current record
has been changed and asks if the user wishes to confirm changes:

I'm using Access 97
I need to delete a heap of tables. But first I need to check if they are in
use. If one table is being used then I don't want to delete any of them.
I know I need two loops, one to check if the tables are open or being used,

In Access97, I am finding that a List Box has a limit of 2048 characters
assignable to it. Are there any suggestions on how to get around this? I have
a sequence of "commands" that the user defines, which could be of variable
length, and breaking these up into multiple List Boxes is ...

In the keydown event of a control (eg. Control A) there is code to set the
focus to the next control (eg. Control B) if the key that is pressed down is
either the Tab or Return key.  What happens is that the focus is set to
Control B then automatically is set to the next control ...

I have a form which is triggered by a button on a main form.  The pop up
type form is based on the same query as the base form, which stays open
"below" the active pop up type form.  The pop up form, however, is totally
locked and won't accept any data.