I want to open another form automatically when an initial form opens, both are non popup) I have tried open and load events - but still the calling form appears on top of the called form.
How do I get the two forms to open form 1 and then form 2?
Also I cannot use the timer event as this is doing something else.
when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
Is there a way to close a form that is open from another form that has the focus. I tried using the Unload event, but I received an error message "Cant load or unload the object". I would appreciate any help!
Problem: Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.
I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.
The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.
(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)
Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.
Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"
Can anyone help me? I've googled this but finding no answers.
I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.
I have noticed that on our network, certain people can open an Access db that is already open by another person, yet some cannot. We are using the same shortcut (to the mdb file) and all have the same windows read/write permissions.
Good day, I have set up some forms for reps to call on accounts, bridging 2 tables (one with companies, the other with contacts) by account number. We do frequent mailings of the updated customers, afterward, I remove the mailed name to keep a rep from re contacting the updated person. After removing records yesterday, no one is able to open the form. It simply shows the hour glass for about a second, and resumes sitting there as though nothing's wrong. I also cannot open the form's design view to see if there are any fields missing, etc. It doesn't even give me an error message to help track down the issue. Anyone have any ideas on how to get my forms to open again? Thanks!
I have a form on my database that requires information to be added to it when the user first uses the database. What i want is that when the user re-opens the DB then this form doesn't open. The form contains information on the users address and only requires them to fill out a phone number. The table contains numerous user details execpt for the telephone number as this is the only data they are required to fill out. Can anyone help please. i did have this working when i required the user to add all entries, by using recordset. then someone asked me to pre-fill the addresses and only ask for the telephone number.
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
I have a form, which is based on a table. Usually I have forms open to new or last records, but in this case I need it to open sorted by reportnumber. I read up on the orderby property, which I tried on open without any luck. Any ideas, other than basing by forms on queries....
I was wondering if it was possible to add a parameter to the record source Query of a form depending on the value of an other field on the open event of the same form? I was thinking to use 3 Sql statment SQL1, SQL2, SQL3, on the open event of the FrmOpen. On Open then the RowSource of FrmOpen =SQL1 If field? = "A" Then the RowSource of FrmOpen=SQL2 Else the RowSource of FrmOpen=SQL3 End If I did try but it doesn't work so I needed to know if it was possible to achieve this or not?
I have a tab controled form and when it opens in form view the tabs are to high to be seen on the page and you have to use the scroll bars to have access to them.
What in the world am I doing wrong. I cannot get this to open correctly and my form fits just fine on one screen in design view.
I've run into a strange problem. I'm trying to have an image box that you can double click and it will open a different form with a full sized image. When I open my form with the larger image, it asks me for a Parameter Value. Is there any way to stop it from asking me for that? Also, what is a parameter value and should I be typing something there?
Any ideas you may have would really help me out. Thanks a lot in advance!!
I have a form that has a button, when user presses that button another form is supposed to open in minium view. The problem is that: If my main form is maximized, the other form opens as max or the other form makes main form minimized.
I wonder if it's possible for the main form to remain maximized when the smaller form opens?
I have a form with a subform on it. My subform gets populated by a lookup. On my main form I have an unbound (cboLotIDLU) lookup field and also a text box (LotID) that shows the chosen record. When I open the form my cboLotIDLU is blank but my LotID has an ID in it so the info for that ID is displayed on my subform. I would like everything to open up blank. I've looked around and I can't see where that first record is coming from. How do I get it so everything comes up empty?
Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.
i have a form that has various buttons. one button will open a form to add a payment based on the person shown on the main form. how can i open the new form to be ready for a new record but already set up for the person shown? for example: "main form" the name shows Nigel Shaw press button " add payment" Payment form opens on top ready to receive info with my name already shown.
i have based my payment form on a qry and i core around ContractorID
i am trying to open a form if all conditions are met. if the conditions are not met, then they get a flash message and then the user should return to the open form. i have the condition checking working but cannot seem to open the form if ALL conditions are true. i also need to close the form when the new form opens.how could i achieve this? here is my code
Private Sub MidVerifyContinue_Click()
FullNameChk.SetFocus
If FullNameChk = False Then MsgBox "You Need to have a Full Name to Verify", vbOKOnly, "Message" End If
If CompNameChk = False Then MsgBox "You Need to have a Company Name to Verify", vbOKOnly, "Message" End If
If TradeNameChk = False Then MsgBox "You Need to have a Trading as name to Verify", vbOKOnly, "Message" End If
If UTChk = False Then MsgBox "You Need to have a number to Verify", vbOKOnly, "Message" End If
If CRChk = False Then MsgBox "You Need to have a C R number to Verify", vbOKOnly, "Message" End If
If NIChk = False Then MsgBox "You Need to have a N I number to Verify", vbOKOnly, "Message" End If
If PostCodeChk = False Then MsgBox "You Need to have a Postcode to Verify", vbOKOnly, "Message" End If