Presently I am using the following code, as the "onClick" event of a Form
Action button. What it does is print out a single report of the record that
is presently on the screen only. It works fine, it simply prints out the
record on the screen when the Form Action button is selected ...

I wan't to create a PDF document automatically from Access, and I have tried
to use the way Keri Hardwick explains on:
http://www.mvps.org/access/reports/rpt0011.htm
But when the code reaches:

I need to copy new records from an access table which can potentially have
records added to it all the time by users. I figure I can add a flag for
records that have been copied already that can be set after copy. The
problem is that in the time that I copy all new records using ...

Can anyone give me a solution to loading a flat file with an extension
of .txt into an access table automatically, aka user clicks a command
button.
Thanks

I work for a small transporting company, our clients send us  pick-up
adressess by fax and by e-mail.
We give every pick up order a number, chronologically in the way we
receive the orders.

Hi Stephen,
I'm trying to use your mousehook off...and thanks so much... it's such
a blessing that you share with the rest of us.  I have the dll in the
same folder as the database and placed the button code in the load

I am learning Access, and have one question on relationships.  How does one
handle establishing a relationship that could be one-to-many, going either
way between two tables?  Example:  One table lists home addresses.  Another
table lists kinds of correspondence (letters sent).  ...

Right i have tried but failed!
I have a Form and a subform
Fields in Sub form are:-
Planned - Checkbox

I want to find if there is a different way than the way I am working now.
Lets say I have a table, tblCustomers containing address details.
I want a report with all the customers from a specific state. In order to
generate that, I create a form, I put a combobox with the states and ...

I have a incremental search box that has been working fine for a couple of
months but is now acting up.  This search box is from the cd that comes with
Getz's book, so I did not write it and have only a superficial understanding
of how it works.

I have a button on a form that outputs a report to word.
While it has been working well for a while, today it is not.
The behaviour now is that it endlessly outputs pages to word. There
are just 63 records (report pages) to output....I hit cancel when the

I'm wanting to build some 'libraries' of functions and classes that  I can
share around between various front ends which all share a common backend.
I realise from the archives, that this has been discussed a little in the
past, however I just want to confirm my understanding on a ...

I'm having a brain blockage day....
Scenario:
Search Form with 6 text boxes
Query has same six fields

I am successful in retrieving the image from the table (.TIF), however, the
retrieved file does not work. It looks like an image file - extension, size
and all, but the image is not visible. Any ideas? I'm including the first
few lines (image opened with Notepad) of the file below.

Sorry for the cross post.
What is wrong with this code?--ado recordset to populate a collection--see
reason below
   Dim myCol2 As New Collection