Search results

Doesn't seem to be working. This is the code I'm using. (The CCMC# is a number, not text.) Do I need to name something "PrintAllPatientsReports"? ----------------------------------- Private Sub Command0_Click() PrintAllPatientReports() Dim rst As DAO.Recordset Set rst =...

Thanks! Am trying! Not too familiar with coding or VB. Can I put that code in on the "on click" build code part of a command button I create?

The macro is actually to print several reports on patients. I want to run all the reports for patient1, then loop back and print all the reports for patient2, etc.

I have a macro that consists of several queries. I am looking to have it run through all the queries based on records in a table. (i.e., run all the queries from the 1st record in the table, then all the queries using the 2nd record in the table, etc.) Is this do-able?

It is a single MDB file. Well, actually 2 files... I have the data file which links to the database.

Our office runs on a pretty large Access database (v2003). We are on a large hospital network and have about 15 users for our database. It tends to run VERY, VERY slow. Are there other options?