Re: List box that will display file names???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Have you seen Klatuu's answer? Could be a possibility...

To be honest with you the code to accomplish this is just plain going to be
complex. As I understand it you wish to have the user choose a text file
from a directory, which will then import to a specification which you've
created, and thus allow them to create reports etc... based on the data.

Maybe it would be easier to just have your users use Access themselves -
show them how to choose file->get external data and navigate to your text
file directory. Essentially this is the exact functionality that you've
described!

Is there a reason this would be insufficient?

Ben.

"msanewbee" <msanewbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E334859B-36E5-4119-8BA6-3FF9589D5BEF@xxxxxxxxxxxxxxxx
Okay...I'm guilty. I don't have a clue. I looked at the api0001, but I'm
not sure which part of that I would need. I'm willing to try some code
but I
don't even know where to put it. Could I have some more clues??

"Ben" wrote:

Hi Msanewbee,

This is certainly possible, but only using the Scripting.FileSystemObject
in
code to the best of my knowledge.

Easier, would be to use the Common File Dialog. Still need some code but
it
is simpler.

Check out http://www.mvps.org/access/api/api0001.htm

Don't get put off by the complexity of the code - the only bit you'll
need
to write is very simple. Anyway, maybe this is the perfect excuse to
start
learning!

Post again if you get stuck.

Ben.

"msanewbee" <msanewbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E06887E-67DE-4C19-82FD-8D8B449E2AE0@xxxxxxxxxxxxxxxx
I think I need a list box.....maybe I need something totally different.
This
is what I want to do:
Each night we get a .txt file. Each morning I load the .txt file(s)
into
a
table, using Get External/Import. Then via a form, the users can go a
print
their reports. I would like to have a form that will list (listbox?)
the
files (in a specific folder). Then the user the user could click on
the
file
they want to load, which would then load using the spec I set up. Then
they
could go to their form and get their reports, with no intervention from
me.

Is this even possible? Could there be a better/easier way to do
something
like this? Please keep in my I do not know vba code. Any advice would
be
greatly appreciated. Thanks :)





.

Relevant Pages

  • Re: List box that will display file names???
    ... I don't think my users can load a table because they only have read-access. ... and thus allow them to create reports etc... ... show them how to choose file->get external data and navigate to your text ... file directory. ...
    (microsoft.public.access.forms)
  • Re: A few MVVM and Entity Framework questions
    ... loaded in memory the whole time [so I don't want to just load the full ... reports and browse through them]. ... ViewModel it doesn't matter... ... the worst case a version with a struct constraint and a version with a class ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Another argument for disk brakes?
    ... can be as much as eighth times the downward force ... Do you think a QR is designed to take that kind of load? ... >> I think that is what the design question is about and moving the ... shouldn't there be massive reports of ...
    (rec.bicycles.tech)
  • Re: CR questions, and TY to Bill
    ... > Now I got my report form to load without a licensing error, ... > In the Crystal reports visual designer for the VS.NET IDE, ... > telling the control how to find the data was written in C#! ... > a member of crystalreports1. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Poor perfomance with Spreadsheet OWC 10 with more than 200 columns
    ... It needs 7 minutes to be load. ... > We have already created other reports with less number of columns (60 ... > We are loading the OWC with the HTML Data Param using Response.Write ...
    (microsoft.public.office.developer.web.components)