•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,809 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,897 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1848 | Replies: 4
 |
•
•
Join Date: Jul 2008
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Help! I think that this should be easy but I have not been able to find the correct VBA code to get the Form to print only the current record not all 1651 records.
I have a command button (Print) and walked through the wizard correctly to print "only the current record" but it is NOT doing that. So, I thought I could tweek it in code but can't get it right so it's still printing our 367 pages (all the records).
Can anyone "lend" me some code that I can add to my command button to do this. I realize that printing and VBA are sometimes messy but if anyone out there has already solved this problem, my non-profit and I would be very grateful. I'm working in Access '02. I'm not an expert but also not a novice.
I have a command button (Print) and walked through the wizard correctly to print "only the current record" but it is NOT doing that. So, I thought I could tweek it in code but can't get it right so it's still printing our 367 pages (all the records).
Can anyone "lend" me some code that I can add to my command button to do this. I realize that printing and VBA are sometimes messy but if anyone out there has already solved this problem, my non-profit and I would be very grateful. I'm working in Access '02. I'm not an expert but also not a novice.
•
•
Join Date: Jan 2008
Posts: 29
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
What is the code that you currently have tried?
Bob Larson
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
•
•
Join Date: Jul 2008
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by boblarson 
What is the code that you currently have tried?
Thanks Bob for asking but I think I can solve the problem by just making a macro and attaching that to the command button. If that doesn't work, well then I may just be back to beg for help.
•
•
Join Date: Jul 2008
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
It worked. I knew there was an easy solution but I was just too tired to find it the other day. Thanks so much anyway.
•
•
Join Date: Jan 2008
Posts: 29
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
Well, at least you got something working the way you wanted. Good to hear 
Bob Larson
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access activation almost throwing my laptop out of a window api blogger blogging blogs code code injection combo command command prompt console creative dani daniweb data debugging dep development dropdownlist epilepsy gdata google gpl griefers hackers key linux microsoft module net news openbsd product programming prompt registry reuse root rss serial source tags toread tweaks vista web windows xml
- Previous Thread: table from union query
- Next Thread: HELP! Do I need IIS???
