Changing filepath name when exporting?

  • Thread starter Thread starter Makira
  • Start date Start date
M

Makira

Not sure if this is the right place to ask this question, but here it goes...

I do data entry at home with a 2000 Office Suite MS Access db placed on my
computer from work. I use Windows XP home edition, btw. It's a basic db
w/name/address fields. When I click on the customized export button, it's
supposed to export it into a txt file on my desktop. Problem is, I'm getting
an error msg stating the filename path to export into doesn't exist, which it
doesn't. The filename path is goofed up and wrong.

I need to figure out how to go into Access and change the filename path in
the macro ExportOperator1 to where my txt file is actually located. Is there
a way to find this macro or see a listing of all the macros for me to change
their properties?

My work is guarding this simple fix like it's a CIA secret and refuses to
show me how to change it, even though it's not working. Please help.
 
I finally found it just after I wrote the post and I wish I could delete this
one. For anyone else who may have this problem, here's the solution:

- Open up your database in Design View
- Click on the little icon called Database that is under the main
File/Edit/View/etc.
menu
- A box will open up and should list all your macros on the right screen
with
everything else listed on the left you can toggle and look at.
- Click on the macro you want to highlight and click the Design icon up at
the top
of the box. This will open up a larger box and you can see the filename
path li
listed for you to change.

Thank gods I finally figured it out!
 
Back
Top