Access 2000 File/Open box

[dwalls]

I have created a small database that imports a text file with a macro
through TranserText into a table. I would like to be able to add the
ability for it to give the File/Open box so someone could pick the file
they will be importing. Is there a way I can do that and call that from
within my macro?
Thanks

[pietlinden]

Not sure if you can call it from within a macro, since I never use
macros. but there's code to do it right here...

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

You could create a button that called this and then passed the result
to the TransferText command...

this is assuming that you grabbed the code from the above link and
dropped it into it's own module and saved it... then you can just do
something like this....

Private Sub Command0_Click()
'create a variable to hold the filename to import.
Dim strFileToImport As String

If Len(strFile) <> 0 Then
strFileToImport = basOpenSaveFileAPI.TestIt
DoCmd.TransferText acImportDelim, , "MyTable", strFileToImport,
True
Else
MsgBox "please specify a file to import!"
End If
End Sub

You'll need to modify the TransferText stuff to suit your situation -
the file type (is it delimited?), what table your data is going into,
etc...

[anyla_80]

i wont to work in toronto.

[Darryl Kerkeslager]

"anyla_80" <al**********@k.ro> wrote

i wont to work in toronto.

Is that "I won't work in Toronto." or "I want to work in Toronto."?

And do you realize how really, really cold it gets there?
Darryl Kerkeslager
No kill I

[jimfortune]

Darryl Kerkeslager wrote:

"anyla_80" <al**********@k.ro> wrote

i wont to work in toronto.

Is that "I won't work in Toronto." or "I want to work in Toronto."?

And do you realize how really, really cold it gets there?
Darryl Kerkeslager
No kill I

Your 1D metric needs some augmentation :-). Toronto is a great city.
It is even more multi-cultural than, say, Boston or L.A., including the
largest Asian population in North America. It has a vibrant economy,
moderately low crime, friendly people and great food. It also has lots
of good coffee shops to help fend off the cold. The only negatives are
the cold, the exchange rate (if you work there) and a game of pool
costing a loonie (Canadian dollar coin). I don't include the high
taxes as a negative because of what they get in return, such as free
health insurance. Disclaimer: I don't live in Toronto.
James A. Fortune

[Trevor Best]

Darryl Kerkeslager wrote:

"anyla_80" <al**********@k.ro> wrote

i wont to work in toronto.

Is that "I won't work in Toronto." or "I want to work in Toronto."?

And do you realize how really, really cold it gets there?

put some thick socks on you big jessie :-)

--
This sig left intentionally blank