Recent content by Warren_J

and here is the file oops... here it is

Access 97 I have attached the file in what it tells me is compatable with older versions of access. I noticed a lot of people in these forums use 97, is there a specific reason for that? Here's how my tables work... I'm sure there is a better way, but I'm not sure how to get from where I am...

I have a database (I have enclosed a simple version) that has 4 tables. Names, Active, Disenrolled, Completed. The names table is used to lookup and associate the person with the classes they are taking. Active is classes they are currently in... you can figure out the rest. What I am trying...

Added Note There is no need to add names via the form... I find it easier to add them directly to the table... or set up another form just for that... this way no one can go in and mes things up... speaking of messing things up, is it possible to make it so nothing is updatable on the form? I...

File now attached Wow... that makes it a LOT smaller... how could I make the tables and everything more efficient?

New Issue Ok, here is a real request now... It's a totally different problem... same database tho. I have the header, detail, and footer in my form, and for some reason the detail section is a lot longer than it needs to be... I have included the file so maybe someone can help... just trying to...

Thanks! The attachment works perfect! The reason I wanted it in 3 tables is because I wanted to try to link each of them to 3 excel sheets that someone else already updates with all the info. Hopefully I won't have a problem with that. While I'm on it... this is probably way more complicated...

I have been using Access for awhile, but I have just recently dove into the VB realm and I am about to drown. This is all I want to do: I have a table (Names) with - SSN, FirstName, LastName, DOB I have a table (Active) with - SSN, Course, Title, EnrollDate, SendDate, DeadlineDate I have a...