I created a database in Access 2000 where it has a form that shows data on a
business. There are command buttons on that form; Contacts, Addidtional
Information, ect. When you click the Contacts command button the Contacts
form opens showing only contacts whose works for that ...

I have a subform that I enter data to update training files. Once I have
entered the data it can not longer be seen (although it is in the appropriate
table). The data is entered after using a cbo to select the correct reference
to update. (ie. I select safe work procedure 1 - ...

The following code always results in the first command being executed,
regardless of the Item, Anthocyanins, Liver_Lipids, Plasma, or ORAC being
updated.  Can someone help me diagnose my code errors?
Private Sub Combo0_AfterUpdate()

In my VBA code I have a DLookup statement which is:
Private Sub custid_AfterUpdate()
Me.CustomerName = DLookup("[Customer Name]", "Customer File", _
      "[Cust ID] = " & Me.CustID)

I want to have a form where I can select from a combo box among "Service
Types" (there are three of these). Then, based on the selected type, I want
another combo box to display a list of the "managers" within each service
type. (there are sixty managers in each service type). I ...

I don't think you can use a continuous form to display records from left to
right, but correct me if I'm wrong.
What I'm trying to do is create a form which shows up to 6 years data side
by side, each record holds results for 1 year.  So is there a way I can

need help,
Is it possible to recognize text when i type in a form, like in excel or word.
ex: if i have saved name in my table as ex "totte", and when i type in a
textfield in my form "to" i want it to find "totte" automatic.

I have a main form and 2 subforms. Subform1 links to the main form and is in
datasheet view which shows a list of items for the individuals in the main
form. Subform2 is a form view of details for the list of items in subfrom1. I
want subform1 to be linked to the main form as it ...

I have a client that has installed office 2007, my application was developed
in Office XP.  Now when he opens the program Access 2007 starts and he gets
the message "A Potential Security condern has been Identified etc" and when
he brings up some of the screens he get the ?Name ...

I have a main form with a subform. The main form has a combo box. The drop
down list is used to select an item which populates the subform. All works
as it should.
However, the selected entry in the combo box is highlighted (as it should

I have a subform and I'm using the following statement in an event
Dim FeeRenewalDate As Date
FeeRenewalDate = DateSerial(Year([Me.FeeDate]), Month([Me.FeeDate]) + 12,
Day([Me.FeeDate]))

I am struggling with the following problem....
I Have saved following string in a field :" "EUALL" + [SKU]![loc] "
I want to use this field in my query design, for example in an if-statement.
How can I get Access to understand that this is SQL-code instead of a string?

I have a subfrom which displays a number of fields based on a selection in
the main form. Is there anyway in which these records can be viewed one after
the other on the datasheet view rather than having to click the navigation
bar to to the next record. Anybodies assistance here ...

Access 2003
I have a TabControl added to a form
on a page (Page3) of that tab control I have added a form
There is also a buttom on the page (but not on the form)

I have a standalone form with a page that contains a subform linked to a
query.  In order to update the subform data, I created a macro to run several
queries that will ultimately update the query the subform is linked to.  In
my macro, I close the main form, run all of the ...