I have a form that all the calculated fields worked fine. I screwed up
setting up the User Security and it wouldn't let me back into my own
form. I did e-mail this mdb file to myself before making this snafu. I
have extracted the file and now I can get back in, but it seems like

how can I write a query that specifies the value of a parameter that
exists in a subquery.
eg
SELECT field FROM qrySUB

Not sure which forum this belongs in:  I am creating a table in order to
pass the contents to Word in a mail merge.  I do this because the data to be
merged depends on a selection from a form.  The query is:
SQL = "SELECT qryDealerMailMerge.ShowID, qryDealerMailMerge.ShowName,

I have a form named Myform with two subforms.
In one subform i have a field i want to fill with a value calcuted as sum in
the footer of the other subform.
With Access2003 i used this as Control Source for the field:

Because we have people working a varity of shifts, including night shifts,
our working day starts at 0600 and finishes at 0559 (or 2959 for calculating
time sheets and hours worked).
As with first day of the week, is there anyway I can set the first hour of

I have a form with about 12 entryfields named entryfield1 to entryfield13.
I must asign a value to this entryfields...
can I put the "entryfield" name in a loop like:
entryfield+x

How do you hide the labels on a report when the text box next to it is null?
And does anyone have the code to make the alternating background color for
each record result in details?

I am having difficulty using VBA to set a value  for a combo box
control that resides on a subform based on the value in a text box
control on a parent form.  I know how to do this for textbox controls
but Access 2003 does not seem to allow me to do this with a combo box

I am trying to create a new record in tblRoles after the user enter a new
project number in a form based on a different table. The code should filter a
record from tblRoles that has the user info (based on userid) then add the
info on the bottom of the tblRoles with the new ...

I'm using a main form with listbox to look up field selections from a master
table of patient values and using that value (in this case it is the
patient's location).  I want to use a subform to display all the patients on
that ward and allow entry of a new record in another ...

Hello.  I have been struggling with this project for over a week.  I
think/hope I am almost done.  I am using the below code on a main
form.  I think everything is working properly except the apply
filter.  I have one of 5 subforms open on a Form OnCurrent and "Type"

I've made a combobox to search for people in a form. It works, in a way, but
not totally. It sorts by Lastname, but I can also se the persons first name
in the combo.
The trouble is that if there are more people with the same lastname, the

Is it possible to open up an external program from access VBA?   When I click
cmdCalc, I'd like the Windows calculator (calc.exe) to open in its own window.
Thanks for any clues.
------------

I am trying to append multiple selected values from a listbox to a
table.  Property set to Multi Select (extended).
Access 2007
Form: Main

When I try to program a message box with multiple buttons, i.e. YES, No or
Retry, Cancel, I can program one button to do what I want, but I can't get
the second button to do anything.  I'm going to include the code that I've
tried with a message box I've created; can someone tell ...