Creating a macro

[coolkake]

How do I create a macro that will take the contents of a text file and paste it in to a field in a form? It's basically a template that will be used in certain situations only.

 

[thornmastr]

I don't think you can do this with a macro. I think you will need to use VBA. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[dschomburg]

You could use TransferText to import it into a temp table, set the Specification to use it when needed. Then just set the text field on your form or report to that table OR use an update(or)append query to add the data to whereever you need it.

Does that make sense, it sounds kind of garbled??

 

[thornmastr]

It sounds like a very poor reason to not learn VBA. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[coolkake]

Sorry dschomburg, it doesn't make sense. Does anyone know where I can find examples of this or a how to?