I have a form with a query that requires a value to be provided for a
WHERE clause.  I can open the form on it's own and enter the desired
value into a popup dialog without problem.  But if I drag that form
onto a second instead of getting a popup to enter the value access03

I have a parent table that contains information about a sample (when, where,
why taken, etc) and a related table that has records of measurements
performed on the sample (pH, temperature, etc).  My form currently displays
the parent table info with the related table info in a ...

I am trying to develop a data entry form which will insert data into several
tables.  When I bind each object (text fields and combo boxes) to the
respective tables & columns, I cannot enter data in the various objects.  
When the form loads, "#NAME?" appears in the text boxes.  ...

I need to Loop this statement until all records in the tblCheckDetails
that have this SalesID (Forms!frmFXVoidItem!TxtSalesID) table are added
to the tblVoids...How would I do this?
Thanks

thank you
is there any way to color columns in subform data sheet
example
let user change color of every column

I think Access is a great product and I look forward to working with it.  I
am not new to database design but I am still getting up to speed on Access
proper.  Thank you for whatever help you can give me.
I understand normalization issues but in this case I want to store a

I have a form that has a bunch of option boxes.  The user selects the options
desired, and hits the "Go" button (which starts a bunch of VBA code that
drives the process).  After that, a series of queries are run - sometimes
numbering in the hundreds.  A progress bar control and ...

Very simply, I have a form in a very complex application I've
inherited.  On that form is a date field which, if changed, fires off
all the action I need to do (a LOT of it) in the access form. (This is
a Jet database, not real triggers.)  It's set by a lost_focus even

I have a main form . . . frmStudentEnrollment
I have a pop-up form . . . frmPhotoEntry
When the user wants to add a photograph to the main form, they click on a
button that opens the popup.  When the popup opens the Win Open/Save window

I have master form and inside there is subform.
If an event procedure uccur on subform, how can i get refence to the master
form in order to change there things when the name of the master form is
diffrent always?

I have a Front End MDB that runs agains a Back End MDB.  I am converting the
back end to SQL Server.  The front end is too large to rewrite.
I am having relative success, having converted all my OpenRecordsets to use
"dbOpenDynaset, dbSeeChanges" and my "Docmd RunSQL" commands are ...

Here is my problem...
I initially created a form and attached an autoformat to that form.  After
designing the system, I need to change the form's background design away from
the autoformat style and to a custom background design.  I preferably do not

I have a private sub based on an ‘OnDirty’ event.  The event creates a record
in an audit log.  Here is the code:
Private Sub cmbBusClass_Dirty(Cancel As Integer)
userID = fOSUserName()

I have a Database (Access 2003) with a form containing 2 combo boxes one
dependent on the other. The 1st (DME) using Table (DMEBusiness) and the other
(Phone) using Table (DMEPhone). When a Business is selected in my (DME) combo
box I would like for the (Phone) combo box to ...

I have a dropdown box that depends of another drop down box, on the after
update event I have the following code:
Dim sMajorAccount As String
  sMajorAccount = "SELECT [tblChartofAccounts].[HyperionMajorAccount]" & _