Solved

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

Posted on 2012-03-20
3
310 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
ID: 37745717
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
ID: 37746215
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
ID: 37746645
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Viewers will learn how the fundamental information of how to create a table.

808 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