I need the auto generated ID configure that exactly look like this:
52490001
where:
5 = the current year

Quick question (i hope)
I have a process in one of my forms that populates the fields with various
information using dlookups against a select query. However this takes
anything up to 20 seconds to run (me and SQL dont get on very well at the

I have one form that I would like to open from a command button on another
form.
How do I default an answer to the form with out using the 1st forms name.
Form1 - Documents - I use a command button to add a new  'issue'  and like

I want to store and display (on a form or a report) multiple pictires per
record in an access database. The pictures are not stored within the
database. They are stored as files and the database contains the paths to the
pictures.

I have a list box that displays results of a filter based on information
that is entered into a text box. Everything works fine, but the list box only
requeries once the cursor is tabbed out of the text box. It seems as if the
information in the text box is not made available to ...

I'm setting up a form and was wondering how to make some of the tex
fields autofill the remaining characters after I enter one or more o
them. I don't want to have to type a persons name or ID in full
everytime that I have to enter information into my table fo

Access 2003
PLEASE HELP!
I would like to create a form for filtering and viewing data in a table. I
want the table data to appear in a list box on the form and I want to filter

i am very new to access, and i am trying figure out how to have access prompt
users to save changes to data on forms before the form is closed.

I am creating a database to track drivers of vehicles.  The drivers will be
identified by the vehicle they are seen driving.
I am using three tables:
vehicle details (VEHICLE ID is the key)

I'm using access 2003. i've created a form for recording monthly donations
which includes 12 field for Jan - Dec. I want a box or field for
'year-to-date' to have a running total of donations for each donor. it seems
easy enough -....

I have some users connecting to Access 97 via Citrix, and when they run
any of the forms wizards they get the following message;
"Applicatioon-defined or object-defined error"
Any ideas of a way to stop this happening?

Is there a collection or object in Access 2003 to know and manage the list
of fonts of a user's computer ?
If not, do you know a procedure already writen who can extract the list of
fonts in a computer.

i have a form called 'work orders' and within that form i have a sub form
called 'materials' which is displayed as a datasheet. when i open my form
'work orders' and start to input data the datasheet 'Materials' wont allow
any data entry. No Rows, just headings. My datasheet is ...

If discovered that if I create a command button and edit what it does and
THEN change the name, I end up with a section of code for the old name that
no longer exists.  Is there an easy way to search through your code and
delete all subs that refer to non-existant names?

I have a form with 3 options each associated with a command button. I would
like all the command buttons to be disabled at start. Depending on the option
chosen by the user, the corresponding command button would get enabled and
let the user click it.