I'm using the following code to set up a recordset of a query (stDocName)
with a criterion.  The creation of the recordset works fine. The problem is
in the recordset there are three records yet the code below sets the
intRecords to 1.  rs.RecordCount returns 1 when there are ...

I would like to export a query as a text file when a user clicks a command
button.
Any help would be appreciated.
Dylan Moran - Melbourne Australia

I'm new to Access 2003. I am developing an application in Access 2003 and
have encountered this error message. What is the work around or fix for this
problem. It happens when navigating between records in a first level subform.
Thanks,

Hi all, I'm trying to create an inventory program that will accept
information from an input screen and afterwards be able to upload the
information back onto my 400 box. Let me first say that I'm not a total
novice to Access but after this episode I'm starting to rethink it. So

I have 2 calculated fields, one in a form and one from the subform. I'm
comparing the calculated ending dates as follows:
Private Sub contract_end_date_BeforeUpdate(Cancel As Integer)
If Me.CalcEndDate([Me.Term_type], [me.Term_mos], [me.Acceptance_date]) >=

I used the Book Collection template on the Microsft website to begin building
a db.  In that template, there is the ability to double-click on a drop-down
field and pull up a blank form for adding new drop-down values.  I have tried
duplicating the double-click event procedure to ...

I had a form link by by a query it works fine. i want to add a text box
"unbound", so i could enter a number any number. I want this number to be
save in the field of my table. can any one help me the code for this ?
lets say my table name is :  table1

DoCmd.TransferText acExportDelim, , "myquery", strSaveFileName
The above code I am using to export a query. The output is as follows.
"jbloggs@domain.com; "
"kbloggs@domain.com; "

In Access 2000, I have a situation where I would like to query the display
value of a combo box.
This is a typical combo box where the bound column (col 1) is the primary
key of the table from which the display value is selected.  The display

I wrote a procedure for comparing queries in 2 different databases (part of
a version control strategy) and *thought* it would be a slam dunk to test
the queries in DB1 for existence in DB2, and of those which existed, test
that they both had the same field names. Apparently the ...

How many error handling add ins are there for Access? I know of three
Office Developer comes with one
FMS has one
aadconsulting has one

I have a form showing jpg images.
when going to next record a dialog appears in the middle of the screen with
text:
Importing C:\pictures\pic1.jpg

what's the VB instruction to redraw a listbox after I've
changed the SQL in the row source?

I have the following code attached to a command button on a form.  When I
click on the button, I get an error message that says: Syntax error in
INSERT INTO statement.  I've checked everything I can and can't find the
error.  Please help.

how can i avoid user to open an application that is
already opend?
thanks