i have the following query setup in VB. and i want to use the results to
insert into a word document (have already ready set up bookmarks if needed)
could somebody please explain the best way of doing this without the use of
access tables as i want the process to be used by ...

I am using the following code to link tables from a back-end db, it doesn't
link to all of them for some reason and the ones that are linked appear
twice.
Private Sub Command5_Click()

I am trying to loop through code and pass a value to a field on a form. The
value in this field is then used as criteria in a query. The form field is
populated yet the query does not seem to recognize the value on the form and
returns "0" results.

I have a Access Database that I'm writing code, that will preform a If
Statement:
When "Vendor" or name is choosing, on click run the Query. I have several
Query save for each Vendor that has defferent calulation with in the query. I

I have a Schedule db opened and it runs a routine by timer event in an open
form every 15 minutes to update files contained within it.
I have another db that links to that db's tables. If I open the Schedule db
first and then try to open the Reports db I get the following message.

I am attempting to create a way, in access 03, to store simple if statements
in a table which are rules for various results. I want to be able to pull the
text of the statement to use in a visual basic statement to produce the final
value in a report.

I'm trying to program a command button cmdImport that when user click it
(after check all the conditions such as check table if it existing, file path
is correct, file type is right) it should read and display the columns in
import file and allow the users to match them with the ...

First off, I'm using Access 2003 (in 2003 format) and Windows 2000
workstation.
I have a table that I am storing daily counts of different types of
business exceptions.  In order to count those exceptions, I use code to

I have a table that is collecting warehouse activity via timestamp.  So
each time Tech 1 scans a package a time stamp and transaction number is
placed as a row in the table.
Activity ID (autonumber)

Can someone tell me how to create a recordset from a recordset?
dim db as database
dim rs1 as recordset, rs2 as recordset
set db = currentdb

Access 2003
I have a main report that contains a sub-report in the Detail section of the
main report.
I would like to sum up a field in the Sub-Report and display it in the foot

Is it possible to create a table in a back-end database using code that is
run at the front-end?
Regards,
Ron.

I moved my tables to a seperate database and linked the tables. Now I am
getting error 3219 but don't understand why. I have a function the      Set
RST = db.OpenRecordset(bidTbl, dbOpenTable)
is getting error

I have a MsgBox popup which tells the user that the record has not been
saved on an unbound form if they try to close the form without posting. I
was hoping to use the CancelEvent function to stop the form from closing if
they picked cancel except I get a Run-time Error 2001 "You ...

To allow a form to load completely before continuing processing it was
recommended to change the form a dialog. I'm having issues with code
execution and am wondering if the code is being suspended by the dialog box
(which reports progress). Reading about the dialog box I found