Abdul-
If the DLookups are embedded in the report in Control Source properties, you
won't be able to do anything. But if you do the DLookups in code, you
should be able to use the sample code from that web page to update the
status bar after each DLookup.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
Sent: Thursday, May 23, 2013 2:40 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Progress Bar on report opening
<http://stackoverflow.com/questions/11956834/progress-bar-in-in-ms-access#>
I have a report running in Microsoft Access 2010 and it takes 2 - 3 min to
run normally. I would like to present the end user with some status of the
report. A progress bar would be nice. Access seems to be poorly threaded and
locks up tight during the opening of the report negating any updates I try.
my report doesn't use any query actually it has lots of dlookup formulas to
fetch values from many queries & tables
Regards,
Abdul Shakeel
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar