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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jfriedrich
- Order by date
-
Programmatically setting Printer.PageSize options
Thank you. I did look at the article this morning and it doesn't really help in my situation. Since I am compiling to an MDE, I cannot open the form in design view first (run-time error occurs). I am already running the code on Open. The code is running just fine to setup the printers, I just...- jfriedrich
- Post #3
- Forum: Microsoft: Access Reports
-
help with date fields
You may need to monkey with your date formats because Access goes based on your regional settings, but something like this is one way of doing it: mid("03/01/2006",Instr(1,"03/01/2006", "/")+1, 2) & " - " & mid("03/31/2006",4,2) & " " & Format(#03/01/2006#, "mmmm") & " " & Mid("03/01/2006",7, 4)- jfriedrich
- Post #3
- Forum: Microsoft: Access Reports
-
Programmatically setting Printer.PageSize options
While working in Access 2003, it would appear that you lose your printer settings in reports periodically. Since this wreaks havoc on our users printing legal size reports, I am working on setting up the printer settings in VBA. My code is simple and works to print: dblRptWidth =...- jfriedrich
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
