I want to print a report which only gathers data from the previous month.  If
I use dateserial (year(),month()-1,1) as my starting point I wil get an error
when the month is January.  
What's the best way to setup a filter to include only records from last month?

Do you know of a function that will reurn the name of the users temporary
path?
e.g. C:\Documents and Settings\MeUser\Local Settings\Temp

I'm receiving the above error message when I instantiate Outlook in my VBA
code (I've pasted the code below).  I'm using Access 2003 on Windows XP.  The
code was working fine when I was running it on Window 2000 Professional
(still on Access 2003), but when I was upgraded to ...

Hello and thanks in advance.
I'm starting a fresh application to handle manufactured parts and
components, and have just had this great idea for a main parts form, but
really have no idea how to go about it.

I would like to manipulate the data from my tablein my MDB files using query
to get data base on the criteria.
I just wonder that what are the difference between DAO or DAO to get my
recordset and which way is the best way to do it.

I have a number of times that I want to look at the previous record in the
data base to get a value for this record.  For example, if I am putting in a
series of entries with the same date, I would like to have the entry form
keep the last date I entered until I change it again.  ...

any advise please

I want to export data from a table Access using vb6.0 and ADO, can I do that?
and how?
thank you.

I am the administrator of a frontend backend application uisng Access 2003
that is installed in 45 locations. In most cases, the application is run from
the server rather than having the app on the end user desktop. Each
deployment of an upgrade, however, means linking the front ...

I have two tables, one for thousands of students and included in their record
is their school name....there are dozens of different schools.   Then I have
another table with teachers and included in each of their records is their
school name.  I want to get a count of the ...

I have the following code to open a form. I want to go to the last record
when the form opens and I thought that it should be something like the
following after the form is opened but it does not work:
DoCmd.GoToRecord acDataForm, stDocName, , acLast

I've got a continuous form, frmMain, that displays a list of the records in
tblMain.  Each record appears as a hyperlink and when clicked the record will
open a form, frmInd, with just the record clicked displayed.  I'd like to
have an unbound text field display some information ...

Hi,
I am having a problem getting Dev's FTP module (Internet Data transfer
Library) working. (http://www.mvps.org/access/modules/mdl0037.htm). I am sure
it is something I have not done properly.

I want to put the data from an Excel file in an Access database using VB6.0
(ADO), how can I do that?
Thank you.

I've started my new job about 1 and 1/2 mnths ago, there is an written
access application , and here is University with 20000 employees and now I
have to install and debug this application for thousands of clients inside of
my work, actually it is a system tracking for Vacation ...