I am running Access 2000 and Windows XP. What I would like to do is to
is display all the records for a given month and year eg March 2008.
At the moment I do it via a parameter query entering a start and
finish date.

I have a query created as below:
Date          Compnay        Account          Currency           Balance
1/1/08       ABC               12345            AUD                  100
1/2/08       ABC               12345            AUD                  150

I created the workgroup mdw file for an existing database.  What is the next
step to put this in place?  The plan is to have users open up the database
and see this window were they need to enter a user name and password.  There
is also a workgroup id created.  I used the Security ...

I am building a database in Access 2003 for equipment inspection.  How do I
set up a prompt or notification that an action must happen on a certain date?
Example, I need to receive each Wednesday a prompt telling me the equipment
scheduled the following week?

I have written a function in a module. I now want to test it. I have tried
simply typing in the function's name (with parameters) in the intermediate
window.
I get a compile error, 'expected variable or procedure'

New to Access, and using Access 2003 to enter names and addresses from paper
forms hand-written by people becoming members. To speed entry, I want the
data entry operator to be able to key a four digit numeric Australian
postcode, and have just the matching suburb names displayed ...

We have a search built in to our current access database.  It searches on
last name and the client would like it to search on FamilyID as well.
We have a query and a form.  There is also code.
Find Existing Subject Code

I am trying to create some data entry forms. One such forms needs a numeric
field to default to the value of the field in the previous record. This field
is a date field. the code I am using works but the date displayed is in the
american format not the system format. Code is as ...

Can someone please help me. I have tables with the following fields:
stockId(PK)
ProductId(FK)
DeliveryDate

Access 2003
Not sure if using right approach. 3 tables:Job, Employee, Equipment, Trucks.
I have a form-Schedule that uses the table Job.  The user chooses a job, a
date range, the uses combo boxes to choose Employee, Equipment, Trucks.  They

How do I get a three digit text field to always have leading zeros? In other
words, for record one I want it to be 001 instead of just 1.
Also, I need to create a data entry log. Each time someone enters or changes
data to a record I need it logged into a table. I don't want it to ...

I have been given a project, and am not quite sure where to start.  I am an
older VB programmer, and know my way around VBA and forms, but a lot of
ACCESS is foreign to me.
I have a VEHICLE table and an INSPECTIONS table.  Vehicle ids are numeric,

In Access 2000, what is the recommended maximum number of rows in a table?
Is there also a maximum number of columns that works well with that?
Thank you,
Cathy

Hello, I have the formula below and it gives me the correct number and the
decilal is in the correct spot but im getting a negative number when it
shouldnt be negative. any sugestions? thanks!
=IIf(([txtMasterCoilWidth]=0) Or

I'm trying to write an IIf statement to produce mailing labels.
What I'm trying to do is:
If the teaching position is Principal then the letter is sent to the
directors address, otherwise the letter is sent to the Principal at the