Can I display the details of 2 records on a form view?? Let me explain why.
I have a membership database that as well as the usual 3 address lines &
d.o.b. etc etc, it also records a next of kin (incl. their full address
details etc).

I am trying to build a database. I dont know if I should use Access or Excel
or Both.
In this data base I need to track patients, the centers by which they are
recieving treatment, the types of treatments they are recieving, their

I want to design a data base which will allow me to imput information and
instead of my having to input the same information a thousand different times
for the same product. I want to be able to track and update dates for some
tables and again, instead of having to go back into ...

Good Day and Thank You very much for looking at my situation......
I have a Excel workbook that has been so manipulated over the years and its
nearly impossible to Manage anymore.  I am wondering if there are any
examples of existing databases that already exist or if you can ...

Ok, I'm having a little trouble seeing what I'm sure is a very simple
solution, and it's driving me nuts. I need to make some tables and
relationships in my db that will allow me to associate one piece of equipment
to multiple Frequencies that have multiple ServiceDetails ...

I've been reading the posts on here about multiple users.  From what I can
gather, once the database is ready you can just split it into a front and
backend using access.
My question is.

While using Microsoft office access 2000 program I tried to close it down and
it would not close the file I had created. the computer would not let me
close it or even the computer would not close.

Can someone explain the value to me of lookup tables.  I have a db for my law
firm.  I created several lookup  tables -1 for all the names of the Judges
where we practice, 1 for all the police depts, 1 for all the attorneys in our
county and the biggie- all the zip codes in the ...

I want to create a list of 100 (any number really) words.  I then want to
create a survey form that displays one pair of words at a time (or shows all
possible pairs on the same page) and asks the person taking the survey to
select the word they prefer from each pair.  I want all ...

I have made two tables for my database. One is Patient demographic data which
has fields like
#Patient ID which is an autonumber and the primary key
#Name

Is it possible to find out which fields are included on an index, within
the code? When I retrieve all the properties on an Index on a table, I can
get the name and other properties, but I don't have a clue as to how I can
get the names of the columns on the index.

I have a date input mask of 99/99/"05";0;_
If I enter a date 0610 and hit tab, it fills in the correct "short date" of
6/10/2005.
However, if I copy a record and then try to paste it in a new data entry (so

I have managed to find code that will change the screen resolution when I
click a Command Button but I really need it to change it when I open the
database and then change it back to the original screen res when I close it.
Is this possible and if so how do I do it?

I am using make table queries attempting to properly construct one to many
relationships between Depts, Mfg, Model#s, and Serial Numbers.  I am having a
problem getting a basic table..say just the Mfgs....to relate to the original
table to preserve the overall relationship ...

How can I keep leading zeros in a text field? Currently, it just disappear
after you enter, say, 0010, then hit Enter key.
Thanks.