I have created a hyperlink on an access form that I need to repeat each time
a new record is generated?

I need to create a relationship between the two tabels below Tables 2 & 3 and
am confused on how to do this correctly. The first table is the one side of
my relationships. What I need to insure is that if you delete a record from
table 2 it will not allow you if there is a record ...

I have Access 2000 on Win XP. I have a linked table in a db which links
to an MDB file in My Documents. When I go to Linked table manager it
only shows a partial path to the other MDB file that is linked to. The
linked table manager dialog cannot be resized. So how can I view the ...

Hi,,
I have a table with a default value =time$.
Problem is when I enter a new record the time value of the NEXT record
defaults to the time when that previous record is entered. Thus if there is

I am doing a database. I want to go back and see which realtors have sold
what, the clients, be able to get all birthdays from her clients to keep in
touch with them, see how much money in commisions the office has made, etc...
I have tried to do an normalization on the data.I ...

Greetings everyone,
I am an accounts person but was tasked to setup a database.  My very limited
experience with Access was based on learning whatever I can from Access help.
So far, I managed to get a test database working after weeks of bumping

I need to get a group of data fields (street no, street address and suburb)
into a single data field in the report design? Does any one know?

Is there a way to print out the performance analysis report so that i can
easily address each suggestion without having to write them down?  I haven't
been able to figure out how to do this.  Thanks in advance for your help.

I have to do a database for a real estate company. I am having problems, if
someone can help me I will really appreciate it. My email is
erick_solms@hotmail.com
So far I have decided to create 4 tables. One for properties, one for

When i go to open a PowerPoint file, the view i get is always "preview".  How
do i set it so that it will always open "list" (list all of my other Office
programs)?  thank you.

Firstly thank you for helping me with the initial hurdle of how to set up a
DSN etc. Now i have done that successfully and am in the process of designing
a database. I seem to have been stuck in a place i cant get out of.
The situation is like this..

A system I am developing will have as a key component a 3-level hierarchical
structure. I know this can be represented by 3 separate tables A, B, C where
rows in B are linked to A and rows in C are linked to B. However, I can also
represent this structure by a single table by ...

I'm trying to create a Main Menu Database Selection page, when the database
is opened by a user, that will allow my users to select certain forms, data
entry, reports, and queries within the database.  
Once a selection has been made, the initial screen will close and then the

How can I modify a linked table?  The database is MS SQL.  I want to add
additional fields and tables.

spead sheets,inventory,cost,value of coins collected