There must be an easy way to do this but I just cant put my finger on it (or
find it here).
• I have a form (called FormSearch)
• Within the form header section is an unbound textbox (called txtSearch)

I have an Update statement that refuses to work!
CurrentDb.Execute "UPDATE SalesDetails SET SalesDetails.Quantity =
Forms!Quantity!Pat" & _
   "WHERE (((SalesDetails.LineID)=Forms!Buttons!Text98)" & _

I wonder what's the mistake on that code to trap ALT+S or Alt+z and only the
Enter code works
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
           If Shift = 2 And KeyCode = vbKeyS Then GoTo opened

I have a form based on table 'Evidence' with fields 'ReportNo', 'GroupNo',
'Year', and 'ItemNo'.  All items are entered based on the 'ReportNo'.  
Occasionally, two or more ReportNo's are related cases and are given the same
'GroupNo".  The 'GroupNo' starts with "0001" on Jan. 1 ...

Is it possible to change a continuous subform into single view using VB?
If so, What is the code?
Thanks
rich

I have a form, that pulls in Data, and then takes that data, and appends it
to an email. When I close out of the form, I always get the message, "You
Copied a Large Amount of Data onto the Clipboard.." How do I prevent that
message from popping up?

I have a form and some buttons and a subform
Press the buttons and it changes the subform in the subform control,
which is filtered based on textboxes on the mainform.
If the filter doesn't have any record, I want to show a custom form that

I posted this question to the ActiveX Control newsgroup a few of hours ago
but I don’t see it there so I’m trying you guys. Sorry if it does sometime
emerge on the ActiveX Control group.
I have an entry form linked to a table which has an OLE Object field type

Hi All...
I am new to database programming. I need a help in designing some forms
and queries.
I designed a query which takes a value entered in a text control box in

I would like to be able to automatically insert an ID value in one combo
once another is updated, dependant on the values present in two other fields.
Can anyone help with the code for this please? I'm using A2000 on XP.
I have cboSchool and cboMentor. The same form contains ...

I got a runtime error -#5 on the following code. It works fine on another
computer has the same Access version.
What can be the reason?
Thanks advanced!

I have an Access97 database and have a button on the form to open the
MSAccess Find dialog form.
I use the following code:
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

If I want to compare two date type variables, can I just use '>' and '<' or
do I have to use the DateDiff function?

I have a login form which has On Exit event code for user initials and
password fields.  This code traps invalid data or no data entered by the
user.  But I also want to allow the user the option of exiting from the login
screen if they so chose, without first entering valid data ...

I have a button on my data entry form to duplicate the previous record to
make it easy during data entry.  If a user has several records that are
similar, I want the duplicate record button to send the current record
notification email to a User and then save the current record and ...