Solved

Loading Notification

Posted on 2014-01-31
6
167 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
[X]
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
  • 2
  • 2
  • 2
6 Comments
 
LVL 48

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 58

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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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 58
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 48

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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

724 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