Has anyone else run into this problem?
I have a file that I'm trying to write a macro for, but certain functions are simply not working. Essentially, Access is telling me that functions like "OpenRecordSet", "RecordCount", "NextRecord", etc. are not recognized functions. First I checked for spelling errors, misplaced commas, comments, parentheses, quotations. Nothing is wrong with the syntax. I decided to test the commands by using one of the examples from the help files. Much to my surprise, I could not access the help files for ANY of these functions. All I get is 'Function or Keyword not found. I dug into the help files directly and managed to unearth the example for the OpenRecordSet function. I cut and pasted the script directly from the help files into the VBA editor. I still received the "Keyword Not Found" error.
I finally tried opening one of the sample databases that come with Access (Northwind.mdb). Wouldn't you know it, the functions work fine. I'm running the files from the same load of Access, on the same machine. I even ran them at the same time. So I imagine there is some driver, or some toggle, setting or command that I need to apply in order to make these functions work in my boss' .mdb file, but I have no idea what it is (ODBC perhaps?) or how to apply it to a file that isn't recognizing these commands, or even the help files for them.
Does anyone know how to make a file recognize these ODBC commands? I really don't want to have to rebuild the boss' database. My boss handed me an .mdb file with a deceptively simple task. (Translation: Not so simple.) I just need to apply a macro to a report and get multiple printouts of each record based on a number stored in the record.
I'm posting another question that is similar to the printing question found here... (http://www.experts-exchange.com/Databases/MS_Access/Q_10057464.html
). I'm hoping I can find a few brilliant souls who can help me get the job done, without having to rebuild the boss' DB.
Thanks in advance,