I have an MS Access 2003 table with 2 data fields.
Fld 1 ids records within common groups with repeated value in records
belonging to that group.
Fld 2 has sequentioal history information about unique groups.

I have forms that I have created which have filters on them to only display
certain records.  What I am trying to do get the number of records that get
passed through these filters.  I have applied the filters in the properties
of Access and I am trying ot get the number of ...

I have a button on form "teachers" (containing field ID) which I want to open
a form "projects" (containing fields id1 and id2) where either id1 or id2 = id
I have a button which opens "projects" when id =id1, and one which opens for
id2=id. The obvious solution would be just to ...

I copied an Access Datebase from one of my computers to put it on another one
and now the program will not run. I get error messages. Help please!!!!

Ok I have read all the posts that give this answer
Maybe try something like:
Function import()
path = "c:\import\"

Even when I set a form's properties to AutoCenter it still aways comes up in
the upper left section of the window.  I thought AutoCenter was supposed to
make forms locate in the center of their window.  Does anybody know why this
isn't working for me?  Thanks

I'm confused with the following problem. I have a database in which I let
some procedures run during evenings and nights so that they would be ready in
the morning when I'm back at the office. Now, it happens sometimes that the
procedures stop running because there can't be found ...

At the moment, we are in a state of change where some users are still on
Office 2000 and others have been upgraded to 2003.  All we be upgraded within
the next couple of months.  I have been upgraded, and herein lies the problem.
We do a lot of communication between Access and ...

How can I respond to the BeforeUpdate event on a subform?  It is not an
available event when I choose the subform object in VBA.
Thanks in advance,
Emily

I have an unbound text box for users to input data. I want to limit the
input string to 50 chars. How do i do this on an unbound control?
I also like to create a label that shows the string length as the user types.
Thanks.

How can I make it if this statement below does not find any records to
continue on and not get an error and stop running the code?
vSql1 = "Select sku from pm_f where sku_type = ""NORM""
Set db1 = CurrentDb()

I would like to do a select query based on a list of if, then, else
statements. What is the syntax in an SQL select query?
Thanks in advance.

How can I supress the message saying that my app can't append all records
due to Key Violations? I only want to suppress the message and allow the
query to run anyway.

I am seeking a method of changing an event procedure in a ADP at the form
opens, pulling the code from an SQL Table, so that I can update the Timer
Event without updating the client.  I have searched and searched and
couldn't find anything to help me.  All I need is to create a ...

Private Sub Lot_No_AfterUpdate()
'declare variables
Dim dbObject As Connection
Dim rst As Recordset