Form/Table/Qry Help

[Warren_J]

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 table (Completed) with - SSN, Course, Title, ActionDate, Grade
I have a table (Disenrolled) with - SSN, Course, Title, Grade, DisenrollDate

They are all linked 1 to Many by SSN
SSN is the primary key in the table Names

1 Form (NameFrm) with 1 Combobox (ComboBox) and 3 ListBoxes (ActiveList, CompletedList, DisenrolledList)

I want to have the combobox that lists all the names in table Names (which I have done, but if I try to bind it, when I go to select a name it won't let me)

When you select a certain name from the combobox, all the listboxes are updated with the info that matches the SSN.

Thank you if you can help... it sounded easy, I dont know why the problem...

 

[WayneRyan]

Hi Warren,

I made no pretense of trying to make this look good, but it
gives you a starting point. When the Names form comes up,
you can use the combo to move around the records.

I didn't bind the combo to the main form's data, because
it only displays one record at a time.

Experiment with it.

See ya,
Wayne

 

[WayneRyan]

Oops,

Didn't attach.

Wayne

 

[Warren_J]

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 than it is worth... but is it possible to have access update it's tables with specific information from a website... ie if there is a table on a website (not my own website) can I have access go to that site (maybe even having to enter a username and password) and update itself when that table updates (or by clicking a button or something). I have never seen it before, so there is probably a reason for that, but thanks for the posts anyhow, makes things 100% easier.

 

[Warren_J]

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 make it look nicer. Thanks.

BTW - I had to change all the info for security reasons

File is too big, but u should notice it on the one that was sent before.

 

[WayneRyan]

Warren,

If you go to Tools --> Database Utilities --> Compact/Repair
Then ZIP
Then attach, it should be OK.

Wayne

 

[Warren_J]

File now attached

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

 

[Warren_J]

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 think you just have to lock it in the properties but i'm not sure if that will ruin anything else.... and while I'm here... when I was trying to make this database the 1st time I had it that if you were in the form or any table (other than names) and you tried to add something, if the ssn didn't match it would give an err msg until the ssn that you were entering matched one of the ssn's in the names table...

Last thought... is it possible to have multiple forms (i.e. a names form to look at and an add form for editing) and have one password protected while the other is not?

Thank You!