hi, i need some help on queries and sorting data. i have a query based on
data from two separate tables. the query is called "qryEvents". the
information in the query is basically information about events that are
coming up. i need to create an sql statement or something along ...

I'm using a before update event to validate data entered on a form.  If
data is valid my code works fine.  If data is invalid I want the event
canceled and what ever was entered erased. My code works fine up through
the msgbox, but then the data is not erased and a default message ...

Please help if you can:
I have a combo box on a form (frmTest) that contains zipcodes.  In the
'notinlist' function, I have working code that asks, "Do you want to add
'11122' to the zipcode table?" Yes/No.  If you choose yes, then the data

on closing of my form I get this message
"the data was added to the database but the data won`t be displayed in the
form because it doesn`t satisfy the criteria in the under lying record
source"

I have six Users that will update the table.  I have a password pop-up box
to enter a password in order to open the form and edit records.   How do I
give (6) separate passwords to each User and then auto populate the form
with the user name, date and timestamp while they edit each ...

Hi to all,
I would like to use the Me.NewRecord but cannot it, when I compile it give
me method or data member not found
What is the reference I need to use for this

I hope this can be done.  I have a list box and a command button on a form.  
The command button opens a new form to the selected record in the list box.  
I want the command button's enable property to be false when the list box
loses focus.  When this happens, the button cannot ...

Access XP
Windows 2000
I'm looking for a way to disable the mousewheel when users are on a form, so
that scrolling the mousewheel does not change the active record. I found the

Access 2000
SQL tables on the back end
I am trying to create database without linked tables
I am openning recordset directly from SQL server

Is there a way to link a checkbox on my main form to a text box on a subform
within the main form.
I want  Text1 (on Subform 1) to only be visible if Checkbox 1 (on Form 1) is
checked.

I have a text box-(MainForm) that is reading a value from a subtotal text
box-(subform) from a subform.
When the form is opened initially it always has an "#Error" in this text
box-(MainForm) as a result of subtotal on the subform not having a value to

I am trying to change the Case Number field which field type is Number
to autonumber field in multiuser envirorment.   I have to keep the old
data in the table and when users open the CaseAdd form, it will
generate Case number automatically.

I have a fairly small computer inventory database.  It was originally created
in Access XP, but I am currently using Access 2003. It includes the tables
PC, License, and Software.  PC and Software have a many-to-many relationship,
joined by the table License.  In a report, I want ...

I have a Main form with two subforms Sub1 and Sub2.
I want to set the RecordSource of Sub2 from the OnGotfocus event on Control1
on Sub1.
My code is:

I'm very new to VBA and am struggling with a bit of code than I wonder if
someone nice could help out with!
Basically I want to write code that says if one of the entries (lets call it
Entry10)in the combo box on FormA is selected then FormB will open.