Search results for query: *

PH, I checked the code that you suggested and it can’t help me. I think that I need to explain my problem. I build the database that have Access front and SQL backend. “Every Monday” users are getting ODBC connection error when they try to make update into the SQL table. They can browse the...

Hello. Does anyone have code that would link SQL table thru DSN from Access? Any help is greatly appreciated. Thanks.

Run the code that you have from a different database. Don't run it within tha database tha you are trying to compact.

Set up .mdw security file and asign user ID for everybody. Once they log in use CurrentUser() function to determine the user ID. if CurrentUser() = "userID" then docmd.OpenForm "whatewer" else msgbox "Access denied" exit sub end if Hope this helps.

I have a form with 5 textboxes on it. I can tab thru them from 1 to 5. When it gets to textbox 5, i want focus to stay in that box, no matter how many times i hit tab after that. I don't want it to go back to textbox 1. If anybody knows answer to this i would realy appreciate the help.

Thanks

Can somebody give me an example of getters and setters or where I can go to learn more about them? I really appreciate the help. Thanks.

sorry, this is the code ublic Function MoveRecordsets() Dim rst As DAO.Recordset Dim db As DAO.Database Dim sql As String Set db = CurrentDb sql = " SELECT tblMaster.LoanNo, tblMaster.FirstName, tblMaster.LastName, tblMaster.Status, tblProccessData.LoanNo1, tblProccessData.FirstName1...

im trying to update the table using the recordsets but keep geting error message "Cannot update. Database or object read-only" I didnt set anything to be read-only. here is my code so if somebody can review it and tell me what i'm doing wrong, i would realy appreciate Public Function...