Results 1 to 3 of 3
  1. #1
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83

    Sub parameters with options


    Is there a way to create a parameter that gives options to the user. For example, in DoCmd.TransferSpreadsheet one of the parameters is import, export or link and it displays those options for you when you are writing code. So for my example I have

    Code:
    Private Sub Form_Load(Create as Integer)
    the create parameter only accepts 3 parameters, either a 1 , 2 or 3. Is there a way to show the user that they have the choice of either 1,2 or 3?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,466
    You could create a form, with some check boxes etc and a Button.
    User fills in/checks a box or selects from a list and then clicks the button to do
    whatever you want them to do.

    see http://www.fontstuff.com/access/acctut17.htm for some ideas

  3. #3
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83
    sorry i should have told you my module name is not specific to an access form, it is actually running another application outside of access and the create parameter is to specify how the user wants to modify the application

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

Similar Threads

  1. what options do i have to protect my work?
    By fdelval in forum Security
    Replies: 7
    Last Post: 02-09-2012, 10:46 PM
  2. Database with filtering options
    By demlaw in forum Access
    Replies: 1
    Last Post: 04-07-2011, 04:02 PM
  3. Networking Options
    By Robertag in forum Access
    Replies: 1
    Last Post: 03-13-2011, 01:16 PM
  4. Grouping Options
    By Desstro in forum Queries
    Replies: 1
    Last Post: 06-20-2010, 06:33 PM
  5. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 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 - Senior Forums