export 1 record from Access, in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a personnel database
Each person needs to see their performance plan and no other
In the past, FileMakerPro exported and imported individual records in FileMakerPro format
That was very convenient

How do I accomplish the same trick in Access
 
It is not clear "where" you want to do the export?

I mean, it would seem to make sense to send the one record to a word
template perhaps?

I have nice working word merge example that will work well with EXISTING
applications, and allows you to send the one record to a word template.
Check out my way cool example at:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Or, how about while looking at a form, you press a button, and the nice
looking report you build only shows the current record you are looking at?

You can send the current record out to a report with this tiny bit code:

me.Refresh
docmd.Openreport "your report",acViewPreview,,"id = " & me.id

The "id" in the above needs to be replaced with whatever you used for the
records key id (which, usually is id).

Please feel free to "expand" on what you want to do with this one record,
but is seems a bit of shame to just send the one record out to some file out
there without regards to what you want to do with it?

You can certainly export one record out to a text file for example. (you can
use transfertext command, with a query you create).

I am sure there is a good access solution to what you want to do..but the
goal contains the answer to the best approach.
 
These are performance plans, which only the subject should see and modify
In Filemaker it was easy to export 1 record, that export remaining in Filemaker format (everyone has Filemaker), and the person could look their performance plan over and modify it and return it for re-inclusion in the supervisor's database

Export 1 record to remain in Access format to be modified by one person and re-imported

Your suggested report sounds most fesable if this can't be done the way we'd like
I've downloaded your code for export to Word too
 
Back
Top