G
GeoffT
i am using access 2003 and have started getting the folowing error message when trying to open a database = "set dbs=CurrentDb()
Compile error - Error in loading dl
Anyone got any ideas
' Open the table of Switchboard Items, and fin
' the first item for this Switchboard Page
Set dbs = CurrentDb(
strSQL = "SELECT * FROM [Switchboard Items]
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID
strSQL = strSQL & " ORDER BY [ItemNumber];
Set rst = dbs.OpenRecordset(strSQL
Compile error - Error in loading dl
Anyone got any ideas
' Open the table of Switchboard Items, and fin
' the first item for this Switchboard Page
Set dbs = CurrentDb(
strSQL = "SELECT * FROM [Switchboard Items]
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID
strSQL = strSQL & " ORDER BY [ItemNumber];
Set rst = dbs.OpenRecordset(strSQL