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 6 8845
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: CHIN |
last post by:
Hi all.. here s my problem ( maybe some of you saw me on other groups, but i
cant find the solution !! )
I have to upload a file to an external site, so, i made a .vbs file , that
logins to...
|
by: mattrapoport |
last post by:
I have a form with an input type='file' element. I click on the Browse
button of my file upload element, select a file, and hit open. The
file name appears in the textbox portion of the file...
|
by: Dave N |
last post by:
I want to programatically open the Access "File" "Open" browse box to search
for a file. When it is selected I wnat to have it put the path in a text
box so it can be added to a list box.
|
by: Susan Bricker |
last post by:
Greetings. Before I begin, I have been stuck on this problem for about a
5 days, now. I have tried and just seem to be not getting anywhere. I
know that the explanation is lengthy, but I am a...
|
by: Rob Mitchell |
last post by:
(Sorry if this appears twice)
Hi,
I know this has probably been beaten to death but
I was working with Class by Stickman --
http://www.the-stickman.com which uses DOM to
create multiple file...
|
by: Lyle Fairfield |
last post by:
I am using Microsoft’s Web Browser Control embedded on an Access Form to
browse a specific site. I have a good reason for doing so; the pages on
this site run code which aborts their display unless...
|
by: Prakash Singh Bhakuni |
last post by:
am replacing the default "Browse..." button for input type=file. This works fine except that the form will only submit after the SUBMIT button is clicked twice.
Any ideas on why this is happening...
|
by: ApexData |
last post by:
I am using code from the following links to establish a
Browse File and Browse Folder dialog.
http://www.mvps.org/access/api/api0001.htm
http://www.mvps.org/access/api/api0002.htm
This code...
|
by: truthlover |
last post by:
I need some help. I need a button on an Access form that allows the user to browse for a file on our network, and insert it in a field (rather than having to type a path). I dont need any filters...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |