How do you draw a vertical line on a report in Access. I can only draw lines
within each section. Is it possible to draw a line or a rectangle the full
lenght of the page.
John

I am opening a new form on a filter for the current record on a parent form.
I can add to the database on the new form, but it is not saving the foreign
key in the table the child form is based off of, just the other data.  What
do I need to do to get it to save the foreign key?

I have a form (Machine) that displays records from a table. When clicking a
command button, it opens another form (MachineList), and I want it to use the
same filter as I may have in the first form (Machine).
I have tried the following (in the OnOpen event of the MachineList form) ...

Windows XP / Access 2002
When other users try to open a db I've created, they can only open it as a
read-only version and can not save edits to the db. I'm hoping someone can
suggest what might be causing this behavior and how to fix it. Thanks.

I Microsoft Access I have a field that contains a 4 digit number that I want
to be able to compare it to the current year. How do I do this?
I am using Microsoft Access 2002.

Hi: Everybody
When user click the record navigation button to add a new record in a From,
I want to make the Form colour becomes light green colour.
But I don't know where to put the code into what event, thanks for help.

I am taking an Access 2002 course and the course CD has databases which we
are using.  I am unable to open them in Access 2000.  Is there any way to
open them in Access 2000 or do I have to use 2002.

y(ou)-two  ooto make help search more like office lingo...
thanks

How do I add a leading zero back to a Zip Code field that apparently lost the
leading zero upon importing from original Excel file?

Some of the fields in my table are allowed a limited number of entries, so
in design view I use the lookup wizard and type in the allowed values, which
are then stored in the 'row source' field under 'lookup'. The problem is
that I want to enter numbers in inches, eg 12", 18", and ...

Hello Again
I'm saving word files into a clients folder through Access (The database
application) The files are taken from a template folder and saved into the
clients folder and renamed with the format (dd-mmDocumentname)  However, I'm

Where can I find a list of current MS-Access functions?  I
am familiar with some of them but would like a list of all
of them, I can't seem to find a complete list in the help
files.

Hi. Is there a way for Access alerting you  by way of pop up or something,
when you are entering data twice, i.e. new customer, to let you know that,
that name has already been entered before just in case you are duplicating a
record? If you have 4 thousand records, it would help ...

Hello Again.
Is there anyway of creating folders/directories?  When I convert a client I
would like to automatically generate a folder with the name based on their
client code.  This folder will be used for storing word documents.

I am trying to create a database which will log the
flights I do as a passenger. I have got a table with
airports and another table with aircraft types. I have
created another table (the Flight Log itself) which needs