Be able to choose a file on C drive before importing/querying?

[Doodlebug2000]

Hi All,

I created a button on an access form that allows me to import a specific file and re-arrange the data in a certain order. However, when I hit this button, I want the option to choose which I want to import from somewhere in my C drive. How would I do this?



Also I'm not really a programmer so go easy on me!

[orange]

Here's a M$oft article with example.
http://msdn.microsoft.com/en-us/libr.../ff835934.aspx

[JoeM]

Here's a M$oft article with example.
http://msdn.microsoft.com/en-us/libr.../ff835934.aspx

This is of interest to me. That code referenced certainly is a bit shorter than the VBA code I have been using for this for years. I have been using Ken Getz's code here: http://access.mvps.org/access/api/api0001.htm

However, with Ken's code, you can specify a default directory that the file dialog box will start in. Can you do that with the Microsoft code? I would love to use this shorter version, if that can be done.

[orange]

I think the default directory for the file picker is the same folder in which the MDB/ACCDB file is located.

A quick look shows this

.InitialFileName = "c:\*.*"   ' or your choice

should work.

Good luck.

[JoeM]

I think the default directory for the file picker is the same folder in which the MDB/ACCDB file is located.

A quick look shows this

.InitialFileName = "c:\*.*" ' or your choice

should work.

Excellent! Thanks!

[Doodlebug2000]

This is of interest to me. That code referenced certainly is a bit shorter than the VBA code I have been using for this for years. I have been using Ken Getz's code here: http://access.mvps.org/access/api/api0001.htm

However, with Ken's code, you can specify a default directory that the file dialog box will start in. Can you do that with the Microsoft code? I would love to use this shorter version, if that can be done.

I saw that link before but copied and pasted into a blank VBA code but only got errors. Is there a step by step procedure anywhere on how to implement it?

[Doodlebug2000]

This is of interest to me. That code referenced certainly is a bit shorter than the VBA code I have been using for this for years. I have been using Ken Getz's code here: http://access.mvps.org/access/api/api0001.htm

However, with Ken's code, you can specify a default directory that the file dialog box will start in. Can you do that with the Microsoft code? I would love to use this shorter version, if that can be done.

Can anyone provide step by step insight on how to implement this? this link has been showing up all day that i've been seearching for this
thx

[orange]

You are welcome.