Continuous List Popup
Apr 21, 2006Hi all,
Is it possible to have a Continuous form that is a pop up.
Any ideas.
Many thanks
ADVERTISEMENT
Need To Expand Popup Query List
Jul 27, 2006On my main screen I have a button that I press and it pulls up a
pop up box...in the box you type in one item and hit ok then
the query goes and gets the results.
My quesion:
how do it make it so when I click the button the pop up box
has lets say four areas where I can enter different items and
then it goes and gets all four...or three or whatever I need ?
thanks...
Forms :: Popup List Instead Of Combo Box?
Aug 7, 2014Is there a way to make a popup list open on click of a button (cmdAssign) and the user chooses/selects something from the list, then the popup closes and the textbox (txtAssignmentNo) is filled with the choice?
View 3 Replies View RelatedModules & VBA :: Adding Image - How To Use Continuous Subform Instead Of List Box
Aug 15, 2013I would like to add image to list box but i read somewhere i have to use continuous sub form instead.
Now i like to know in sub form also we can select multi items and it shows highlighted entire of each row and easily getting value if selected items.
Forms :: Continuous Form With Textfields As Records - List Of Years With Totals Of Hours
Jul 1, 2015I have a continious form with textfields as records. Its about total course hours that are calculated. There is a field in the records that holds and calculates the hourse that one have done and another field that holds the max hours they may follow for one year.
Every record has h different year.
When the amount of hours in the transmission textfield is negative, they can transmit the hours to te next year. Therefore i have to calculate the Max hours per Year + the transmission hours.
So the calculation is not a problem. Though i don't actually know where i can trigger the calculation. I have tried it with a button on the form, but then the user always have to click to see the right amount of hours for the next year. That's not handy. I am looking for a way to automatically calculate the field Max hours per year. Given that the Max hours per year is a bound field, its bound to a table where i stock the Max hours that i have calculated.
I also tried it with the button that's used for inserting new course hours, but then it calculates with the old values instead of the new ones.
How can i trigger the calculation automatically without using a button.
A Continuous Form And Continuous Subform, Possible?
Aug 9, 2005What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.
when I put the subform within a subform, access comes up with the following message:
************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.
You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************
which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.
does anyone know of a way around this?
what about Access2003 does it allow this?
help much appreciated.
Steve Ferry
Subform Popup
Jul 16, 2007I 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
How Do I Set To Popup And Modal?
Apr 25, 2005How do I set a form to popup and modal? What field in properties do I use the expression.popup?
View 2 Replies View RelatedIf Then Popup Question
Dec 21, 2005I 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!
Popup Form?
May 17, 2006I'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!
Popup Subforms
Sep 14, 2006Alright, 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
Popup Reports
Sep 14, 2006Hello,
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?
Comfirm Yes No Popup
Dec 21, 2006How 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
Popup Keypad
Dec 22, 2006I 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
Create A Popup
Aug 30, 2004I 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 RelatedPopup Problem
Sep 22, 2004i 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
Popup Form
May 9, 2007I 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.
PopUp Form
Dec 20, 2007On 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 RelatedPopup Forms
Feb 6, 2008Hi 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
Popup Shows Up Asking For ID
Mar 31, 2015I 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] ......
PopUp And Select Value From A Form
Jul 3, 2005Hi 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
Modal Popup Query
Jun 8, 2006Is 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 RelatedAnnoying Popup Messages
Jun 6, 2007I 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
Form Popup Size
Feb 23, 2005Hi
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.
Force Size Of Popup
Feb 24, 2005Is 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 RelatedPopup Form Problem
Jun 22, 2005I 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.