After Open Open Another Form

Jul 26, 2005

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.

Thanks

View Replies


ADVERTISEMENT

Forms :: When Open A Form / Want To Open Another From At Same

Jan 14, 2015

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.

View 2 Replies View Related

Reports :: Can Create A Date Parameter Box Open Up / When Open Report

Sep 21, 2014

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.

View 5 Replies View Related

Closing An Open Form From Another Form That Is Open

Dec 17, 2004

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!

View 1 Replies View Related

What Have I Done? You Can't Open A Subform When It Is Also Open In Design View

Jun 1, 2006

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.

View 1 Replies View Related

Forms :: Click Button To Open Dropdown To Open Record The Filters By Dropdown

Jul 28, 2014

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.

View 1 Replies View Related

Why Some Can Some Can't Open Shared Db That's Open?

Jul 23, 2007

Hi,

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.

I can only think it is some setting in Access?

Can anyone help point me along the right path?

View 1 Replies View Related

Open Form In Another DB

Mar 22, 2006

how can I open form that in another file.

I have 2 access files (*.mdb) opened, I want when I click on one I open form in the secend file.

how can I do it?

thanks!

View 1 Replies View Related

Is The Form Open ?

Jan 30, 2006

Just wondering if there is a method to check if a form is open or not ?

View 2 Replies View Related

Won't Allow Me To Open A Form

Jul 26, 2006

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!

View 3 Replies View Related

Is Form Open

Sep 6, 2006

Hi

I know this is stupid but ... I looked in my book and it said it you want to test whether a form is open you can do this ...

If FormName.IsLoaded = True Then

If I try this it tells me 'IsLoaded' is not a valid property.

How do you test if a specific form is open?

Cheers

View 13 Replies View Related

On Open Form

Mar 6, 2005

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.

Can anyone help

View 3 Replies View Related

Help Plz // Open Only Form

Apr 20, 2005

hi

I want when user dblclk on shortcut of my index form open only the forms as exe
and i don't want to open the access with it background.

View 1 Replies View Related

Open Form

Oct 10, 2006

Hi all

I need an if then statement that says

If a particular form is open then

do event

What statement should I use to see if a form is open??

Thanks

View 2 Replies View Related

Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form

Mar 26, 2013

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.

View 5 Replies View Related

Sorting On Open (form)

Apr 13, 2006

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....

View 1 Replies View Related

Open A Form From A Combo Box

Aug 29, 2005

Hi all,

The title says it all; how can I make a form appear when something is selected from a combo box?

Thanks in advance,

Atholl

View 2 Replies View Related

Criteria On Open A Form

Nov 16, 2005

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?

View 1 Replies View Related

Why Does My Form Open With Out My Tabs?

Feb 7, 2006

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.

Tammy

View 4 Replies View Related

Open A Form On Startup

Aug 18, 2006

I've never actually had to do this before so i dont know how! Im sure its really simple.

How would i set the database to automatically open a form when the database loads up?

View 1 Replies View Related

Open Form Parameter

Aug 24, 2006

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!!

View 6 Replies View Related

Open Form In Min View

Sep 29, 2006

Hi,

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?

Regards,
B

View 3 Replies View Related

Form Open Up Empty

May 31, 2007

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?

View 14 Replies View Related

Open Database From Form

Jan 7, 2008

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.

View 8 Replies View Related

Open Form To New Record

Jan 14, 2008

Hi,

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

many thanks,

NS

View 3 Replies View Related

Open Form On All Conditions Met

Feb 9, 2008

Hi,

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

Exit Sub


DoCmd.OpenForm "New Verification Qry"

End Sub


many thanks,

Nigel

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved