I have a form with four fields; Year, Month, FirstDay, LastDay.
the form is used to get the first and last day of on month using the fields
"Year" and "Month" to display the dates I want.
so far I have achieved so, but on a dd/mm/yyyy format.

I am trying to pull all the records that have a payment due in the next
calendar month. Pulling all October dates, for example works fine but when I
pull December the year does no increment. What am I doing wrong?
Thanks

I dont know whether this is a stupid question. But does access have
something akin to the pointer variable in C - or for that matter the
'&' operator in xbase.
I will explain my reason for wanting it too. I often use SQLs in which

Am having problems with the database corrupting. Have installed Microsoft
Jet 3.5 Service Pack 3
but this has not helped. Users are mentioning that the system is slower.
There are around 25 users, each with an Access front end, all connected to

I am having difficulting importing an Excel spreadsheet into my Access
program using VBA
I want to use the last argument to specify the worksheet name which is RTA.
I get an error which

Hello everyone,
I have a task of combining two tables: tblPatient and tblSolution,
related by a KEY field in a one-to-many relationship from tbl Patient
to tblSolution, respectively. So, I have the following table layout:

This is probably a really easy thing but I'm being stupid today. I need to
be able to incorporate 5 fields;
Field1 = Number
Field2 = Number

OK...I hope I explain this clearly:
I have a report to run everyday for the previous day's work.  In the
main table, I have the date auto populate with     =date()-1    that
will give me the previous day's date.  How can I tell it to subtract 3

I have an Access 97 database sitting on a shared drive on a server, users
have various versions of Office (2000 & 2003) they all need to be able to
see the tables in the 97 application and some need to be able to make new
tables which are also shared with the other users.  Can ...

All:
I'm using Access 2000 on a Windows XP platform.
My goal is to use a form to gather user criteria which I will then parse
into a useable SQL string.  At this point I would like to open one or more

in some help of Access I have read what to do for:
- write in a form tha data of a new record of a table
- update the table ONLY after the click on a push button
I don't remember where I have read all that and I can't retrieve it.

Is Peter Miller still in business?  After years of seeing recommendations to
his company for data recovery, I find that I needed his services today.  I
sent in a rescue request over his website and received an automated reply,
but when I tried phoning his company for an update all ...

I have to call table from database but when I use
Dim dbs As database
set dbs =CurrentDb()
I show error since the first "Dim dbs As database" sentense which

I have a listbox (of product names) control on my form. I want to pass the
selected item (a product name) to a subform, and the product unitprice
should apear automatically next to the product name in the subform. Is it
possible? How do I do this? Thanks in advance.

I created a database application for the company I'm working and as part of
the CFR Part 11 it is a requirement for al the application that are for
manufacturing us to have some security option like employee account to log
on in the database and a transaction log to register al the ...