Hi,
I have a report and I am doing some SQL stuff at the back end on the report open. This takes a little time and I want to show the user that its working and I want to prevent him from double clicking the report again. So is there any way to show a progress dialog or something so that the user knows that the list is being built? Thanks in advance!
Adwait
I have some querys and macro command. All that executed just one click button. Now I need to set a Progress Bar with percentage option over all the process.
All the query and macro commands executed behind the progress bar till the 100%.
Can any one hv the code? plz advise.
any idea how I can show a progress bar when a query is running??
View 14 Replies View RelatedHow do I link the progress as shown on screen - with that actual progress that its is supposed to represent?
Ta
I have a form with a man that does carwheels across the form with the message please wait, i have been trying to get this to run while my other form loads and cant get it to work :( either the please wait screen freezes and doesnt do anything till the other screen has loaded... or I have to load the please wait screen and then use a button with continue on it for it to then action opening the second form which is the one that takes the time... either way I am stuck with a frozen screen....... where am I going wrong?
View 3 Replies View RelatedHi,
I am new to Access Forum and I have a very easy question:
I need to show a Progress Meter in a Form whilst my Dbase is running a Macro containing several Queries - these Queries are Delete, Append etc and finally a MsgBox.
Any ideas on How to do a Progess meter whilst the Macro is running??
Thanks
I have developed several applications in code which take anywhere from 15-30 minutes to run, depending on the amount of data and local server traffic. I would like my clients to be able to tell that their process is actually running through some kind of "percentage complete" status bar or progress indicator, rather than their computer sitting there with an hourglass visible for what seems like forever. I would like to set this up where it runs from the form which triggers the code or the like.....any easy way to set this up or any code repository make this easier?
Thanks. Happy new year to all!!
I have a form that, when I press a button it loads another form. The second form takes about 20-25 seconds to load due to the fact that the (split)DB is running over a network, and the form itself has many fields on it. I'm thinking that my users will think that their computer is locked up and keep closing out of the DB. I would like to add a progress meter or percent meter so the user will at least see that something is happening. Has anyone ever programmed one of these things, and if so, could you please give me some insight? Thanks.
Scott
How can I do a progress in bar in a do while. I export contract and during the export i want to have a progress bar.
do while
msgbox "the export runs", progress bar
Loop
Hi,
I'm struggling with a very formal, not to say aesthetic, problem on one of my form used as a progress bar.
This form is very simple, it contains only one unbound control that is called "Percentage".
It displays the percentage of completion, when launching a report based on a somewhat "heavy" crosstab query (lots of records, etc.).
Anyway, the goal is to inform the user that the report is being processed, so that he knows wether he has time to get a coffee, or whatever he wants (the process may take as long as 2 or 3 mn).
As far as code is concerned, the variant "Percentage" is simply incremented in a loop included in the report design code, and refreshes the value of the "Percentage" control displayed in my form.
Everything works fine, except that I can't figure out a way to get rid of the cursor that stays in the unbound control : in fact, the percentage is displayed in reverse video, since the cursor focuses on the control at every iteration. Which gives my "progress bar" form quite an ugly look, and makes it difficult to read, whereas besides this "bug" it is perfectly satisfying.
Any idea anyone ?
Thanks in advance for this.
I am unable to print the progress bar of the syscmd, I have tried checning the progressbar too under the startup.When I put a debug point, it goes to that area and loops through it, by printing it in the immediate window, debug.print.
I have even put a msgbox, to see whether it is popping up, yes it does.I have tried Application.syscmd and syscmd, here I am gonna paste the coding.
Option Compare Database
Option Explicit
Public Sub ProgressMeterModule()
Dim db As DAO.Database
Dim rs As DAO.Recordset
[code]...
I'm making a code to run a Progress Bar from different forms and as per their conditions. Have two forms:
1- Form1="frmProgressMeter"
2- Form2="frmDatabaseStwitcher"
3- Module1=for Functions
On frmDatabaseStwitcher, the code for Progress Bar is:
Option Compare Database
Option Explicit
Private Declare Sub sapiSleep Lib "kernel32" _
Alias "Sleep" _
(ByVal dwMilliseconds As Long)
[code]...
This code is working in two ways:
If I go with "SetProgressBar n / NOS" then progress bar shows 2% and then connecting process time.
Or
If I go with "SetProgressBar n + NOS" then progress works till 100% but then connecting process time.
Also
SetProgressBar (n / NOS) * 100 but then connecting process time.
I have a form that takes sever seconds to load, due in part to the number of records I suppose, however I would like to create a progress meter (form?) that will run while the form is loading. I have tried several different suggestions but none work. Can anyone help me?
Thanks
Mickey
hi everyone,
just wondering if it was possible to have a box that returns the % completion of the current record depending on how much data/how many of the fields of the record have been filled out.
e.g. fields with containing data / total number of fields * 100
possible or not? if so...how is it done?
thanks, james
Is there any way to modify the progress bar so instead of saying "running query" it states the name of the query?
Like: Running Query [qryFRED] <progress bar>
I want a progress bar in a form that will increase from bottom to top . The data will from Access table. The bar will start from 0 to Maxvalue. The Maxvalue will be calculated as below:
Total number of batches in the table/ No. of working days between 14072014 and 31112014 / 2
So the above calculation will define the range of a progress indicator.
And now we have to show the % percentage that means how many batches have been scanned for today. For this the following calculations will be used:
Count total batches where scandate=today and scannedby<>null
Now this will show the percentage in the bar that means hopw much work has been completed.
The progress bar should move from bottom to top when % increases.
I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or requiring user interaction?
View 2 Replies View RelatedHow can I plot a line graph for each students to show their progress in a term and per session in a class, in a subject.
Something that can be visibly seen to know how a student is doing in a subject or in a class.
Now I use wininet.dll library to get file and calculate progress of downloading action it is something like this:
Code:
Do
If InternetReadFile(hRequest, VarPtr(Buffer(0)), BUF_SIZE, dwBytesRead) Then
If WriteFile(hFile, VarPtr(Buffer(0)), dwBytesRead, dwBytesWritten, 0) Then
' TODO:// calculate progress
dwStatus = (dwStatus + dwBytesWritten)
dwPercent = (dwStatus / dwFileSize) * 100
Debug.Print dwPercent
'form1.Caption = dwPercent '<-- change this
[code]....
How can I show a msgbox with the text "Update in progress! Please wait a while", when I execute the following make table querye on form load?
Code:
Private Sub Form_Load()
'Turns the Access warning messages off
DoCmd.SetWarnings False
DoCmd.OpenQuery "q_tblUdtrk2"
'Turns the Access warning messages back on
DoCmd.SetWarnings True
[code]...
We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc.
Is there a way, in Access, to track which "step" of the procedure a user is on? For instance, if they make it through Exercises 1-5, is there a way we can add some sort of indicator that lets them know, when they come back to it a week later, that they left off on Exercise 6? I have seen this done in various software tutorial packages, but I'm not sure how it is accomplished?
Any suggestions?
Basically, I've created a form to track maintenance requests for specific types of equipment. Basically it's like a ticketing system.
Once a user creates the request, I want to use a subform (I guess this is the best way) to let them add data to that specific main form record to track the progress of the request until the repair is made and the "ticket" is closed out.
Do I need to create another table for the "progress reports" (for lack of a better term) or should this be done using some sort of an append query?
I've seen plenty of sample databases where they have a box within a form that looks like a datasheet where these types of "update" notes can be added and then submitted with the click of a button, but I've never been able to get at the code behind it.
I'm aiming to create a stacked area chart to display the progress of multiple projects over time, so we can review and forecast project load over time.
The data comes from this table:
tblProject
* ProjectID
* DateProspect
* DateConfirmed
* DateStarted
* DateComplete
A project passes through the statuses Prospect, Confirmed, Started, Complete. The current status of each is calculated in qryStatus from the dates in tblProject. The past and forecast statuses for each project will probably be calculated each time the chart is created (or maybe not necessarily so?)
To create the stacked area chart, the x-axis will be months (e.g. Sept 2013 - July 2015). On the y-axis will be the count of ProjectID, and the series will be the different project statuses.
The sticking point is getting from the Date* fields to the past and forecast statuses in each month. After that I imagine it'll be reasonably straightforward to put into a pivot/chart.
Hi All.
I created query with dialog box in Access :
SELECT (Format([Date_P],"mmm yyyy")) AS [Date_P], Result, Count([Date_P]) AS Pos
FROM ABC
GROUP BY (Format([Date_P],"mmm yyyy")), Result, Format([Date_PAP],"yyyy")
HAVING Result<>"neg" AND Count(Date_P>0
AND (Format([Date_P],"yyyy")=[Please, enter year (yyyy):]);
How to convert that query to veiw MS SQL?
Thank.
Ok the question may sound cryptic, but I have a large database with many forms that all contains VBA code that can be iniated via a button and will perform some time consuming work.
I would like to be able to view some kind of status or progress of the work performed. Perhaps even dynamically like in from 0-100% work done.
Example send some status text to either a popup form or even the bottom "statusbar" text area. The problem with the latter is that I know how to change it via VBA, but as far as I know it requires me to access and change it using form and object. But I need this from so many forms and objects (buttons) that I would need to do a lot of code rework to actually know where I am calling my VBA code from.
Is it possible to change the status text "universally", that is without regards to a form and object?
Or how else can I go about to display some status/progress text which will work from any form and object without passing form and object name.
Hi all,
Can I set the default path for a dialog box to look in when called?