Search results

I appreciate I can check query results, etc, but I would rather go with Pat's suggestion, as I have perhaps 30 reports going through this selection process and I don't fancy coding and maintaining for every one of them! A simple, generic invocation as I have now will work fine, if I can just...

Pat, Sorry to be dim, but I added the Select Case statement as you suggested in the event that calls the report (click on listbox item) but I can't trap the error in time. The 2501 message comes up before the Select Case statement kicks in. What am I doing wrong here? I tried to add an OnError...

OK, guys, thanks. Onward and upward ...

I need to identify where a report selected from a listbox menu of reports has no data to display, then display a "No Records" message before returning to the reports menu list. When a report is selected from the menu, I call the report with the code: OpenReport strReportName, acViewPreview In...

Delete This Message I did offer my apologies for the duplicate. Regardless, I tried the Delete button and the posting is obviously still here. I am new to the forum, so, if the posting's presence still offends you, perhaps you could offer some constructive comment as to how I remove it?

If this is a duplicate posting, my apologies - my machine's playing up. I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event). That works fine, but (presumably when the server is slow) I get a popup box informing...

I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event). That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read...

Thanks a lot, Sergeant. I haven't coded in a while but, despite the Access interface, I made my way through it! Now if I can just create a portable version of it, I can work at home instead of the office ...

I am putting together a query-based form for an auction, that needs to include an image of each item retrieved. One of the columns in the source table contains the name of the picture file (e.g. "pic001.jpg","nopic.jpg") to be displayed for each row retrieved. How do I link this text with the...