I have an Access app that I need to automate in 2 ways:
1. I need to have the app open and print a specific report once each
day at a specific time.
2. I need to have the app take the same report, print as a .pdf, and

How does one set-up a macro to do the following.  When you enter an
Employee Number in a log-in box Access checks the Employee Table to see
if thats a valid Employee number.  if it is the Macro continues along
its way, if not it gives a message box saying that "This is not a ...

All:
On a report I have the following data in a recordset:
DonorId PledgeNum Pledge PaymentPerPledge
1       1         $1000  $50

Who can tell me how to write vba, if I want to open the last record of
"order" form where the customer name is Larry King, in other words, records
with the customer name "Larry King" are many, but the last record is wanted?

I am trying to append records in one table depending on records in two
other tables. I have tried to do it using DAO, but I keep getting an
error message saying
'The Microsoft Jet database engine could not find the object ". Make

i have hundreds of queries and forms. I know there are a lot of forms
and also queries that are not in use and could be deleted, but problem
is how i know which are not in use? it is very hard job to find it out
one by one, so is there any better ways?

I need to populate text boxes for instance with employee information
using their unique employee works number selected from a combo box.
Can anyone help, I am told thru visual basic this can be achieved.

I would like to extract only 15 records at a time from the backend in
alfabetic order. Click on a button and then the next 15. Reason data must
come over a 56k modem.
The data is not alphabetticaly in database.

I'm using Access 97 on a Windows XP computer.  The combo box on the
form "form1" will not refresh after a new name is added to the list.
The "limit to list" properties for the combo box is set to yes.  When
I type a clients name in the box that is not in the list, the form

I have a sales report where the sales are grouped by district. The report is
based on a query with criteria for sales date to get the sales in any
specified date range. I have code in the Format event of the district group
header. How do I get the count of sales in the current ...

I have a problem. I am constructing a database of eople's names and
addresses for business purposes. This requires all of the people to be
numbered eg:
1,2,3,4,5,6,7,8,9,10

Anyone use il software ESRI ArcView GIS?????
In a DB Access I store information about plot of land, house and related
ownership.
By click a button in a specific record, I want to open ESRI ArcView with a

Hello,  
We currently have a table (access 2000) that has the following values:
706 6789 1 5.11 N N 20040923
792 6592 1 10.05 N N 20040923

Hi all. Need help here as I cant see whats wrong...
I have a querydef in Access 2k which execs a stored proc in a SQL
Server 2k db.
I keep getting the following error, and cant stop it for the life of

I've got an access97 app that is being converted to access2000
a dao recordset is different than an ado recordset, and whether or not
the app works is determined by the priority of the libraries in the
reference list