I am implementing some "roll back" code into an existing application. When
testing, I have discovered that the roll back was not working with the
intial code I was using in the sub procedure - where the SQL insert was
actually performed... In order for it to work, I had to pass ...

Say if I accidentally made some changes on a cell content in a table in
Access, the whatever changes I made will be saved automatically when I exit
the table. Is there a way that Access will act like Word or Excel asking you
if you want to do "save" or "save as" when you are ...

I have a field in a linked table that only accepts whole numbers and
sometimes i need to enter decimals, but if i enter decimals when i save
it changed to a whole number. How i can fix this problem?, and also
this is a linked table, How i can modify this field? Thanks

I have two combo boxes on a form that are already synchronized; the first
combobox cboCategory allows you to pick between types of clients, i.e. US
Govt, NGO's, etc. The second combobox cboSubCategory uses a table/query to
bring up the list of subcategories based on the selection ...

My understanding is that the GetObject command will let me open any file and
the automation ability in Windows will launch the appropriate application.  
Unfortunately when I run the following code, nothing happens.  I've assured
myself that the event happens and the code executes ...

I want to have my code send the focust to a new record in code. When running
"DoCmd.RunCommand (acCmdRecordsGoToNew)" it does not know what form I am
refering to - What is the syntax for this (the form is
"Forms![ST_Enter_TR]![ST_TRANS_HD subform]")

I use two combo boxes to select birth month (January-December) and day (1-31)
from separate tables in a Data Entry Form. These are text fields which print
fine on most reports but they don't sort correctly to pint a list by
birthdays. I added a field in each table and entered the ...

Is there a way to shutdown access using a runapp command?

I simply need to provide a fiscal quarter value to a date by month. I've
tried doing this by calling a function within a query and by programming an
event procedure within the form, but can't get the syntax right.  Here's one
of my tries

Is there a property that gives the path where the data files are located in
a split database as the Currentproject.Path gives the path of the application?
Thanks
GL

It's me again.  I can't unerstand why I repeat the same process which worked
the first time...now it doesn't.
We have several thousand client entries in our database.  The users have
requested that I create a combo box, which gets it's information from our

I have an application which uses a form qer TeeTimesForComps to allow users
to reserve tee times.
when a record is deleted by a user the following code runs on the before
update event, and opens a second form frmtblPWLOG which determines if the

I'm new to Access and was trying to figure out how to copy a field value
from Form A to Form B. Klatuu did his best to help me but the expression
didn't work. Now I think I've figured out why the expression didn't work, the
variable vStudentID was  null.

I have a form that applies a filter in the onOpen event. If no records are
found that match the selection criteria I want to throw a message that
explains why the user is now looking at a blank form.
I've tried several different events but not matter what I do the message