By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

exporting access records

Kaosu
P: 19
is there a way to export a record from my access databse one by one, but looking how it looks on the form graphics wise

the information does need to be edited just emailed for others viewing
Feb 1 '08 #1
Share this Question
Share on Google+
12 Replies


JustJim
Expert 100+
P: 407
is there a way to export a record from my access databse one by one, but looking how it looks on the form graphics wise

the information does need to be edited just emailed for others viewing
Sorry Kaosu but I don't understand your question. I'd be more than happy to try to answer it, but you'll have to explain yourself in a bit more depth.

Jim
Feb 1 '08 #2

Kaosu
P: 19
i wrote a database holding the training records for all the people in the company. then i was asked if it was possible to export individual resords so they could be sent via email to clients. but i want to keep the exported file looking exactly the same as the screen version of the form graphically and not just as plain text.
Feb 5 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
i wrote a database holding the training records for all the people in the company. then i was asked if it was possible to export individual resords so they could be sent via email to clients. but i want to keep the exported file looking exactly the same as the screen version of the form graphically and not just as plain text.
Try outputting a snapshot file (SNP)
Feb 5 '08 #4

JustJim
Expert 100+
P: 407
i wrote a database holding the training records for all the people in the company. then i was asked if it was possible to export individual resords so they could be sent via email to clients. but i want to keep the exported file looking exactly the same as the screen version of the form graphically and not just as plain text.
Yes, as Mary said the SNP is good. Otherwise there's the old and much unloved Ald-PrtScr, paste into Word (or other container) and e-mail that.

All the best

Jim
Feb 7 '08 #5

Kaosu
P: 19
i have it 1/2 working being saved as an rtf file.

the only problem is that it saves the page without the record details, just the template design.

how do i link the report to the record being shown in the form?
Feb 13 '08 #6

Kaosu
P: 19
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdSaveRTF_Click()
  2.     Dim strPath As String
  3.     Dim strFile As String
  4.     strPath = "W:\training database\Training records\"
  5.     strFile = FullName & ".rtf"
  6.     DoCmd.RunCommand acCmdSaveRecord
  7.     DoCmd.OpenReport "rptprintrecord", acPreview, , "SQSID = '" & Me!SQSID & "'"
  8.     DoCmd.OutputTo acOutputReport, "rptprintrecord", acFormatRTF, strPath & strFile
  9.     MsgBox "File saved as" & vbCrLf _
  10.     & strPath & strFile
  11.     DoCmd.Close acReport, "rptprintrecord", acSaveNo
  12. End Sub
sqsid is the primary key i want the report to idetify the record by
Feb 13 '08 #7

Kaosu
P: 19
ok u can scrap all the stuff before this.
how can i print a single record in a pdf a format?

i can print the record without opening a report from a button on a form, is there a way to set the button to use the pdf print option by default?
Feb 13 '08 #8

MMcCarthy
Expert Mod 10K+
P: 14,534
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdSaveRTF_Click()
  2.     Dim strPath As String
  3.     Dim strFile As String
  4.     strPath = "W:\training database\Training records\"
  5.     strFile = FullName & ".rtf"
  6.     DoCmd.RunCommand acCmdSaveRecord
  7.     DoCmd.OpenReport "rptprintrecord", acPreview, , "SQSID = '" & Me!SQSID & "'"
  8.     DoCmd.OutputTo acOutputReport, "rptprintrecord", acFormatRTF, strPath & strFile
  9.     MsgBox "File saved as" & vbCrLf _
  10.     & strPath & strFile
  11.     DoCmd.Close acReport, "rptprintrecord", acSaveNo
  12. End Sub
sqsid is the primary key i want the report to idetify the record by
This should be working, are you sure there is a record on the form?
Feb 13 '08 #9

Kaosu
P: 19
sorry for all this hassle, but i think that if i can set the print cmd on the form to use pdf by default then i could save a load of problems and i get what i want. i currently have the pdf format set as default printer and this works perfectly but its not a permanent fix. is there a way to do this?
Feb 15 '08 #10

MMcCarthy
Expert Mod 10K+
P: 14,534
It's complicated but have a look at this article.

http://www.mvps.org/access/reports/rpt0011.htm
Feb 15 '08 #11

Kaosu
P: 19
sry for the slow reply, was to busy to work on my database.
but that works perfectly msquared, thx a lot

It's complicated but have a look at this article.

http://www.mvps.org/access/reports/rpt0011.htm
Feb 19 '08 #12

MMcCarthy
Expert Mod 10K+
P: 14,534
sry for the slow reply, was to busy to work on my database.
but that works perfectly msquared, thx a lot
You're welcome.
Feb 19 '08 #13

Post your reply

Sign in to post your reply or Sign up for a free account.