Search results

Sorry, I got excited Basically, all you need to do is a the userid that the user logs in as to your tasks table as a field. You could then base a query on that field with a where clause to sort only those where the userid is attached to. EG. TblTasks Task_ID Task_Name Task_Date_Due User_ID

Admin Try putting a nested If Else statement at the point where you open the form i.e. If combo4.value = "admin" then .openform "frmAdmin" else .Openform "frmUser" end if

Hi there, I think I can help. what you could try is adding the userID to the tasks table. Once the user is logged on, you can base that filter/query on the ID with a where clause. This would cause the filter to sort it based on the userid.

Annoyance If I understand how Access works, you don't need to create a connection when you are programming in VBA because you are already connected to the database through VBA. If you needed to connect to another database then ADO works fine, however DAO would also work in your situation...

I am trying to input several new records into 3 tables. I don't want to send the first two through without the last one succeeding. I am using the DoCmd.RunSQL method with my Insert Into SQL statement following the command. I have also set up a workspace object with the begintrans at the...

I am trying to input several new records into 3 tables. I don't want to send the first two through without the last one succeeding. I am using the DoCmd.RunSQL method with my Insert Into SQL statement following the command. I have also set up a workspace object with the begintrans at the...