I've created a monster...

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I've created this database... I had a multi-sheet Excel
spreadsheet. I combined all the like sheets and added a
column to identify which sheet. I then, imported this
combined file into Access 2000. During that import, the
wizard asked me if I wanted to split off some data into
lookup tables. I did so. Now I have the main table, with
references to the lookups, and two lookup tables.
Basically, the database has user and project information.
The main table contains a User ID, password, and
permissions. One lookup table contains user data. One
lookup table contains project data. I have also created
multiple forms to add information to this table
structure. I have added header information for the
project which is only on the first form. In the detail
section, I have up to 8 users divided into various types.
My dilemmas, are 1) how do I carry the header data to each
of the other forms? (I was told earlier in this newsgroup
to use global variables. I thought I had done this
before, but was mistaking it with SQL/DS on a VM system.)
2) and I need to create a user record upon save. That
doesn't sound difficult except, I need to build the record
from the header information and up to 8 records for each
form; if a section is blank, nothing will be recorded. I
am a VB novice. Any ideas or have I created something too
complicated?

Designing past my knowledge...

L
 
Am I asking this in the right group?
Click to expand...

Probably m.p.a.tablesdbdesign would be better. Your problem appears to
have more to do with table design than with VBA coding on a Form.

But your question also assumes a LOT of intuition and telepathy on the
part of the volunteers here who donate their time to answer. You say
you have multiple tables and multiple forms and some general comments
about the logical contents... but it's not at all clear what tables
(tablenames, primary keys, relationships) you in fact HAVE.

Do note that "Lookup" fields are a Hot New Feature that came in with
A2000, but the consensus among serious developers is that they do far
more harm than good. I would suggest that if you want to migrate
complex data from Excel into Access that you sit down (with the
computer OFF, using a pencil and a pad of paper) and come up with a
proper normalized table structure; identify your Entites, their
Attributes, and their relationships; then link to the spreadsheets and
run Append queries to populate the tables.
 
Probably m.p.a.tablesdbdesign would be better. Your
problem appears to
have more to do with table design than with VBA coding on
Click to expand...
a Form.

It appears I don't have access to that group. I am going
through the MS site and not a news reader on my mail
account.
But your question also assumes a LOT of intuition and telepathy on the
part of the volunteers here who donate their time to answer. You say
you have multiple tables and multiple forms and some general comments
about the logical contents... but it's not at all clear what tables
(tablenames, primary keys, relationships) you in fact
Click to expand...
HAVE.

I apologize. The data is classified and I didn't take the
time to actually sanitize the explanation of the structure.
Do note that "Lookup" fields are a Hot New Feature that came in with
A2000, but the consensus among serious developers is that they do far
more harm than good. I would suggest that if you want to migrate
complex data from Excel into Access that you sit down (with the
computer OFF, using a pencil and a pad of paper) and come up with a
proper normalized table structure; identify your Entites, their
Attributes, and their relationships; then link to the spreadsheets and
run Append queries to populate the tables.
Click to expand...

That sounds like a plan... although, the way the wizard
broke them up is how I would have done it.
 
a Form.

It appears I don't have access to that group. I am going
through the MS site and not a news reader on my mail
account.
Click to expand...

http://support.microsoft.com/newsgr...LCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups

is the link - the label is something like

Microsoft Access - Tables & Database Design

and Microsoft in their wisdom have chosen to make the actual newsgroup
names hard to find.

Sorry about the tone of the message, I was feeling crabby and should
not have been replying!
 
Back
Top