I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?
Thank you.
Greg Teets
Cincinnati OH USA
4  1548 
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:
Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()
-Tom. I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?
Thank you.
Greg Teets
Cincinnati OH USA
On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote: On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:
Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()
-Tom.
I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?
Thank you.
Greg Teets
Cincinnati OH USA
How can I verify that the report actually ran before posting the time?
Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?
Thanks.
Greg
On Mon, 05 Sep 2005 19:35:56 GMT, Greg <gt******@yahoo.com> wrote:
Well, DoCmd.OpenReport WILL open the report, so in a sense it ran.
Perhaps you have some code in the Report_Open event to cancel the
report if the user has insufficient rights to see the report. You
could use a global variable to signal that back to the calling
function.
Perhaps you have some code in the Report_NoData event. The same
applies.
Otherwise I don't know what you mean, and you may need to elaborate.
-Tom. On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:
Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()
-Tom.
I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?
Thank you.
Greg Teets
Cincinnati OH USA
How can I verify that the report actually ran before posting the time?
Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?
Thanks.
Greg
Great ideas.
Thank you.
On Tue, 06 Sep 2005 18:18:12 -0700, Tom van Stiphout
<no*************@cox.net> wrote: On Mon, 05 Sep 2005 19:35:56 GMT, Greg <gt******@yahoo.com> wrote:
Well, DoCmd.OpenReport WILL open the report, so in a sense it ran.
Perhaps you have some code in the Report_Open event to cancel the
report if the user has insufficient rights to see the report. You
could use a global variable to signal that back to the calling
function.
Perhaps you have some code in the Report_NoData event. The same
applies.
Otherwise I don't know what you mean, and you may need to elaborate.
-Tom.
On Sun, 04 Sep 2005 22:14:32 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Mon, 05 Sep 2005 04:17:42 GMT, Greg Teets <gt******@yahoo.com>
wrote:
Or use VB's Now() function:
RunAccessReport()
Msgbox "Report time: " & Now()
-Tom.
I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs? Or to find the data in the ACCESS system tables?
Thank you.
Greg Teets
Cincinnati OH USA
How can I verify that the report actually ran before posting the time?
Maybe I have to do this in the Access side, but I would like VB to
verify that the report ran and then display the time. Can I return a
"completion" code to VB?
Thanks.
Greg This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Andante.in.Blue |
last post by:
I just browsed through some of my Access links when I came across the
Ten Commandments of Access
(http://www.mvps.org/access/tencommandments.htm). Some of the points
I heartily agree with (and...
|
by: Frederick Noronha \(FN\) |
last post by:
---------- Forwarded message ----------
Solutions to Everyday User Interface and Programming Problems
O'Reilly Releases "Access Cookbook, Second Edition"
Sebastopol, CA--Neither reference book...
|
by: Norma |
last post by:
I am posting this again since I am on a deadline to get this
completed... Sorry for being redundant...
I have a table with a UPC#, CasesCompleted, TotalHours, standardGoal
(pieces per hour)
I...
|
by: Terri |
last post by:
The following query will give me the top ten states with the most callers.
SELECT TOP 10 Count(Callers.CallerID) AS CountOfCallerID, Callers.State
FROM Callers
GROUP BY Callers.State
ORDER BY...
|
by: thomasp |
last post by:
For those who gave advice on the shortfalls of my first attempt at writing a
vb.net class, Thank You.
I hope that I was able to apply some of your advice to this larger atempt.
At first I didn' t...
|
by: Kalpesh |
last post by:
Hi All,
I am using .net crystal reports to develop the reports. The version of
crystal report assemblies is 10.2.3600.0. When i run the reports i got
following error.
#region Retry Report...
|
by: MDANH2002 |
last post by:
Hi
From VB.NET I want to simulate the POST request of the following HTML form
<html>
<title>HTTP Post Testing</title>
<body>
<form action=http://www.example.com/postdata ...
|
by: zion4ever |
last post by:
Hello good people,
Please bear with me as this is my first post and I am relative new to ASP. I do have VB6 experience. I have a form which enables users within our company to do an intranet...
|
by: Henry Stock |
last post by:
I am trying to understand the following error:
Any thing you can tell me about this is appreciated.
Security Exception
Description: The application attempted to perform an operation not allowed...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
