Selected tables into *.txt format? : -

[RED_DOG77]

I have a large database of patients, i need to send infomation regarding one patient to other users (clinics) of the same database.
(database is local to all users, and contains different patients info , i.e differing clinics have different patients) this is to create a referral system to foward info from G.Ps to Specialists.
I was advised that i should foward client info as a String of text in a *.txt file
sent using SendObject, then input data into Specialists version of software.... Any help/Ideas or suggestions would be Fantastic!! : )

Thanks Again

 

[The_Doc_Man]

The biggest question is to know what format the other parties expect for each package they use.

If you are comfortable with writing VBA code, I would write a file from inside a procedure underneath your action button or whatever else it is that you use to kick off the process. Select a record and write some code to pull stuff from your DB as needed. The key to this will be to make sure you visit every related table that needs to be visited. So it might involve multiple recordsets opened sequentially during your records dump.

Look up "Open statement", "Print statement", and "Close statement" in Help if you are not familiar with file operations.

I'm not sure how much work you are willing to do if the VBA solution doesn't appeal to you. If you could write an appropriate query you could also do an Export operation to text. There is a DoCmd event for that, too.

 

[scottfarcus]

DoCmd.SendObject acSendTable, "tblTicket", acFormatTXT, access_junkie@hotmail.com, , , "tblTicket Records", "Here are the latest tblTicket records."

This should send the table in .txt format to one or more recipients.

You can change the subject "tblTicket Records", and the body "Here are the latest tblTicket records." to anything you want. May want to use a text box to capture Subject and Body of email. You can also use a text box to capture email addresses.

DoCmd.SendObject acSendTable, "tblTicket", acFormatTXT, txtEmails, , , txtSubject, txtBody

Good luck!

[This message has been edited by scottfarcus (edited 10-15-2001).]