I'd like to have a text box display certain information when a particular
selection is made in a combo box as well as the table.  For example – I have
6 options in a combo box.  Depending on which option is chosen there are 6
different corresponding pieces of information that I ...

I have a multi users application and need to update every single user if
there is an update.
Are there any way to do autoupdate there client mdb?
Your information is great appreciated,

I have a field in the main DB that is the record ID (autonumber) which is not
displayed on the parent form.  But because I have a table relationship setup
with the child table I need to access this field from child form when
inserting records into the child DB.  It works if the ...

I'm trying to create a calculation of two fields in the design view within
Access. I'm trying to perform a division calculation of one field, by
another, Can anyone give me some pointers on where to start? I'm not super
familiar with the syntax allowed to perform this...

What is the difference between (and is either preferred):
Docmd.RunSQL "SQL statement"
and
CurrentProject.Connection.Execute "SQL statement"

I have a calculated control in the footer of a subform to provide a total of
items in the subform which are then transferred to the main form.  Changes to
a record in the subform do not seem to be reflected in this control until
some point after the subform After Update event has ...

i have a form where i want it to drop information into a different table
based on a choice in the combo box. this was working but now it isnt. i am
getting an error of a key violation on the SQL line.
here is the sql:

I have a formula in a Report Footer that I would like to calculate on 2
criteria.  So far I have the following which counts all Bundle RES ADSL 1M
Rate Plans.  I would like to have these counted only if the Dial Up
Number=225.  I have tried putting AND at the end but it is ...

I have a subform that allows me to enter records in table
"tblServices" that are linked to an individual "Guest Name".  It is
embedded in a form linked to the table "tblGuest" for the "Guest Name"
When the user enters the Guest form, I have the subform automatically

I have the following code that I know can be rewritten to be a little more
graceful.
           If Forms(stF)!lstRulesTableName.ItemsSelected.Count = 1 Then
               For Each varItem In Forms(stF)!lstRulesTableName.

Is there a way to use a checkbox on a form to select which records you
want to include in a report or append query?  I don't want to tie them
to a table because I don't want to keep the checkbox data after I'm
done.  Is there another way?

I'm trying to debug a multi-user access feature. The only way I can do this
is to know the execution path taken by each user. Is there any way to get
this out of Access? Setting break points wont work because this code is time
sensitive. Essentially, I am trying to code a system ...

Ok thanks for the replies however I don't know VB or how to implimentit.
Is tere any to put a "code" in the General area when in design mode?
Retarmy AkA Johnnn

I have a main form which has a subform on it. in the table of the main
form I have
ComponentID --key
item#

I have two tables: tblLicensedPrem and tblLicensedPremHistory (these
tables are identical).
tblLicensedPrem contains records for licensed premises.  Over time
details of a licensed premises change: e.g. the premises changes its