Solved

Creating a CSV file from a button on a MS Access Form

Posted on 2012-03-20
3
290 Views
Last Modified: 2012-03-21
I have a button on a from that when pressed, creates an export CSV file and saves it out on a network share.  However, my end users are not notified if the export is finished.

Is there a way to present a message back stating that the export has taken place and/or completed?
0
Comment
Question by:HMSImage
3 Comments
 
LVL 42

Expert Comment

by:dqmq
Comment Utility
I'm confused, can't you just throw up a message after the export?
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 100 total points
Comment Utility
Does the export take a long time?

If it's immediate then you can just add a msgbox to the button code you are already using.
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 400 total points
Comment Utility
I agree with peter, just add a msgbox as the last line in the click event of your export button.  Something like:

    msgbox "Export complete"

How are you creating the CSV?  If it takes a while to run, and you are writing the entries one line at a time to a text file, then you might also want to look at some sort of progress bar, to keep your users informed of the progress of the process.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now