SELECT Events.EventID, Events.EventName
FROM Events
WHERE (((Events.EventID)<27))
ORDER BY Events.EventName;

Want to automate faxing of multiple reports from Access (&Runtime) running on
XPSP2 machines with a shared fax printer on 2003 Enterprise Server (not
Exchange).
Have following code mostly from MSDN Windows, Networking, Communications

I am trying to use an Export function in my Access 2007 database so my users
can export their data. Using a Macro I can export to Excel and everything
works great, except one of my fields contains an attachment. A photo to be
specific and this data is lost during the export. Does ...

Here is the scenario.
We have a large database that is going to be split with up to 8 users.
This database consists of over 2000 nurses.
I need to have a piece of code that is always refreshing to check if the

I have due dates in a table and my boss wants them to be put in a calendar
format.  Could you tell me if this is possible and if so, how do I do it.  It
has been seven years since I programmed in Access and I know the information
is back there it is just recalling it is the ...

Is it possible to put a Timer on an Inputbox?
I have a DB that imports a series of files from a folder and the user is
required to Input a Received date for each file.
Sometimes the user leaves the App running overnight if a large amount of

How can I assure that Access adds a primary key to my imported Excel sheets?
I'm currently using this command structure:
DoCmd.TransferSpreadsheet acImport, , "All FANs on P2", strFERS &
"P2_Raw_Dis.xls", True

What code do I write to cut from a text box in a form?
And what code do I write when I want to get the os version or name

This code has worked perfectly for years and now suddenly causes an error at
the rst!AddNew line.  
3251 Operation is not supported for this type of object.
I can probably replace it with an SQL Update but curious as to what is

I posted this in the reports section this morning and apparently know one
knows the answer.
Hopefully you might be able to help me.
I have form open in modal mode in my Access 2k application.  When I pull up

im using copy from record set method to transfer querys to transfer the data
like xlsheet.range("a1").copyfromrecordset rst1
how to transfer an query in the same way
like xlsheet.range("a1").copyfromrecordset query1

Good afternoon everyone
I have a form where i write all the information that i need for a specific
record
the primary key of my table is the field Movimento (sequential Number - not

dear sir ,
how much data an access 00 or 03 can handle i mean with respect to depends
on the over all database data size(total number of records) , at what stage
data base will start getting slow how to define to an custemer regarding

Dear friend,
I want to create password to open other form. Actually, i have form menu;
button entry data, button check data and button report. When i click button
check, i need password entering before form check appear.

Can I make an input mask in an input box ?