Search results

I tried this also, still giving me the error message Set tblUser = CurrentDb.OpenRecordset("Select * From [dbo_tbl_User]", dbOpenDynaset, dbSeeChanges)

I changed it to that Set tblUser = CurrentDb.OpenRecordset("Select * From [dbo_tbl_User]", dbSeeChanges) Now it is giving me error message run time error '3001': Invalid argument and its highlighting that line I changed

1 of my forms is unbound. I keep getting an error message. I have a form that adds new users to the database. this is my code for the submit button. dbo_tbl_User is a table that is on the sql server and is linked to my access front end. It was working when I used the dummy access table, when I...

I created some forms and reports that will use 5 related tables. When I designed all the forms I made some dummy tables within access so I could make sure everything worked. Most of the forms are bound forms. I have 2 unbound forms. I also made different querys that some of the forms and reports...

I finally got it to work. I renamed lpersonID to ID in my query and completed list form. where condition: ='[lpersonID]=' & [ID]

When I tell it to go to one specific record in the where condition it works. It just wont take the lpersonID number from my list that I click on.

I tried that and it still got the same results.

Maybe tomorrow I can share a copy

lpersonid displayed as expected. I'm wondering if the underlying queries to the form are causing the issue. I have different queries used as the data source depending on who is logged in to the database. But both queries still have lpersonid field in them.

how do you get the lpersonID to display in the messagebox. What is the syntax?

I have a pending list (form) , Completed List (Form ), both of them are using querys to pull the same data from two tables. Each list is filtered for different records, depending on if audit was completed for that record. I am using a browse to macro to navigate to MA_Audit_dataentry form(This...

I guess I will just leave the forms bound. That is mainly how I have done most of my forms before. I just have a little experience with unbound forms.

I think I might just combine my two subform tables, then it should work. I dont think I really needed to have that data in 2 separate tables. I'm going to try that.

I don't want to have to create a record in my 2 subform tables until someone is ready to create a record in those tables. If the linked record isnt already created in my linked subform tables then I get an error message. My subforms should be linked all by lpersonID field. It is setting the...

I made it so Audit complete button can only be selected if all the fields have been answered. Then if audit completed is checked then that record is removed from pending audit list and moved to a completed audit list. If a user just navigates off of the form though and enters in partial...

I attached a copy of my forms. I already made a version of these forms that are bound to the tables and it works. The reason I wanted to make them unbound is to prevent accidental data entry or incomplete data entry.

I have a main form that will open up with several bound fields (patient Id, dateUpdated), from a table. Then there are 2 subforms on this main form that will be unbound and will be used for data entry that is related to the bound fields. The data entered in the unbound fields will go into 2...

Thanks!

I might try using ACCDE . I haven't done it before but I think it should work. Once this database is done I don't think I'm going to have to modify it at all.

What would be a good way to enable and disable the special access keys and shortcut menus. I know that I can disable for the whole database with the privacy options menu. But I want to be able to enable and disable them depending on who is logging in to the database with VBA code. I can set up...