Search results

Yeah but how do you identify the person who is 'logged in' with a table? I need to have a userid to show who is doing inserts, updates and deletes on the database...

I haven't followed along exactly what you are doing...be careful with those cascade deletes though as they will delete data you might not want to delete. I generally don't set up database wide relationships but my tables are all designed properly. Then I define relationships in queries as I go...

I did just find the on current event of the form...which actually does something like I want it to do!

Thanks. It is a form bound directly to a table that scrolls through recordsets yes. And I don't see a on current event. File attached. That brings up another question. I'd really like to be able to build one form and use it for multiple things (ie. one to update a record and one to create a...

What is the survey about? Some of your information is not very clear. It looks like all of the stuff on the form in the graphic is attributes of the school. So each attribute would be a field in the school table as you say. I'm going to go off for a minute and tell you what I think...but it...

I want to see what is going on in my program so I figure printing out a MsgBox is a good approach... I have a textbox and this in the on change event: Private Sub ID_Change() MsgBox "This has been changed. " End Sub I see the textbox changing but nothing happening? Why?

is the tempVars collection a set of private or static instance variables? I need instance variables in some public collection so I can pass around user session information. I'm used to working with web applications and now need to develop an access app. Please advise. Thank you.

Hi all! I have been wracking my brain on some Access problems and found your forums. I need help! LOL. I'm sure I can help a lot too though ... I'm tired and need to get solving some problems. I haven't used access in 15 years as I have gone onto other tools like SQL Server and .NET. Now...