Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Open report and filter in VBA
Yes, that works. It took me some time to work out that the syntax. I've worked in some other programming environments, and the use of the single quote (') as both an important part of the program code and as the signal for commenting is a strange choice. Who am I to argue with Microsoft?<br>...- brocky
- Post #4
- Forum: Microsoft: Access Other topics
-
How do you create an SPC chart with MS Access?
Hi,<br> I,m about to run through a similar exercise. I work for a company making chemicals in batch-wise production. I've coded an application in Delphi, which I can e-mail the code for if you like. Change of company structure means that Delphi is now frowned upon and Access is the new king...- brocky
- Post #2
- Forum: Microsoft: Access Other topics
-
Open report and filter in VBA
Hi,<br> I'm trying to open a report in VBA and am having trouble with the filtering syntax. I appear to be opening the report ok, but I'm seeing parameter dialog boxes with the filter criteria that I'm trying to specify as the prompt. Code is as follows:<br> <br> Private Sub Label20_Click()<br>...- brocky
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
