I am trying (and failing) to open a query which contains a parameter
(named ‘myprop’) and export the results to Excel. The problem seems to
be defining and opening the recordset with parameters. Any help would
be greatly appreciated. Here is the code:

All,
  I currently have some vba logic behind an Access form that sends out 1 or
mail email. I used some code that I got off of Tony Toews' website. What I'd
like to add to this code is the ability to include a graphic image (logo) at

I have a query with a date field.Then I create two more
column, Month:Format([DateField],"mmm") and
Year:Format([DateField],"yyyy").
The criteria of the month and year column are come from

I have a form that includes client information and a subform that includes
associated purchase information.  All of the records are available, and a
user can navigate (next, back) through the records.  How can bring up the
form (and associated subform) for a particular client, ...

I am trying to get a "Yes/No" Combo box result to initiate a GoToControl.  No
luck.
This is what I have so far:-
Private Sub EverHiredTemporaryHistologist_Exit(Cancle As Integer)

Access 2003
I've got a main form "frmMain" and a "subform "sfrmFindings" on record 444
of frmMain the subform "sfrmFindings" I have 12 records on the subform for
record 444.  I have a control "FindCorrCompleted,"  this control is a primary

Error telling me that the action or method needs a Control Name argument.  
What does this mean? HOw do I fix it?
Sincerely

I send a message to descripe a problem with pictures and no one answer me
for long time, can you help me

I want to move from the FundNumber textbox on the main form to a subform.  
However, if there is not a value or text in the textbox then the textbox
keeps its focus.  But, what is happening is the focus is moving to the
subform when I hit tab button on the keyboard even when the ...

I attempted to create a form that links to several different tables.
I entered all the fields, and they are all pointing in the right
directions.  I opened the form in design view and edited it to look
professional, but then when I saved it and opened it in form view

I have a form with a subform, I want on the choice of "Yes",  in the Combo
Box, for the tab order to change to  a txt box in the sub form of the current
form.
I am often confused by two points. (And possiably more, the unknown unkonwn,

Can I highlight multiple lines of code and comment them out all at once and
vice-versa?  If so, how to?
thank you

I have a form which is based on a complicated query.
I'm using MS Access 2003 and I am try to update the fields of the form
according to a combo-box value change.
I have creaded an event handler using VBA for the (After-update) event that

Access 2003
XP SP 2
I have a form used to collect and edit information about our vendors.  One
field on the underlying query/table is a Web site field, formatted as a

Is there a way to designate the name of a column rather than the index
position on a combobox column, i.e.
Me.cboMybox.Column("columnName")
  rather than