I have some simple code that tests the result of a query before opening a
form with those results...
This has previously worked with no problems... however, what I'm doing
differently in this instance is that the query I'm testing is getting its

When this procedure is ran on a Windows 98 (255 ram) machine and Access 2000
ver 9.0.0.2719 the computer locks up and I get all sorts of errors.  
(Kernal32, Explorer, and Blue Screens of DEATH)  I don't have any poblems on
my Computer that has less ram, but is Windows 2000.  The ...

I need to have a way to check fields for empty before my form moves to a new
record or closes the form.  What is the best event to place the code?

Is there an event that takes place before a form moves to a new record?  I
want perform some field checking before it moves to the new record.

Is it possible from Access to retrieve data from a Word bookmark?

I have some subforms which are datasheet views. I find that turning off
record selectors on them seems to not work (the selectors are still there).
Turning off navigation buttons does work. Also I would like to turn off
column titles as well, but I don't see what property controls ...

I have some code that does complex validation in the form's before update
event.  If the validation fails, I set cancel to True.  How can I reference
whether the cancel was true or false in a subsequent or calling event?  I
want to construct an if statement, but don't know the ...

Hi to all,
I have a main form with a combo box and a tab control on
it.
On pg3 of the tab control there is a subform. What I would

How is it possible to open a new instance of a form from the same one?
if yes, is it also possible to keep the handler identifier of the new form?
Thanks for any suggestion.

I have a form where im trying to calculate the difference between the moneies
collected and those owed.
The collected amount is worked out by summing up a subform which holds all
the payments made by a person. There is a SUM field in that subform that is

I would like to copy 1 table form my project to a diskette (a:) upon
clicking a pushbutton.
Then also, how to add the data form the a diskette into the table of
the current project.

In a nutshell, what I'm trying to accomplish is the have a user select a
unique value from ComboBox1 and then have ComboBox2 bring up the associated
value(s).
Setup:

Hi. Can anyone help me put together a Where clause for
the following DLookup please? I will use this in a text
box in a Subform called frmLandladiesSubform.
=DLookup ("[FirstName]","[tblLandladies]","Where Clause")

i got a table with the fields: Week Code, Start date, End date
the table keeps a forecast, sow today i forecast for 3 mouth later..
what i want now is: when opening the forms, go to week code where date() is
inside "start date" and "finish date", sow i can view current week.

I have a form with a 2 page tab control on it.  The first page has 10
controls and half of them I'd like to have tab stops and set the order.
I've tried numerous variations of changing the property sheet setting to
turn tabbing on/off for controls and setting their tab order.  As it ...