Search results

Final code Select Case [ARyear] Case 2005 DoCmd.OpenForm "frmFilterForm", acNormal DoCmd.Close acForm, Me.Name Case 2006 DoCmd.OpenForm "frm2006AR", acNormal msgbox "WARNING! Students information is current as of November...

Works like a dream! Thank you!

This is what I have: Private Sub GO_Click() If [ARyear] = 2006 Then DoCmd.OpenForm "frm2006AR", acNormal DoCmd.Close acForm, "frmSelectYear" Else End If If [ARyear] = 2005 Then DoCmd.OpenForm "frmFilterForm", acNormal DoCmd.Close acForm, "frmSelectYear" Else End If...

The reason I have previous numbers listed in the student table is allow us to reference there old numbers. Sometimes my staff needs to locate the student and information is old. By chance, they could be back at there old number that they had previously (for instance, they leave there parents...

Okay, I know Im beating everyone before the critiquing of my first attempt at the table structure of just the students and employment info. But I couldnt resist so I kept going with the project. :rolleyes: I have a total of 9 tables. Ultimately they come together with a table named...

Thank you DOC, PAT, RV and Bat .... Here is my test run at it. Attached is the table structure if you want to open it up (its just the tables) but I will try showing what I did here. So far I just started with the Students information and the current and previous employment information...

look at my example DB on this thread and look at the event procedures to identify the code you will need. Fairly simple - I figured it out and that surely says it cant be too difficult :rolleyes: http://www.access-programmers.co.uk/forums/showthread.php?t=97048

Pat, Everything you said made sense with the exception of the junction table. I was under the impression that relating the two primary keys of the tables would be all it needs to relate the tables. As example: the StudentID (Primary Key) under tblstudents would be linked to employerID...

Thank you for the help, I have read the following links below (provided by you Pat in an earlier post) which have been extremely helpful in understanding Normalization. (recommended links for the stupid) :D http://www.fmsinc.com/tpapers/datanorm/index.html...

Okay, I tried breaking up the data as much as I could, the result is 10 tables: Tblstudents: studentID LastName FirstName SSN Gender DOB TblStatus: StartDate ExitDate Status Program R/D AnnualReport TblStudentContact: Address City State Zip PoBox Phone AltPhone Email TblCurrentEmployment...

I want to thank you for putting it bluntly RV. I have been learning mostly off of Access Cookbook (text book) and oddly enough it does not discuss tables. I skipped the process entirely on creating a Relational Table(s). Looking at my Access for Dummies book - it appears there is information...

It is for my place of employment / department. There has been nothing implemented with the exception of a spreadsheet from Excel and ironically I have the most experience dealing in Access (which is not saying a heck of a lot) as well as are Tech Team is unavailable to create a system to make...

I only have one table and I read so often that its better to have multiple tables. For what I have, it seems to work fine. Will this cause problems down the road? Thank you once again John D

I love it when things work out :D Thank you!!

I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc). I am trying to get the report to read the status and check the appropriate box in the...

I am having this same problem but unfortunetely I can not get it to work. I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc). I am trying...

no suggestions?

Compile Error Can't find Object or Library Im getting the error as well. Works on my station, but others it does not. (cpu's have same setup) :confused: John

I have a report that has multiple check boxes etc. When a check box is checked, it then makes the check box bold and then bolds the box surround that entire field. Attached is a picture of 'Employed in the Field' being checked and the effects of it. However, I have a long string of code that...

http://www.access-programmers.co.uk/forums/showthread.php?t=96170 Just had the same problem, but this fixed the problem :rolleyes: essentialy I had to create my own boxes around the check box to make it visible. If there is something placed on top of your picture, be sure that the back style...