I keep getting a "Type Mismatch" error when running this code
set rs=db.openrecordset("select * from table_name", dbopendynaset)
db is initialized by setting
set db=currentdb
I would appreciate your help.
Ammar Hussein
Amman, Jordan
I keep getting a "Type Mismatch" error when running this code
set rs=db.openrecordset("select * from table_name", dbopendynaset)
db is initialized by setting
set db=currentdb
I would appreciate your help.
Ammar Hussein
Amman, Jordan
Is the "rs" variable defined as a DAO recordset?
This problem was due to the references declarations in Tools menu of the module.
I have a different problem. I am trying to bind a text box control on a report page header section to a global variable. Upon opening the report, I get the correct value of the variable as seen through a MsgBox statement, but the control fails to display the value. Instead, I get a #Name? value displayed.
What is causing this problem?
I would appreciate your help.