How To Create A "status" Or Progress [popup] Display
Jan 8, 2006
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.
View Replies
ADVERTISEMENT
Dec 27, 2005
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!!
View 3 Replies
View Related
Dec 4, 2006
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
View 4 Replies
View Related
Jun 24, 2013
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 Related
Apr 13, 2007
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?
View 1 Replies
View Related
Sep 7, 2005
Hey guys, I am trying to creat a query from my Status table, but having NO luck getting it to work. Basicly the Query is going to create brand new columns with the Status entry from the row selected. I have been able to create a query with 1 status column, but I cann't seem to figure out how to code it where it creates a 2nd. Heres what I have
SELECT SiteStatus.Status AS MailStatus
FROM SiteStatus
WHERE (([SiteStatus].[Site Component]="mail"));
Some how I need the Where statement to go along with the new Mailstatus column and then create a new column with the same effect, have it select the status from the row what contains the "component" in the "component" col. Anyone get any of this cause its starting to confuse me even now. Using Access 2003
View 2 Replies
View Related
Aug 30, 2004
I am using an Access generated number for a "ref. number" I would like to know how when im in a form shown the box that would house that number, and someone clicks on the "ref, number" box a popup "search" would appear.
View 1 Replies
View Related
Jul 25, 2013
I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.
View 4 Replies
View Related
Jan 7, 2014
What is the syntax to display a particular record inside of a tab located on a pop-up?
In other words,
I have a pop-up called People_Enter.
On People_Enter is a tabbed control called TabCtl89
On tab (2) is a subform called company_contacts_attachcompany that displays a Single Form record.
I want to open that particular Single Form where EntryId = value
I know how to assign the Where but not how to call the form.
View 4 Replies
View Related
Nov 20, 2013
I know how to do an action on doubleclick or mouseover but I want some simple text to come up, possibly with a white background behind it that has some details about the specific production number that the user is clicking on. Is there something like this? I tried a dialog but it brings up an ugly form, I just want the text or something simple. Can this be done?
View 2 Replies
View Related
Dec 22, 2013
I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.
Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?
View 4 Replies
View Related
May 24, 2007
hiya, just posted a message today.
Problem, ive got a work database which employees logon to and enter time against certain projects they have been working on. What i need is to somehow create some code that will look at each of the employees names and sum up there total time for the previous day. If this is less than say 6 hours of timesheets or even zero entries have been made, I want a pop up message to pop up as soon as they logon to the datatbase the next day and jsut mention they need to fill in there timesheets.
At the moment each person when they log on to the database has there name they logged in as, placed into a field (called "First Name") within form (called "Employee Startup Screen"). *** maybe use this as a way to identify who is logged on and when to run the code.***
Timesheet table has the following columns:
Employee; Date; ProjectID; Timespent
PLEASE help im a noob at this and have tried using some code on a query that sums up the previous days times filter on a employee. When the "Employee Startup Screen" opens it runs the following code
Dim internal1 As Integer
internal1 = Me.SumOfTimeSpent
If internal1 < 6 Then
MsgBox " Less than 6 hours have been entered " & Chr(13) & " into your timesheet for yesterday. ", vbCritical, Title1
ElseIf DCount("*", Me.SumOfTimeSpent) <> 0 Then
end if
End Sub
----------------------------
BUT it doesnt work if no entries have been made on the timesheet as the query result is blank.
ANY help would be muchly appreciated.
Thanks Keith
View 4 Replies
View Related
Apr 30, 2013
I want to create a country info database. For example, Qatar (country) and the Driving info required when driving in qatar and the visa info required.
I would like a form with drop down options and when i selected which country and then driving or visa, at the bottom it would display the specific info based on my selection in a memo field lets say.
View 1 Replies
View Related
Mar 28, 2007
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.
View 2 Replies
View Related
Nov 12, 2005
any idea how I can show a progress bar when a query is running??
View 14 Replies
View Related
Jun 27, 2007
How do I link the progress as shown on screen - with that actual progress that its is supposed to represent?
Ta
View 5 Replies
View Related
May 11, 2005
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 Related
Nov 4, 2005
Hi,
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
View 1 Replies
View Related
Nov 19, 2004
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
View 1 Replies
View Related
Mar 30, 2005
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
View 2 Replies
View Related
Aug 22, 2014
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
View 13 Replies
View Related
May 17, 2005
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.
View 4 Replies
View Related
Aug 19, 2013
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]...
View 5 Replies
View Related
Mar 27, 2015
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.
View 6 Replies
View Related
Oct 29, 2006
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
View 4 Replies
View Related
Nov 8, 2013
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>
View 1 Replies
View Related