Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Loading Notification

Posted on 2014-01-31
6
164 Views
Last Modified: 2014-02-01
Hi There,

I've not seen a real solution to this (or at least one that I've truly understood) so I thought perhaps I would throw it out there and see if anyone here has done it.  I'm wondering if there is a good way of letting the user know when a form/data is loading?  I've done the docmd.hourglass true thing, but I wondered if there was a way to display a form or maybe something better to let them know it's working in the background?

Thanks!

Sarah
0
Comment
Question by:SarahDaisy8
  • 2
  • 2
  • 2
6 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39824432
I have an article on Progress Bars that might help.  Provides some ideas and a sample form that you can customize for your purposes.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39824449
Sarah,

 Couple of things you can do:

1. Use the system bar at the bottom to put up a notice.

2. Use a light weight form that you display first as a progress bar or "splash" screen while your waiting for something to happen.

 I like #2 as I find many don't think to look at the bottom of the screen when something is not happening.

 So in reference to #2, I've attached a small sample DB which has a progress bar class (a form), which you can call in a number of ways.

Jim.
ProgressBar.mdb
0
 
LVL 1

Author Closing Comment

by:SarahDaisy8
ID: 39825103
This is BEAUTIFUL!! So perfect for what I need and I have some choices now, thank you so much!
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Author Comment

by:SarahDaisy8
ID: 39825114
Thank you Ace, I'm sorry I didn't see your solution, but I will definitely review your work.  Appreciate you taking the time.

-Sarah
0
 
LVL 57
ID: 39826333
Sarah,

 We can un-accept the question if you'd like to close it out differently and give fyed the solution and/or split points between us.

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39826753
Sarah,

I've got no problem with the current point distribution, don't worry about it.  My guess is that Jim's and my solutions are not that much different.

Dale
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

856 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