Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Transfer Text - Showing a Common File Dialog in a Macro

Discussion in 'Information Technology' started by Q Johnson, Jul 28, 2006.

  1. Q Johnson

    Q Johnson
    Expand Collapse
    Guest

    I know I have done this in the past but can't find the database in which I
    did it or a clue in the Help systems of either A2K3, A2000, or A97.

    I just want to know what it is I can type on the File Name line for the
    transfer text macro that will cause the user to get a Common File dialog
    (Open or Save depending on whether the operation is Import or Export) to use
    for opening or naming and saving the input or output file.

    It was something really simple like: =GetFileName()
    or some such.

    Thanks in advance.

    Q Johnson
     
  2. Loading...

    Similar Threads Forum Date
    Soul transfer to another body Questions and Answers May 10, 2014
    Sikh Guruship transfer Sikh Sikhi Sikhism Mar 13, 2010
    Transfer of Sikh "Guruship" Sikh Youth Mar 13, 2010
    Sikh News SC issues notices to Punjab govt on Tytler's plea for case transfer (New Kerala) Breaking News Sep 9, 2008
    Sikh News Nine IAS officers transferred in Punjab (Outlook India) Breaking News Aug 29, 2008

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Look at http://www.mvps.org/access/api/api0001.htm at "The Access Web"

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Q Johnson" <QJohnson@TeamNFP.com> wrote in message
    news:eCINNT1eGHA.4912@TK2MSFTNGP05.phx.gbl...
    > I know I have done this in the past but can't find the database in which I
    > did it or a clue in the Help systems of either A2K3, A2000, or A97.
    >
    > I just want to know what it is I can type on the File Name line for the
    > transfer text macro that will cause the user to get a Common File dialog
    > (Open or Save depending on whether the operation is Import or Export) to

    use
    > for opening or naming and saving the input or output file.
    >
    > It was something really simple like: =GetFileName()
    > or some such.
    >
    > Thanks in advance.
    >
    > Q Johnson
    >
    >
     
  4. Q Johnson

    Q Johnson
    Expand Collapse
    Guest

    Thanks for the link, but I don't want to write code for this.

    I wrote my own substitute for the common dialog sometime ago and can use it
    when I need it.

    But in this particular case, I'm almost certain that I didn't need to do
    that. There was some native Access function that I was able to call that
    accomplished this. I'm trying to get the answer for someone who really
    isn't up to VBA solutions. I'm a VB.NET developer and can find solutions
    that work for me without TOO much trouble.

    But I'm looking for one for this other user. Am I just mistaken about the
    existence of this feature?

    Q
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Yes, I think you're mistaken.

    There is no file dialog function built into Access. It is possible to use
    the Common File Dialog object that's in the Office object library, but that
    still requires that some code be written (plus it's not very reliable)

    Copying that code into a module is pretty painless, though, and then it's
    available.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Q Johnson" <QJohnson@TeamNFP.com> wrote in message
    news:egM9Ln2eGHA.1204@TK2MSFTNGP02.phx.gbl...
    > Thanks for the link, but I don't want to write code for this.
    >
    > I wrote my own substitute for the common dialog sometime ago and can use

    it
    > when I need it.
    >
    > But in this particular case, I'm almost certain that I didn't need to do
    > that. There was some native Access function that I was able to call that
    > accomplished this. I'm trying to get the answer for someone who really
    > isn't up to VBA solutions. I'm a VB.NET developer and can find solutions
    > that work for me without TOO much trouble.
    >
    > But I'm looking for one for this other user. Am I just mistaken about the
    > existence of this feature?
    >
    > Q
    >
    >
     
  6. Q Johnson

    Q Johnson
    Expand Collapse
    Guest

    OK. Thanks, Doug.

    I'll throw something together for my client then.
     

Share This Page