Export to Excel with form Progress Bar
in [General]
|
Prev: franck
Next: Why Access 2007 donot have the "Data Access Page" Function ? How I can do with 2007 for this issue ?
From: Daniel on 2 May 2010 04:07 I have a form which when clicking the command button transfers (or exports) the data from two separate tables in my database into two separate Excel spreadsheets While this is running, I would like to show its status using a progress bar (built into the form, rather than showing it on the status bar, which is hidden) - I've searched on the net but cannot seem to find what I am looking for. Any suggestions or help would be appreciated. Thanks in advance Dan
From: Arvin Meyer [MVP] on 2 May 2010 05:55 How about this one: http://accessmvp.com/SDaigle/ProgressMeter.ZIP -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Daniel" <djb1000(a)talk21.com> wrote in message news:5C290198-DB6A-41ED-8301-6B5710FBF6B7(a)microsoft.com... >I have a form which when clicking the command button transfers (or exports) >the data from two separate tables in my database into two separate Excel >spreadsheets > > While this is running, I would like to show its status using a progress > bar (built into the form, rather than showing it on the status bar, which > is hidden) - I've searched on the net but cannot seem to find what I am > looking for. > > Any suggestions or help would be appreciated. > > Thanks in advance > > Dan
From: Daniel on 2 May 2010 06:51
that'll do me fine - thank you very much "Arvin Meyer [MVP]" <arvinm(a)mvps.invalid> wrote in message news:e2CiU2d6KHA.5112(a)TK2MSFTNGP02.phx.gbl... > How about this one: > > http://accessmvp.com/SDaigle/ProgressMeter.ZIP > > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.accessmvp.com > http://www.mvps.org/access > > > "Daniel" <djb1000(a)talk21.com> wrote in message > news:5C290198-DB6A-41ED-8301-6B5710FBF6B7(a)microsoft.com... >>I have a form which when clicking the command button transfers (or >>exports) the data from two separate tables in my database into two >>separate Excel spreadsheets >> >> While this is running, I would like to show its status using a progress >> bar (built into the form, rather than showing it on the status bar, which >> is hidden) - I've searched on the net but cannot seem to find what I am >> looking for. >> >> Any suggestions or help would be appreciated. >> >> Thanks in advance >> >> Dan > > |