Hello, I'm still trying to grapple with primary keys. I have many
tables that, through the help of these forums, are normalized. But many
of them do not have--at least I do not think they have--natural keys.
So I'm using autonumbers all over the place, which makes me queasy. I

Good morning it Would Like to know as I can enclose in a table of access an
external document kind a picture or
enclose the link of that document for afterwards in a form perform atraves
of a botao that document.  Since ja a

I have a form called "OM_ASP_Scan" . User will search by "Tag No", numbers
that created by autonumber and input some information to update. I also have
created  two combo box  to specify print range between "Tag No" and a command
button to preview a report. In the On Click event  ...

I suspect this is a simple one, but then I'm new to this. I'm interested in
the idea of transforming my paper archives into scanned archives.
Of course, I could just scan documents and thrown the PDFs into a directory.
But it occurred to me that it would be even nicer to have those ...

I have developed an access runtime application in 2003 Developer (XP) that is
looking at a database on a server and being used by multible users as an
inquiry only. I am getting "Locks" on the server and when this happens nobody
can get in. Most of the users are on Office 2000. I ...

sadly, my report still cannot count of books that's teacher borrowing.
In details ;
Teacher's name;
Book's name;

I need to create a database to track parking tickets. The tickets come in
books of 50 and each ticket has a number. The tickets are numbered
sequentially. The database will need to track who the ticket book was issued
to, the date it was issued, the ticket numbers for each ticket, ...

    I have a menu screen that gives the options to add a new record, edit
an existing record, or run any of a number of reports.  All are working
correctly except the edit.  How can I cause it to go to a certain key?  My
key is last name, first name. Let's say I have 3 Jones - ...

please educate me..
I have 2 simple tables employee, tasks.  I have a form for tasks, that I
want to automatically identify the employee using environ("username") and is
a matching record exists in the employee table then pass the EID to the task

This is my very first report attempt.  I'm making a report from a query . The
report  lists the dates of an event in one column and the  total time spent
on  each event in another.     I would like the report to give me the total
time spent on each event between 6/1/2006 and ...

How can I sort in a report to show months in proper order instead of April,
February, etc.  Can I add something in report design to do that?

I would like to know if there is any way on a form that you can type in a
number e.g. 1234 press enter then in a table it adds 1234, the date and sign
in time.Also usin the same form if you type the 1234 in again it will add
sign out time.

i have 4 Excel sheet i want to put them in one form
is there is a way to do that?
& do i'm going to use VBA
thanks for any help

Kind of frustrating knowing Access can help a lot within my organisation but
not know how to.
I would like to use it for invoices and stuff but can;t find out how I must
implement my thoughts.

My project will be finished . but l need to know , can we show our table and
queries to the users because some of my report l created based from my
queries and some  of my field data will be empty because of combo box
Thanks in advance