Replies

I thought so, but it couldn’t hurt to ask. Thanks again.

Quick followup question: for the FileFilter argument, is it possible to specify only files with no extention? The file to be imported is actually an export from an AS400 system. By default, these files are exported without extentions. If need be, I can get an RPG programmer to make a change to include an extention on the exported file, but thought I’d try this route first.

(Yes, it would be easier and far more effiecient to query the AS400 directly, but my boss won’t let me do it that way– DON’T GET ME STARTED!!)

Quick followup question: for the FileFilter argument, is it possible to specify only files with no extention? The file to be imported is actually an export from an AS400 system. By default, these files are exported without extentions. If need be, I can get an RPG programmer to make a change to include an extention on the exported file, but thought I’d try this route first.

(Yes, it would be easier and far more effiecient to query the AS400 directly, but my boss won’t let me do it that way– DON’T GET ME STARTED!!)

Thanks Hans and Jan for the input. I will try to implement your suggestions this afternoon.

Thanks Hans and Jan for the input. I will try to implement your suggestions this afternoon.

I was afraid that was the answer I would get. Thanks for letting me know.

I was afraid that was the answer I would get. Thanks for letting me know.

thanks for your reply, Gary

This is being run on a Citrix server, so it is possible that I might not have enough RAM on the server. This is a very intermittent problem–probably once in 25 runs or so.

I just need to add an error handler to catch this and terminate the report altogether and instruct the user to begin again. I think the error happens at different points in the code and in different procedures, although I’m not sure. How can I write an Error handling procedure that would catch this one error regardless of which module or procedure it occurred in?

thanks for your reply, Gary

This is being run on a Citrix server, so it is possible that I might not have enough RAM on the server. This is a very intermittent problem–probably once in 25 runs or so.

I just need to add an error handler to catch this and terminate the report altogether and instruct the user to begin again. I think the error happens at different points in the code and in different procedures, although I’m not sure. How can I write an Error handling procedure that would catch this one error regardless of which module or procedure it occurred in?

Thanks, Charlotte, for your input. Sometimes I feel like I’m still learning some of the finer points of Access. It never occurred to me to refer to it in this way. Thanks again.

Thanks, Charlotte, for your input. Sometimes I feel like I’m still learning some of the finer points of Access. It never occurred to me to refer to it in this way. Thanks again.

OK, moving the code to Report_Open for the main report didn’t really change anything. I think I’ve learned that the Open event fires too late for my uses.

Does anyone have any ideas on where I would put code to change the property of a report during runtime. I’ve tried Open and OnFormat.

OK, moving the code to Report_Open for the main report didn’t really change anything. I think I’ve learned that the Open event fires too late for my uses.

Does anyone have any ideas on where I would put code to change the property of a report during runtime. I’ve tried Open and OnFormat.

Wendell–

Thanks for your response. I really appreciate all the help you give

I need to make sure I’m not missing something. I cannot find an OnFormat event for the main report. There is an OnFormat event for the detail section of the main report. Is that what you meant? I tried that, but it didn’t fire until after the Open event of the subreport. I think I need this code to fire prior to the opening of the subreport.

So I move the code to the open event of the main report. This does not seem to work, either. Now I am getting the following error message: ” Error: 2046, The command or action ‘OpenReport’ isn’t available now.” Is there an event that fires prior to even opening the main report? or do I need to move this code to the click event of the button that calls the report in the first place? I think I’ll play with that for a while.

Wendell–

Thanks for your response. I really appreciate all the help you give

I need to make sure I’m not missing something. I cannot find an OnFormat event for the main report. There is an OnFormat event for the detail section of the main report. Is that what you meant? I tried that, but it didn’t fire until after the Open event of the subreport. I think I need this code to fire prior to the opening of the subreport.

So I move the code to the open event of the main report. This does not seem to work, either. Now I am getting the following error message: ” Error: 2046, The command or action ‘OpenReport’ isn’t available now.” Is there an event that fires prior to even opening the main report? or do I need to move this code to the click event of the button that calls the report in the first place? I think I’ll play with that for a while.