Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sophia03

    relink table thru DSN

    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...
  2. sophia03

    relink table thru DSN

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

    Compact database programmatically

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

    Passwording, multi-users

    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.
  5. sophia03

    How to tab thru and leave the focus on last textbox

    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.
  6. sophia03

    getters and setters, please help

    Thanks
  7. sophia03

    getters and setters, please help

    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.
  8. sophia03

    update using recordsets

    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...
  9. sophia03

    update using recordsets

    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...

Part and Inventory Search

Back
Top