MS Access help needed

Hamster

Hamster

Hamster

Soldato
Joined
25 Oct 2002
Posts
5,648
Location
location: location
Need some help from ms access experts here please!!

I've got 3 tables saved in one .mdb.

At the moment i have to double-click the mdb file, spend a few moments opening up each table then resize them to view them all simultaneously in the position i want them.

Is there any way i can click on a shortcut which will open ms access, open up all 3 tables in certain presized positions on the desktop that i have previously set?
 
The obvious solution is to make a form that displays the data from all three tables in the format you want, then set it as the startup form.

Do you have any experience with designing forms?
 
Ok, i'm at work now but will do a quick crash course when i get home at 9 unless someone else gives you the info in the meantime.
 
Right, back now, a bit later than planned but still.

Firstly, what information do you need from each table? Are you editing one table of data or bits in all three? This is going to dictate how you design the form, as needing to edit all the data is quite a bit more complicated than editing only some of it. Also what sort of relationships exist between the data in the three tables?

There's a pretty good basic forms guide here which can point you in the general direction as well. (well the info is good, the page design is shocking)

If you can give me a little more information as to what you're trying to achieve, it'll help me explain the best way to do it.
 
Last edited:
Sorry for not replying earlier. Not been to well.
I would like to edit all data in all tables. I just want to be able to view them all at the same time in a nice layout. I've tried going through the link you gave me before and ran to difficulty when it asked what relationship there was between the fields in the tables. If that's not a simple process then i'll live with opening up and resizing the tables on startup.

:)
JM
 
It should be a simple enough process, provided you've got your tables set up right to start with. If you haven't, it'll be a nightmare.

Perhaps a better question I should have asked was what are your tables and what data are you trying to store.
 
Sorry Dolph. I completely forgot about this thread!
I managed to set it up quite easily using a macro. Now all that is needed is a single click on the macro shortcut on the desktop and it opens access, then all the tables in the desired positions.

:)
JM
 
You must log in or register to reply here.
Back
Top Bottom