473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Send a pop up box behind a report

When my report opens my pop-up form (which is not modal) appears on
top of the report.

I use the on No Data event to show a message to the user if no records
are to be displayed and then when OK is pressed they are returned to
the pop-up form to try again.

I don't seem to be able to use On Open event for the report to do
anything as the On No Data then kicks in as the report has already
opened. When I try alternatives such as making the form active and
changing its visible property to false so only the report appears, it
falls down if the report has no data and me.visible becomes the
current form which hides it. I can get some kind of success, but the
pop-up box keeps closing after the message appears notifying of no
records.

So, this is what i want:

When I press the button on my pop-up form I want the report to open in
front of it. So When I close the report the pop-up form is still
there. When the message box showing the user that no records are
there, I again want the pop-up form to remain when the message box is
closed down.

Cheers for any help.
Nov 12 '05 #1
2 1903
Pop-ups do not work the way you want -- you'll have to use something other
than a "modal"-type form. Use a normal form and it'll still be there, but
won't stay on top of the report.

Larry Linson
Microsoft Access MVP

"Carl" <ca**********@newcastle.gov.uk> wrote in message
news:ab*************************@posting.google.co m...
When my report opens my pop-up form (which is not modal) appears on
top of the report.

I use the on No Data event to show a message to the user if no records
are to be displayed and then when OK is pressed they are returned to
the pop-up form to try again.

I don't seem to be able to use On Open event for the report to do
anything as the On No Data then kicks in as the report has already
opened. When I try alternatives such as making the form active and
changing its visible property to false so only the report appears, it
falls down if the report has no data and me.visible becomes the
current form which hides it. I can get some kind of success, but the
pop-up box keeps closing after the message appears notifying of no
records.

So, this is what i want:

When I press the button on my pop-up form I want the report to open in
front of it. So When I close the report the pop-up form is still
there. When the message box showing the user that no records are
there, I again want the pop-up form to remain when the message box is
closed down.

Cheers for any help.

Nov 12 '05 #2
You mean you *cannot* use the NoData event of the report to just
cancel the open?

Private Sub Report_NoData(Cancel As Integer)
MsgBox "no data... we're outta here!"
Cancel = True
End Sub

Will that not work?

You could move the message to another routine and call it while
closing the report...
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Johnny Gee | last post by:
Hi All I have a macro that I use to send three reports every week to about 10 people by email via Lotus Notes.I use the "Send To" command to send the reports out in Rich Text Format. I used RTF...
0
by: Simon | last post by:
Hi, I am using ASP.NET with C# and Crystal Report. I have a textbox et a asp.net button. I send a number in the texte, I push the button and I want to see the report with value related to the...
1
by: Pat | last post by:
All, What I want to do: ******************* Click on a hyperlink in the last column in a datagrid, have it grab a value in the fourth column in the same row and send it to the codehind into a...
6
by: toufik | last post by:
Hi, I've a crystal reports Report, Is it possible to send it by email? how? Thanks
17
by: rdemyan | last post by:
My app creates a building report. My users have requested that I provide functionality to e-mail these "building reports" to building managers once a month. So assuming that I have the...
0
by: dreamsoul620 via AccessMonster.com | last post by:
Hi all! I'm trying to set up an email application for my database. I tried linking to my Outlook address book, but when reading from the table, I receive an error message saying I need to restart...
1
by: shil | last post by:
Hi, I'm using FW 2.0 to send an email with an attachment using System.Net.Mail class. If I try to attach a file from my file system, I could successfully send the eamil. But I need to generate a...
1
by: pixie | last post by:
Hi. Access 2003. The database stores contract information. I have a query for each person that is responsible for contracts. The query checks to see if there are reports due either this week,...
3
by: nithya jayaraman | last post by:
Hi, pls clarify these questions. 1. How can I send some values of globla variables from VB to crystal report. I want to show these values on report. my database in MS Access My query...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.