Access 2010 email report
So I'm working on a small database for my company, I have everything ready to go except for the email report. I have the button working correctly. However, I want them to be able to print out the current report they're looking at, not all.
Do we have any Access gurus here that can help me out?
Do we have any Access gurus here that can help me out?
2017 Certification Goals:
CCNP R/S
CCNP R/S
Comments
-
NotHackingYou
Member Posts: 1,460 ■■■■■■■■□□
Does this help?
MS Access: Email a report in Access 2003/XP/2000/97When you go the extra mile, there's no traffic. -
MAC_Addy
Member Posts: 1,740 ■■■■□□□□□□
I saw that one, it didn't really help all that much. I actually just figured it out if anyone ever needs it;
OnError
Go to: next
RunMenuCommand
Command: SelectRecord
EmailDatabaseOject
Object Type: Form
Object Name: *whatever you want here
Output Format: PDF
I had Command as SelectReport2017 Certification Goals:
CCNP R/S -
MAC_Addy
Member Posts: 1,740 ■■■■□□□□□□
Instead of opening a new thread I thought I'd continue this one.
Does anyone have any experience with start and stop times? I'm trying to create a box that'll calculate for when the hours.
For example, start time = 11/13/2012 4:00am stop time = 11/13/2012 5:00am. Easy to figure out in your head, 1hour. However, how the funk do I get M$ access to calculate that?2017 Certification Goals:
CCNP R/S