Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Passing Parameter from Excel TO Access

    I have an Excel form that from one texbox will open a word doc. Once the word doc is opened, it runs a mail merge and asks for an input parameter from the access query it is based off of. My question is, How can I pass the value from the Excel form to the parameter window that will display once the word doc has opened?



    I know I could re-write the query to accommodate to this, but this is a large scale project, I would have to re-write probably over 1,000 queries, and I don't want to have to do that. And the same situation with, I know I can use Excel to run the SQL behind the query, which that might be a viable option, but would like to steer away from it at this current time since the actual SQL varies depending on certian criteria it is never 100% the same.

  2. #2
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    Would I be better off, calling the query -- the query name stays the same for each database that I am calling it from --- via VBA in Excel and then passing the parameter from the Excel form, or would I still not be able to pass the parameter from Excel to Access w/o re-writing the query?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Parameter Passing
    By Juan4412 in forum Queries
    Replies: 1
    Last Post: 11-21-2011, 10:23 AM
  2. Passing List of Parameter
    By vignes10 in forum Access
    Replies: 3
    Last Post: 09-15-2011, 07:35 AM
  3. Passing a Picture frame as a parameter
    By SacredFootballLB in forum Forms
    Replies: 1
    Last Post: 09-30-2010, 11:40 AM
  4. Macro passing a parameter
    By SlowPoke in forum Access
    Replies: 1
    Last Post: 09-26-2010, 09:57 PM
  5. bypassing passing parameter when null
    By cowboy in forum Queries
    Replies: 11
    Last Post: 04-14-2010, 09:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums