I am brand new to Access and know nothing about VBA so I would like to
avoid programming if possible.  I have a database with separate tables
representing each of the different positions in a military
court-martial (Accused, Judge, Trial Counsel, Paralegal, Defense

I have three tables (tblData, tblMilitaryData, and tblCompetency). All have
the SSN as the primary key. I cannot get them to have a one-to-one
relationship. Why?
I have to have them in separate tables because I ran out of the 255 fields

I need to setup a database to track occupational exams.  Employees change
Departments, EmployeeCode, names, etc so I need a table to translate EMP# to
Alias#.  This is necessary to reflect the current name, Department,
EmployeeCode but still retain the information as it was when ...

I have my table relationships set up to do cascading updates and deletes, but
I have found that when I change a primary key value in the top-level table,
the update does not work and I get an error:  
"Cannot perform cascading operation.  There must be a related record in a

Need to have a number field that increases 1 each record.  Access 2002 will
allow only 1 Autonumber, and since I already have 1000+ records, don't want
to start from scratch.  The book mentions Last(), which if it worked, could
be like Date()+5, which works well, but Last() ...

i need to set the current date on a field by click. in 97 i did that with a
macro which had the (set value) command in the action field. in  2007 there
is no such option.with 2007 how do i set the current date in a field by just
clicking into it?

If I create  my database, can it be shared amoungst users.  In other words,
we do have a workgroup set up between all of our office personel, with a
main system that houses our accounting system.  Everyone has access to it.
There is not a server installed on the main system.  No ...

We our a interior trim company that is supply labor & material to several
builders.
We want to set up Access  for this, we were told that Access, probaly
wouldn't be able to handle this. We also want it to work with Quickbooks. We

OK... I have taken your advice and have change my way of thinking and
switched from Excel thoughts to Access thoughts.  With respect for my
scenario of a manufacturer that sells 11 items to 1800 stores, I have
created the following tables with the following fields. Could you look ...

I've heard a lot of debate about lookup tables.
Should I use them or not i.e. having separate tables with my choices listed
therein ?
Or should I use a drop down menu in the table i.e typing my choices directly

Need to do some simple billing out and tracking those bills. Is there a
templete out there that I could obtain?

I would like to have the use of directories incorporated into Access.  This
would allow developers to group queries, forms, reports, macros and modules
into named or titled file directories.  Like, in the same fashion that
directories are used for grouping, sorting and storing ...

I have a table design in place using autonumber so that each record will be
unique.  However, in addition to that autonumber, I would like to have a
second field which will automatically increment based only on that second
field.  The incremented number needs to be capable of ...

I created a DAP to do my invoicing but when I change the "DataEntry" to true
so I can input data it goes blank????
Thank you in advance Steve

I have a form 'Part Details' and a form 'Sample Request.' Within Sample
Request, I have a combo box that retrieves data from Part Details. I also
have a button in Sample Request which opens up Part Details so you can enter
new part information if the part is not in the database ...