Search results

A common method is to check the links when the front-end is started and if they are broken prompt the user to enter the path & file name of the back-end. You can re-link them via code by looping through the Front-End's TableDefs collection and using the TableDef.Connect property.

I'm not sure why your having that problem but have you tried putting the workgroup file as part of the arguments to MSAccess E.g. "c:\program files\microsoft office\office\msaccess.exe" "c:\winnt\profiles\ms67\desktop\schedu~1.mdb" /wrkgrp "c:\winnt\system32\system.mdw"

I'm not sure how efficient it would be but have you considered using a Collection E.g. Dim colData As New Collection Dim recData As Recordset Dim intLoop As Integer ' Create 5 copies of the data For intLoop = 1 to 5 Set recData = CurrentDb.OpenRecordset("Table") colData.Add recData...

I'm not sure what your asking!! Are you saying that the value of a field in one table is the name of the field in another e.g. if you have a [Truck #] of 12345 then there is a field in another table called 12345. Or that you have a control (on a form?) who's name is the same as the value in...

You can load a list or combo box from an array by using a function as the RowSourceType. For more information look for RowSourceType in the Help Index and chose the "Create a list box or combo box that gets its rows from a function" topic.

You seem to be trying to set optgrpColor to the form object rather than the optiongroup object. Try: - Set optgrpColor = form_Event_form_UpdateSiteDatabase.optgrpColor Also as you're directly referencing the form in the code module you might as well have this function in the form module...

If Loan is the variable then try: - Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl] where LoanID = " & Loan)

Try: - If Not IsCompiled Then DoCmd.RunCommand acCmdCompileAndSaveAllModules End if