How to create a [Select] Transfer Text in a Macro

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

Guest

I have a switchboard on my Access DB. One of the buttons on this form runs a
macro. This Macro Transfers Text into Access using a predefined spec. The
problem I have is the name of the file changes daily. I need to create a
Prompt on the Switchboard button that when selected it asks the user to enter
the name of the file he/she wishes to import.

I have no experience of VB so if anyone can supply me code or has any advice
that might do this task for me I'd greatly appreciate it.
 
Thanks for pointing me in the right direction. Problem is I dont know what to
do with the code and how to assign it to the Macro and Switchboard button?
Apologies I am an Access beginner keen to learn!
 
Do you have any Access programming book? If you are keen, you need a few
since ...

Look up on Event and Event Procedure. It is likely that you need to use
Event Procedure code (TransferText Method) in stead of your Macro. In your
code, you will need to use the code on the Web page to present the user with
the File Save dialog ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Text 9
Access Switchboard error message 1
macro transfer text 2
Access Automatically Send a notification email once a record is added 0
Macro Error 3
How to Create a Macro to Import External Data 0
How to record a macro within a macro 9
Help to create a macro 2

Back
Top