Search results

There a decent bunch - they just havent have a clue when it comes to access. They are working on a new DB that is using something besides Access.

Okay, more changes. I went back and read what Pat H specified What im gathering is that a junction table will NOT have a PK. So taking what you suggested Wazz and what Pat explained, I came up with the following (view attachment) Oh, and the tblUnavailable: I need to know if the student is...

The Audit Trail has been working great in my currently messed up DB :p I did like a few suggestions said, I have the Audit Trail that can be turned on by an invisible command button that then prompts a PW. After the correct PW it opens the Audit Trail for view. It then can be closed by...

Okay, I have made some adjustments, but im a little lost because I thought I needed a junction table - or is that tblStudents? Anyways, its attached - Thank you for the help Nateobot & Neileg oops - realized that on tblStudents, the EmployerID is still there - this has been removed

To my understanding, wouldnt I need the tblOverallStutus as a junction table? Im trying to think of how I could eliminate the triangle relationships and the only thing that I can think of is having the StudentID deleted from some of the tables and eliminate the relationship as well. I was...

I apologize, please review this attachment instead of the first.

I have been battling this for awhile and this is a result from the thread below: http://www.access-programmers.co.uk/forums/showthread.php?t=97048 However, it seems more fitting to have the thread continue here as I am moving onto the relationships. After setting up my tables and attempting to...

Steven, What your trying to accomplish is probably out of my reach as I am learning as well. Next to the example (2 views) is just the amount of people who have viewed the attachment. As for it asking you to join or re-create the work group is beyond me. Its A97, so that may be the problem...

I just went through something similar, maybe this will help, http://www.access-programmers.co.uk/forums/showthread.php?t=98985 John D

Look at the attachment - It may help you. (may being the key word) John D

Private Sub YourButton_Click() DoCmd.OpenQuery "QueryName", acViewNormal, acEdit End Sub John D

Ouch! I certainly wont argue valid points, however, in my place of business, the reports need to be viewed and printed by a number of individuals. These people are not the best with technology, so if it is a simple fix, then by all means it would be more then helpful to fix this piece of the...

ChrisO, You are right, I went back to when I had the error and ran a few tests. Opening up the form and with out filtering - I attempted to open the report from the form and I recieved the same error '2427' I then closed the form and opened it up a second time. This time I applied the filter...

I got it all to work, Thanks!

Another stupid thing that I did with this database is named fields and the table using spaces! its giving me an error and I am assuming its because of the spaces but I do have one more question.. I have more then one field I want to pull from the tables, do I just use a comma to seperate the...

Okay - the other database is in the works and is going sloooow (the one that is being created with normalization). Meanwhile, my other database that has no normalization I am having a problem running a query (now I know why its so important to have good structure). To give you an idea on how...

If your speaking about an event procedure, just place a ' before each line of code - or remove it entirely

I recall seeing this achieved in a thread .... I would search the forum

Simple enough - thank you!

RG, I have the same set up on my forms, however I just use this DoCmd.Close acForm, "MyForm" should I be using Me.MyForm instead of placing my form in ""? Also, im assuming the acSaveNO is simply telling it to not save any changes made? thanks John D