Recent content by amy3000

Willir, It does help. I haven't completely worked it out yet (very long week) but I've created a different database with limited data and tables to simplify it.Thanks, Amy

Well, since you've all helped me so much I think I can chime in on this topic too. I'm not much of a science fiction fan but Orson Scott Card's "Pastwatch" was very good. I've read a couple other books of his.

I am amazed at how fabulous people are on this forum. Yes, this is very helpful. I need to look at the various options. I'm not sure why I've had so much difficulty grasping this. Thanks.

I'm afraid I'm being a bit dense and I might be asking the same questions over again. I created a composite primary key in the: PARTICIPANT_TABLE Training_ID Person_ID Role_ID There's a one-to-many relationship between the TRAINING_TABLE (one part) and the PARTICIPANT_TABLE (many part). But...

There's another bit of complication now. I have 3 tables to record trainings and the participants. PERSON_TABLE Person_ID (primary key) Last_Name First_Name Etc, PARTICIPANT_TABLE Person_ID (primary key) Training_ID (primary key) VOLUNTEER_TRAINING Training_ID (primary key) Training_Type...

Perfect. I knew it wasn't complicated. I just couldn't get it. Thanks.

I'm sure the answer is here somewhere but I'm not sure how to search for it. I have a database of volunteers for a medical reserve corps in the county I work for. The "Person" table is the main table for the database and is organized: "PERSON TABLE" Person_ID (primary key) Last_Name...

Thanks to both of you. Both of these work.

I've looked through many of the Max date threads but don't really know SQL too well. I did something that I think works but I'm not sure this is the right way to do this. I have an address table with the fields ID#, Address, and Effective Date. The addresses are updated every month which is the...

Thanks for the response PHV but neither worked. I think I'll just need to instruct the people doing data entry to ignore it.

I followed the instructions on Martin Green's website(http://www.fontstuff.com/access/acctut10.htm). I created a table with the following fields: Category, Product, Product Number, Publication Date, Supplier (from another table)Notes. The Categories are types of printed materials eg., brochures...

Now I have another problem. Each individual can have multiple records in each of the list boxes (except credential where they have to select one only. Credential are in the person_ID table). So what I had done was create a query with a left join from the person_ID table to the other tables...

It works! Now I don't really need the Last_Name list (not that it did what I wanted it to do anyway). I'll play with this a little with more parameters. Now the next hard part is creating a report. But I'm still wondering about the DAO ADO thing. Will it be an issue putting this database on...

I need to say first that I don't really know anything about VBA. I know how to cut and paste. I used a tutorial at Martin Green's website on creating dynamic reports: http://www.fontstuff.com/access/acctut19.htm . I have several tables all linked to the main Person table with a foreign key. I...

Thanks. I didn't think to use the horizontal/vertical spacing and that works fine.