I have been having problems checking for blank values on fields with
date/time and currency datatypes.
Example, I have tried the syntax statring with the following  and they have
not worked out

I have a form which displays summarized information on Mission Reports in a
number of textboxes. The textboxes are locked. In order to edit the
information for a given report, I have created another form (for editing and
adding new records)with identical textboxes which is opened ...

I want to be able to detect changes in a subform and undo or save them.  I am
using "How to Undo or Rollback Main Form and Subform Changes" from FrmSmp97
using modUndoMain&Subform with the following code on cmdCancel:
Private Sub Form_Current()

i am checking to see if an entry has been made before unloading my form it
all seems to work ok but after my prompt msg access throws up an error msg
"The Microsoft Jet database engine could not find the object ". Make sure
the object exists and that you spell its name and the ...

I am trying to write a function that will clear all the text boxes in a form
and have been having trouble getting the following code to run:
Dim ctl as Control
For Each ctl in Me.Controls

Situation: A have designed a form "Form1" which includes a subform
"SubForm1A" and this includes another subform "SubForm1B"  For the
"SubForm1B" I have created a SQL-Query, which only contains records in case
that the a record field is equal to a SubForm1A.recordset.

I have a database that has 70,000 parts and what i  have a form that has a
text box that when you type in the part number and hit  enter it would
populate the other 20  fields of info related to that part and also i want to
put a subform on that  page that will be attached ot  ...

I have a "client" table and a "process" table.
Have to do a form called "procF" and i just want to insert 2 or 3 names from
same table "cliente" so it can show me all adress and contacts of those 2 or
3 clientes, beside all other data that as nothing to do with "clients" table.

Is that possible to create an alert function, that gives an alert
message when a date in Access database is going to expired soon
So I need this function to compare the date in database with current
date

Hey everybody.
It's a simple thing that I want to do. I have list box populated from table.
I want to be able to choose a sertain row from list box and according to
selection put ID field's value to variable. Example below.

I am using a form that is unbound and know I cannot use the Dirty event.
What can I use in its place?

I have a database that is used to log details about received materials, when
a new receipt is entered, I want some of the record detail sent to a choosen
person via the users email when a button is clicked
I currently have a command button "eMail_Btn" with the following in the "On ...

Thank you for taking the time to read my post regardless of whether you can
help or not.
I am trying to set up a user control form which will allow users to access
the application but only with the right registered password per user. Each

I have created a subform based on a table.  Within that table there is a
product name field which retrives a list of product names and prices from the
Products table.  I to use the subform to enter product and then get it to
automatically update the price field.  

Sounds like a strange subject name, but here's what I want to do.
I have a table called BOOKINGS.   In it are all the daily car bookings
- past, present and future.
Each booking is identified by DEPARTMENT (1=DA, 2=Finance, 3=Exec,