Popup Reports
Sep 14, 2006
Hello,
I have an application where all the forms are popup (i.e. the PopUp property is set to True). It was done because the customer wanted to see only one entry of the application on the taskbar. Now I have a real problem! When the customer opens reports in preview mode, he gets it opened BEHIND the application forms =( So he can't see it. And there is no "PopUp" property for report... What should I do? How can I put the report ON TOP?
View Replies
ADVERTISEMENT
Nov 10, 2014
I use the following code in the On No Data event of a report:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data exists for the date range entered.", vbInformation, "No Data Alert"
Cancel = True
End Sub
This works fine to cancel the opening of the report however Ms Access annoyingly then pop-ups another alert that reads as follows:
"The OpenReport action was cancelled". There is no error number.
I've tried putting in a DoCmd.Close after Cancel = True however this doesn't do the job.
Any way to prevent the Ms Access pop-up from appearing?
View 4 Replies
View Related
Dec 22, 2013
I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.
Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?
View 4 Replies
View Related
Jul 5, 2014
I have a report that lists incidents for a specific day (reference number, a brief description and a few other fields). There is also an additional notes field, which I would like to be viewable from within the report.
For example, as a tooltip when the mouse hovers over the brief description text box. Or displayed in a textbox on the right (I don't want one textbox per line though, but instead a single re-usable textbox). Or a more information button/link that shows a "popup" containing the additional notes. I don't want to exit out of the current report, but stay within it.
I have tried to achieve this with a tooltip, but in fact even when I manually typed in a tooltip on the control's properties it wasn't displayed when I hovered over the text box.A pop-up or floating textbox would be preferable.
View 9 Replies
View Related
Jul 16, 2007
I have a subform I am using on a form. I would like to modify the code below that I have for a button on the form. I would like to use the master and child field link in the code below to only show candidates related to the main form. The link is candidate id. I have this working with a subform on the form but I would like to have this only display as a pop-up once the user clicks the button on the form. Is this possible? Thanks..
Private Sub Candidates_Click()
On Error GoTo Err_Candidates_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CandidatesCPR_Frm"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Candidates_Click:
Exit Sub
Err_Candidates_Click:
MsgBox Err.Description
Resume Exit_Candidates_Click
End Sub
View 1 Replies
View Related
Apr 25, 2005
How do I set a form to popup and modal? What field in properties do I use the expression.popup?
View 2 Replies
View Related
Dec 21, 2005
I have a form that we use to enter our workorders (jobs) into the database. The bottom of the form runs a query and returns record information if a car has been in our facility before.
I would like to program it so that if the query does in fact find a previous record it pops up a window or message that says so.
Basically I need something like...
If the arrival date (and/or) item number is not null then popup a message that tells you the car has been here before.
Thanks!
View 7 Replies
View Related
May 17, 2006
I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice.
So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.
But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.
Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?
Thanks!
View 11 Replies
View Related
Sep 14, 2006
Alright, I did a search for this and came up blank, but I'm sure its been asked a million times, sorry for the inconvenience:D
Is it possible to make a subform a popup form? I have a client table --1--to-many--> service table and want the service form to popup out of the client form. But I also want to the foreign key to autopopulate just like a subform would. Is there any way to do this? Are there any pitfalls to doing it this way?
Thanks in advance,
Ox
View 3 Replies
View Related
Dec 21, 2006
How do i go about making a confirm yes and no dialog.
I know i can do it with a form, but would rather have a proper one :D
View 2 Replies
View Related
Dec 22, 2006
I would like to make a form that would pop up in a standard keypad format. This would allow me to enter the number and on close, it would place it in a chosen field. I saw the one that was is a previous thread and it does make sense to me.
Thanks for the help
View 1 Replies
View Related
Aug 30, 2004
I am using an Access generated number for a "ref. number" I would like to know how when im in a form shown the box that would house that number, and someone clicks on the "ref, number" box a popup "search" would appear.
View 1 Replies
View Related
Sep 22, 2004
i have a Simple form called people. it has three feilds on it called
name
address
city
i have a button next to address that onclick popups up the form called address.
once the user finds the data i have a ok button. Now what i want done is when they click ok
it populates the address field on the people form. no one seems to be able to help me?
NAy examples would be great
thanks
View 1 Replies
View Related
May 9, 2007
I have made a message service in access db using a pop up on timer even.
It works fine but sometimes it does not load. My db is split db and so what ever I am doing, doing on my machines only. So is there any way to check if a form is loaded and if its loaded then do requery.
View 1 Replies
View Related
Dec 20, 2007
On opening the form, i want to give a command with Move To command to move to the right upper corner. Is there any such command ?
View 1 Replies
View Related
Feb 6, 2008
Hi everyone,
I have a main form showing a number if information for one project. Within this form I have yes/no buttons that when clicked, open a popup form where you can add additional data. The problem I'm having is that when opened, the record # for the pop form does not match the record # for the main form.
Example: Let's say I'm in the main form and showing record #5. When I click the yes/no button to add extra info, the popup form opens but it shows record #1, not #5.
Any ideas how to tell the popup form to link with the corresponding record would be very much appreaciated.
Thanks
View 6 Replies
View Related
Mar 31, 2015
I am getting 2 problems what I am trying to do is depending on the user logging in I want to open form (Aform) on specific record for that person ID. However where Y=1 I am getting a popup asking for AForm ID and where Y=2 I am getting run time error 3075 Syntax error (missing operator) in query expression.
Code:
Private Sub Command6_Click()
If IsNull(txtUsername) Then
MsgBox "Invalid username"
Exit Sub
End If
If IsNull(txtPassword) Then
MsgBox "Invalid password"
[Code] ......
View 1 Replies
View Related
Apr 21, 2006
Hi all,
Is it possible to have a Continuous form that is a pop up.
Any ideas.
Many thanks
View 1 Replies
View Related
Jul 3, 2005
Hi All,
I have a form that has a combo box and a subform. After a choose the value of the combo box I want to start adding values into the subform, and I want to be able to select the values that are to go into the subform fields. Now I am thinking of using a pop-up subform which shows the values that I can choose from and then as I close the form it will populate the fields of the main subform.
Is it possible and has anyone got a little example of form that can do that. If so can you put it as an attachment to this post.
Thanks
Greg
View 1 Replies
View Related
Jun 8, 2006
Is it possible to make a query Pop-up? All of my forms are set so the Database background is hidden and they popup. I haven't been able to figure a way to do this with a query. Any help or suggestions would be great :)
View 6 Replies
View Related
Jun 6, 2007
I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either.
Here's my problem:
I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always :) ). Every time I run the query it keeps wanting me to re-enter the data that it was supposed to look at anyway! If you need more info, just ask. Thanks.
Anonymous_354
P.S.: I'm really new at this. I just learned about Access a week ago.
P.P.S.: I use Access 2000
View 14 Replies
View Related
Feb 23, 2005
Hi
All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.
Could someone please help me pls?
Thanks.
View 3 Replies
View Related
Feb 24, 2005
Is there a way to force the size of a popup form? I want it to be around 3.5" by 4" because every time it popus up it is only around 2" by 1" and i have to resize it to look right.
View 1 Replies
View Related
Jun 22, 2005
I have a [frmMain] form which i would like to run maximised.
I also have a button on the [Main] that opens another form [frmAdjust]
in Popup mode, because i do not want this form to be maximised.
The problem i have is that when i return to the [frmMain] after closing
the [frmAdjust] i want to update a subform [subAdjustment] on return.
The Event i would like to use, the Activate event is not fired on return
from a form with the popup property set. The GotFocus event of the form does not
work either.
Which event would i use for this or how could i get around this.
View 3 Replies
View Related
Aug 19, 2005
Greeting
i'm kind of a rookie with access : )
i'm using the attached popup calander in my form and subform ,,,
it works perfect in my form
but when using in the subform, i get an error saying "the specified form can't be found"
if i open the subform as a form it works
so my question, is do i have to change anything in the calandar code so it could open in subform as well ??
if yes how ?
thanks in advance
View 6 Replies
View Related
Dec 6, 2005
I can't seem to get this to work. I have a Mainfrm with a Subfrm. On the Subfrm I have a field that has to be a concatenation of two inputs. To do this I have created a PopUpfrm for that field that has two list boxes. The user then chooses one from ListA and one from ListB. This populates an unbound field (fldCode) on the PopUpfrm. I need to pass this data to the original field on the Subfrm.
I've tried:
Forms!Mainfrm!Subfrm.Form.Field1 = me.fldCode
and every possible iteration of this that I can figure out.
Any suggestions on how to pass this information back to the Subfrm.Field1?
If I run just the Subfrm, w/o opening the Mainfrm everything works great. I guess I just don't know how to reference that field when it is actually in the Mainfrm.
Thanks in advance
View 7 Replies
View Related