Private Sub ShipmentRequest _Click()
Dim DB As Database
Dim rst As DAO.Recordset
Set DB = DBEngine(0).Ope nDatabase("\\Ba ckup\hosted files\CustomerD atabase\
customerdbnew.m db")
Set rst = DB.OpenRecordse t("Customer Number", dbOpenDynaset)
End Sub
This code gives me the error
run-time error '3078':
The microsoft jet database engine cannot find the input table or query
'customer number'. Make sure it exists and that its name is spelled correctly.
The table does exist, and it is spelled correctly, any ideas of how to solve
this?
--
Message posted via AccessMonster.c om
Dim DB As Database
Dim rst As DAO.Recordset
Set DB = DBEngine(0).Ope nDatabase("\\Ba ckup\hosted files\CustomerD atabase\
customerdbnew.m db")
Set rst = DB.OpenRecordse t("Customer Number", dbOpenDynaset)
End Sub
This code gives me the error
run-time error '3078':
The microsoft jet database engine cannot find the input table or query
'customer number'. Make sure it exists and that its name is spelled correctly.
The table does exist, and it is spelled correctly, any ideas of how to solve
this?
--
Message posted via AccessMonster.c om
Comment