B
Bonnie A
Hi everyone! Using A02 on XP. I have a button on my form that opens a report
based upon the record number and the ssn on the form. My company is going
paperless and wants to output the data to a medium that can be scanned
easily. Assuming we settle on SnapShot Viewer, I need to 'send' the report
to a .snp file that would open on their screen (I think I'd prefer PDF but
don't know how to program) so they could do a screenprint to paste into the
'paperless' application (EnCorr - a Word-like file). If I send to Word, I
lose all my lines and .rtf is UGLY. Excel makes no sense of the data,
SnapShot Viewer looks great but I can't 'select all' to copy. System folks
don't want a simple PrtScn because of the Access application and toolbars.
Sorry, I can't figure out why an image like that won't work, but...
Anyway, I got a button on my print form but it pulls every single record and
I can't figure out the wordage to be specific. I have another button that is
specific but I can't get it to work.
My OutPutTo button has:
Dim stDocName As String
stDocName = "JV-Distribution"
DoCmd.OutputTo acReport, stDocName
My current Print button has:
DoCmd.OpenReport "JV-Distribution", acViewNormal, , "[EntryOrder#]=" &
Me![EntryOrder#] & " AND [Employee SSN]=""" & Me.[Employee_SSN] & """"
As you can see, the set-up is different.
How can I get the best method to open the OutPutTo option dialog box to open
and when I select one, that application opens with my report in it?
I hope I've explained this well enough, sorry to say got other fires to
tend. Would appreciate any assistance or advice. Thanks in advance for your
time!
based upon the record number and the ssn on the form. My company is going
paperless and wants to output the data to a medium that can be scanned
easily. Assuming we settle on SnapShot Viewer, I need to 'send' the report
to a .snp file that would open on their screen (I think I'd prefer PDF but
don't know how to program) so they could do a screenprint to paste into the
'paperless' application (EnCorr - a Word-like file). If I send to Word, I
lose all my lines and .rtf is UGLY. Excel makes no sense of the data,
SnapShot Viewer looks great but I can't 'select all' to copy. System folks
don't want a simple PrtScn because of the Access application and toolbars.
Sorry, I can't figure out why an image like that won't work, but...
Anyway, I got a button on my print form but it pulls every single record and
I can't figure out the wordage to be specific. I have another button that is
specific but I can't get it to work.
My OutPutTo button has:
Dim stDocName As String
stDocName = "JV-Distribution"
DoCmd.OutputTo acReport, stDocName
My current Print button has:
DoCmd.OpenReport "JV-Distribution", acViewNormal, , "[EntryOrder#]=" &
Me![EntryOrder#] & " AND [Employee SSN]=""" & Me.[Employee_SSN] & """"
As you can see, the set-up is different.
How can I get the best method to open the OutPutTo option dialog box to open
and when I select one, that application opens with my report in it?
I hope I've explained this well enough, sorry to say got other fires to
tend. Would appreciate any assistance or advice. Thanks in advance for your
time!