I am opening a report from a form using openargs:
DoCmd.OpenReport stDocName, acViewPreview, "PublistLayoutFilter", , , stArgs
I want to use the openargs for a text box in a subreport linked to the
report, but I keep getting a run-time error. I suspect I am not correctly

I have developed databases using MS Access.  I am afraid of end users
copying my creations for their own advantages as the databases are files
and not applications.  How do I make my databases into application?

I use the following code to open an external db and try to find a matching
record in a table in that db with one I declared (Variable1).  The problem
is an error tells me Operation not supported by object when I get to the
FindFirst operation.  Is there an alternative or is my ...

Hello,
Please help with this code, I got an error: "Syntax error (Missing operator)
in expression"
   .FindFirst "[inv_start_date] = #" & Me.inv_start_date & "# And " _

I am wanting to have a form with 1 field that once the criteria is enter
they can click a button and see the results on the same form.  I am using
access97.  Here are the problems I am encountering.
I have been trying to use a text field on a form that is the parameter for

Is there a property or something that can tell you what has focus?
I am going into a subform and on entry, giving focus to a list of
selections, and then returning to the subform.  But I need to know what field
should have focus upon returning.  I am looking for something that ...

I am stuck
I have developed an access app wich under certain circumstances will display
a msgbox using the standard msgbox function. I am now trying to implement
timers for the application as a whole so that it is automatically closed if

Can someone find my problem!  This code dies the .UPDATE statement in
function called SUBLOAD-RC20RW-NAMES20.  Error # 3265 with error description
of "Item Not Found In This Collection!".   I need to read from table A,
(first record, then separate data from record A into possibly ...

Hiyas
I've got an Expense Report form in Access for our International travelers.
Sometimes (quite often, really) their receipts are in Euros or whathaveyou.
I've a basic subform inputing the expense data, like this:

Hi all:
I have an Access form with several sub forms. A user can select items from
any sub form to be included in yet another (different) form. Once the user
has selected an item it is removed from that sub form. If the count of

I try to search a record then passing case number to another form using
openargs but some how it is not passing ? Here piece of my code:
On the SEARCH FORM onclick event I code:
DoCmd.OpenForm "FrmEdit", , , , , , Me.CaseNoBox

MS Access 2000, Windows XP
======================
Hi,
I have a multi-user database application on the server. This database has

Please help.  I have a form that I had hoped would open a recordset, allow
the user to select the query results through option groups, and then display
the results or link them to a graphical display in a excel/word document.   I
have been working on a very small part of the ...

How do I change the color of the highlight bar in a list box?
David

So that my mouse wheel does not keep adding blank record after blank record,
i have set the following:-
Allow Edits = Yes
Allow Deletions = Yes