I created an Access 2000 DB which run perfect in almost all computers, except a group of around 8 computers. The problem is as follows,
I have various report selection screens with command buttons that change the values of a query. The value of the query is then assigned to a Public string declared as strSQL
strSQL = "Select * from tblName where thisField = " & intOptSelected
then I call a Report with the following command
DoCmd.OpenReport "rptName", acViewPreview
DoCmd.Maximize
At this point the Selection Screen gets maximized and we get the run time error. It prompts us to either debug or end. At this point if the users selects end and goes back to the OK button and tries to run the report again, it runs but it doesn't filter the data correctly.
If we select debug the Docmd.OpenReport line is highlighted.
I'm assigning the strSQL value to the report on the Report open event with the following command;
Me.RecordSource = strSQL
I read a lot of thread here in ref to this error. I know that it's not the DLookUp function. If I logged into the users computers with my own personnal settings the program works perfect, so I'm guessing that it has something to do with their setting over the network.
What should I look for? I know that we have different service packs installed in our computers. Also, if I go to design view and check the references they are the same. We all have the same rights. Under the Properties/Security options in the folder where the DB is located we all have the Allow checkboxes check.
Any suggestion? Thanks.
I have various report selection screens with command buttons that change the values of a query. The value of the query is then assigned to a Public string declared as strSQL
strSQL = "Select * from tblName where thisField = " & intOptSelected
then I call a Report with the following command
DoCmd.OpenReport "rptName", acViewPreview
DoCmd.Maximize
At this point the Selection Screen gets maximized and we get the run time error. It prompts us to either debug or end. At this point if the users selects end and goes back to the OK button and tries to run the report again, it runs but it doesn't filter the data correctly.
If we select debug the Docmd.OpenReport line is highlighted.
I'm assigning the strSQL value to the report on the Report open event with the following command;
Me.RecordSource = strSQL
I read a lot of thread here in ref to this error. I know that it's not the DLookUp function. If I logged into the users computers with my own personnal settings the program works perfect, so I'm guessing that it has something to do with their setting over the network.
What should I look for? I know that we have different service packs installed in our computers. Also, if I go to design view and check the references they are the same. We all have the same rights. Under the Properties/Security options in the folder where the DB is located we all have the Allow checkboxes check.
Any suggestion? Thanks.
