Hi, I got a table resulting from a query's one to many relation.
IE:
tblTest:
1  empty

I am using a form for data entry to a table.  Key is social security number.  
The majority of the time the data entered will be a new record and will be
added to the table - no problem.  However, occasionally the data to be
entered is actually an update to an existing record ...

I'm updating a Access-2000 format database that was created ages ago to have
timestamp fields for when records are modified via the forms.  
I have created the fields for four different tables.  As well I have
successfully added a macro ("LastModified") to three forms via either ...

I have a form [CATCH] with a subform [SAMPLE].  Each time I enter a new
catch, I need the sample number to start over at 1 and progress to 10 (we
always enter 10 samples for each catch).  So, my SAMPLE table will look like
this:

Dear Friends
I have one sub form in my form
Whne I open main form allowedit will be disabled
subsequently if user want to modigy data they can press edit button in the

Upon trying to email and xls from my forms button to an outside email domain,
I received back en error stating it was undelieverable due to virus detected
(CVE-2006-1309).  This database has been running for almost 2 years with a
weekly xls being generated and sent to an outside ...

'Save Form with required fields
Private Sub SAVEForm_Click()
On Error GoTo Err_CloseForm_Click
   If [Oil_Filter Change] Or [Air Filter Change] Or [Other Maintenance] =

Following is the code I am using to run a query based on the criteria from a
multi select list box. Everything works perfectly until there is an
apostrophe in the criteria. Can someone help me with a workaround.
This is my code

i got a database that is being opened in Acc 2000 and Acc 2003. sometimes
when i made revisions on my code, this error shows and it points it to
txtUser.SetFocus
ERR:

Hi, all;
I have a database split into FE/BE to make it easier for someone else to
enter data while I work on the logic of the forms and queries.  Recently,
when the main "Edit stuff" form opens, the code breaks on one of the lines

I'm using a form to give a summary of the dollar values of different
transactions. I would like to show the totals of the various subtypes
of a certain transaction type, then show the grand total of each
transaction type. Example: All "Incoming" items have a transaction

I designed a database that tracks my family's auto maintenance. I created a
tabbed SubForm that works well. The tabs are Oil Changes, Maintenance, Tire
Rotation, and Emission Control.  Except for the Maintenance Tab, I would like
a query to pop up on entering each tab that tells ...

I have a form of which I enter in certain information and depending on one
field I need to have a certain report open. I had this working at one point
but it got deleted and for the life of me I can't remember what the correct
code should be.

I have an applcation using datetime until minutes. I need seconds
always zero.
I just wonder any function that can supress seconds?
Your information is great appreciated,

I tried to modify a form in Access 97 that uses a ListView. But I didn't see
the General Tab on the Custom properties. How do I display the General tab on
the Properties?
Thanks.