I'll confess that I havent exactly tried everything I know on this issue yet,
but deadlines mean I could do with some help quickly.
I have written a large applicatoion in Access Xp (circa 150 tables , 200
forms etc) and all is going very well. I am a very experienced Access

hello all...
I have an orders form that I use for new order entries, but I want to
"connect" it to another table so that I can enter shipping details on each
order as it arrises?

I have 5 fields on a subform (datasheet) - one of which sometimes has no data
- sometimes incorrect data. I would like to make the field concerned into a
combo box from which users could select a new/different value whilst leaving
all other records/fields on screen. Is it ...

I implemented command buttons like "Open" and "All" on frmWorkOrders so
users could view the open or all workorders.  This is done in VBA code by
setting the form recordsource to the queries qryWorkOrdersOpen and
qryWorkOrdersAll.  This is my first Access project, and I did not ...

I have a form that we regularly print. However sometimes we require that the
tray is set to the Automatic tray and other times to print from the Manual
tray. Is there an easy way to change this setting through VBA?
Thanks for any assistance.

I have just added a bound text box to a form.  The data type is text.  The
"Default Value" property has been set to:
"=(Select [Desk] From [qryUserDesk])".
This query correctly returns a distinct value that I want to use as the

I have a field in a form which searches a patient list based on the first
letter of the last name and the last 4 digits of social security number.
when i select the patient form the list that i want to view, what code do i
use to set that patient as teh record source of the form. ...

Not a question, just a comment; and if I can't talk about Access with all of
you, well, then who *will* listen to me? ;)
Today I was trying to make a small modification to the "Check Out" form I
have in my school library application. I've always thought the process I was

i got the said error when i tried to run this code and the "Patient Number"
did not exist in the underlying table ("Concomitant Medications")
 Private Sub Add_Record_DblClick(Cancel As Integer)
On Error GoTo Err_Add_Record_DblClick

From a control on a form, I select a date.  i then need to select all
records within a tables, where the date selected matched a date field, and
then preview a report.
What is the best way to select the records - predefined query or dlookup or

I have a customer form with a subform linked by an id. I want to perform an
action on the subform when I navigate thru the customer using navigation
buttons.
where would i put the event. I have some unbound fields on my subform that

I have a report program that computes and stores values in global variables.  
Is there a way to print these global variables to the report form together
with the records that the report program generated from the query.  
The records generated by the query printed on the report ...

Am confused on how to store a SQL Count to a variable...
What am I doing wrong here??
Dim intHelp_Id As Integer
intHelp_Id = DoCmd.RunSQL(" Count(SHD_CALL_LOG.HELP_ID) " & _

My form has an unbound combo box that when an item in the combo box is
clicked, the form is populated with data from that record.  
How can I protect this list from being updated or changed by the User, but
still have it available to click on to populate the form with data records?

If I want to use the following code I get a run-time error 438. I am
assuming I am missing a reference but do not know which one to include
for this.
Dim obj As Object