I have a query based on the Employees table.  The query is sorted by
LastName, and is used as the record source for an Employees form.  One of the
fields is a check box bound to a Yes/No field named Inactive, which is used
to indicate employees who no longer work here, but who ...

I'm a VBA beginner and in the BeforeUpdate event, I'd like a msgbox to appear
that asks the following question.  I'm not sure how to write, in the code,
that if a user clicks "yes" I want the msgbox to close and the record to
continue saving.  If the user clicks "no" I want the ...

I have a report that needs to be the focus after a database starts up. The
switchboard manager has been used.
It doesn't seem to matter where I put the code to make the report get the
focus (Docmd.SelectObject etc...), the switchboard always pops up in front.

I am using a form to record check payments and would like to view the invoice
amount while I am entering the payment.  Since a single payment can be
applied to multiple invoices I need help with the following DLookup
Dim strFilter As String

Has anyone been able to distinguish the reason why when a tab control is
added to a form and a record is either added or edited, it will keep the form
in edit mode? This mode doesn't allow navigation to a next or previous record
or even a new record without adding:

I have a Users table, and each user can be a member of one or more groups. I
used a single integer Group field, and assigned a bit to each group they
could join (group1 = bit1, group2 = bit2, etc.) That way I can just use
bitwise operations on the field as they join or leave ...

I have a subform (Subform 1) within a main form (Form 1) that is joined by
CustomerID.  The subform contains information regarding vendors used by each
customer.  A user can enter customer-specific vendor information on the main
form and then use the subform navigation buttons to ...

I have a subform within a form (linked by a common customer ID) that has a
series of combo boxes.
The first set of combo boxes has a list of vendors, the second set of combo
boxes has list of products.  The combo boxes are controlled so that only the

MS Access 2K, Windows XP
====================
Hi,
I have separate forms to enter data for the following entities: Meeting,

I'm wondering to know how can we make it possible to enter critical data
twice in datafields in form (i.e: Invoice date, Invoice number)?
This would help to prevent entering of data by mistake.
Thanks,

I have a form that uses a function to calculate a date field based on the
data that I am viewing.  Each time I look at a new record, the text box
blanks and recalculates the same data over & over again.  Can I get the box
to calculate only once and show the data without blanking ...

user has to type the correct user name into a text box of the startup form
in order for the program to run
.... how can 'hide' the input so that only ***** are seen ??
Gina

I can't figure out the coding error that the debugger catches on my form at
startup (the code runs as a current event)--the last line is highlighted.  
Can someone figure out my problem.  Thanks so much
If IsNull(Me!SaleExpires) Then

How do I reference the tag property of a toolbar control.  Using Access2003
I have created a toolbar that lists forms. Click on the form name, the
current form closes and opens the chosen form. I would like to do some
things via code based upon the Tag value for control on the ...

I am distributing a Access2003 database with help files.  The hhctrl.ocx
file does not seem to be registering during installation. I'm using a 3rd
party software (Installer2Go).  I place the ocx file in the Windows\System32
directory and check the box requesting Self Register as ...