By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Need file browse on Access form

P: n/a
I'm using an unbound form to upload an Excel spreadsheet into Access and I
was wondering if there is a control available that would allow me select the
desired file name and path. I can't seem to find any such control in my
toolbox.

Robert
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Br
In news:NP*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
I'm using an unbound form to upload an Excel spreadsheet into Access
and I was wondering if there is a control available that would allow
me select the desired file name and path. I can't seem to find any
such control in my toolbox.

Robert


You'd need to all up the Windows file dialogs using Windows API calls.

Look at http://www.mvps.org/access/ under "APIs"
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response
Nov 13 '05 #2

P: n/a
Is this in .NET? Is there a way to do this in VB 6? Anybody?

Robert

"Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au...
In news:NP*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
I'm using an unbound form to upload an Excel spreadsheet into Access
and I was wondering if there is a control available that would allow
me select the desired file name and path. I can't seem to find any
such control in my toolbox.

Robert


You'd need to all up the Windows file dialogs using Windows API calls.

Look at http://www.mvps.org/access/ under "APIs"
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response

Nov 13 '05 #3

P: n/a
Br
In news:EE*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
"Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au...
In news:NP*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
I'm using an unbound form to upload an Excel spreadsheet into Access
and I was wondering if there is a control available that would allow
me select the desired file name and path. I can't seem to find any
such control in my toolbox.

Robert
You'd need to all up the Windows file dialogs using Windows API
calls. Look at http://www.mvps.org/access/ under "APIs"
Is this in .NET? Is there a way to do this in VB 6? Anybody?

No, it is in Access/VBA. That was an Access site and this is an Access
forum.....

You asked how to do it in Access, why now ask for VB6?
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response
Nov 13 '05 #4

P: n/a
Because I'm assuming VBA is VB6 not VB.NET. But anyway I don't care what it
is as long as it works in Access. I am definitely using Access, sorry if I
gave the wrong impression.

I tried:

Dim strFilter As String
Dim strInputFileName As String

strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")
strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)

and it told me that function ahtAddFilterItem was not found. How do I find
this function?

"Br@dley" <n0****@4u.com> wrote in message
news:NK*******************@news-server.bigpond.net.au...
In news:EE*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
"Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au...
In news:NP*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
I'm using an unbound form to upload an Excel spreadsheet into Access
and I was wondering if there is a control available that would allow
me select the desired file name and path. I can't seem to find any
such control in my toolbox.

Robert You'd need to all up the Windows file dialogs using Windows API
calls. Look at http://www.mvps.org/access/ under "APIs"

Is this in .NET? Is there a way to do this in VB 6? Anybody?

No, it is in Access/VBA. That was an Access site and this is an Access
forum.....

You asked how to do it in Access, why now ask for VB6?
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response

Nov 13 '05 #5

P: n/a
Br
In news:6h******************@fe06.lga,
Robert <pr**********@yahoo.com> said:
Because I'm assuming VBA is VB6 not VB.NET. But anyway I don't care
what it is as long as it works in Access. I am definitely using
Access, sorry if I gave the wrong impression.

I tried:

Dim strFilter As String
Dim strInputFileName As String

strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)",
"*.XLS") strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)

and it told me that function ahtAddFilterItem was not found. How do
I find this function?
Read the notes carefully...

".. see the included function TestIt() .."

The function is listed on this page:
http://www.mvps.org/access/api/api0001.htm

Br@dley

"Br@dley" <n0****@4u.com> wrote in message
news:NK*******************@news-server.bigpond.net.au...
In news:EE*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
"Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au...
In news:NP*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
> I'm using an unbound form to upload an Excel spreadsheet into
> Access and I was wondering if there is a control available that
> would allow me select the desired file name and path. I can't
> seem to find any such control in my toolbox.
>
> Robert

You'd need to all up the Windows file dialogs using Windows API
calls. Look at http://www.mvps.org/access/ under "APIs"

Is this in .NET? Is there a way to do this in VB 6? Anybody?

No, it is in Access/VBA. That was an Access site and this is an
Access forum.....

You asked how to do it in Access, why now ask for VB6?
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response


--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response
Nov 13 '05 #6

P: n/a
All right. I'll check it out.
"Br@dley" <n0****@4u.com> wrote in message
news:%r******************@news-server.bigpond.net.au...
In news:6h******************@fe06.lga,
Robert <pr**********@yahoo.com> said:
Because I'm assuming VBA is VB6 not VB.NET. But anyway I don't care
what it is as long as it works in Access. I am definitely using
Access, sorry if I gave the wrong impression.

I tried:

Dim strFilter As String
Dim strInputFileName As String

strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)",
"*.XLS") strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)

and it told me that function ahtAddFilterItem was not found. How do
I find this function?


Read the notes carefully...

".. see the included function TestIt() .."

The function is listed on this page:
http://www.mvps.org/access/api/api0001.htm

Br@dley

"Br@dley" <n0****@4u.com> wrote in message
news:NK*******************@news-server.bigpond.net.au...
In news:EE*******************@fe02.lga,
Robert <pr**********@yahoo.com> said:
"Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au...
> In news:NP*******************@fe02.lga,
> Robert <pr**********@yahoo.com> said:
>> I'm using an unbound form to upload an Excel spreadsheet into
>> Access and I was wondering if there is a control available that
>> would allow me select the desired file name and path. I can't
>> seem to find any such control in my toolbox.
>>
>> Robert

> You'd need to all up the Windows file dialogs using Windows API
> calls. Look at http://www.mvps.org/access/ under "APIs"

Is this in .NET? Is there a way to do this in VB 6? Anybody?
No, it is in Access/VBA. That was an Access site and this is an
Access forum.....

You asked how to do it in Access, why now ask for VB6?
--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response


--
regards,

Bradley

A Christian Response
www.pastornet.net.au/response

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.