If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open form when database opens
Hi, I now have Microsoft 2007 and just built a form that I would like to open
when the database opens. It's been a while since working on these kinds of commans but I have spent about 2 hours reading up on help and searching through the threads to find the answer. I am a little basic on the programming side so if someone could help with step by step that would be so much appreciated :-) Angeline |
#2
|
|||
|
|||
Open form when database opens
Click the Office Button (top left.)
Click Access Options (bottom of dialog.) Click Current Database. Specify a startup form. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi, I now have Microsoft 2007 and just built a form that I would like to open when the database opens. It's been a while since working on these kinds of commans but I have spent about 2 hours reading up on help and searching through the threads to find the answer. I am a little basic on the programming side so if someone could help with step by step that would be so much appreciated :-) Angeline |
#3
|
|||
|
|||
Open form when database opens
Hi Allen, thanks so much for the response. Got it working. If you wouldn't mind answering one more thing. I'd like to maximise the form when it opens. I clicked on the Form propertys and add the following event procedure to the On Load command, but it still does not maximise the form. Are you able to help: DoCmd.Maximize "Allen Browne" wrote: Click the Office Button (top left.) Click Access Options (bottom of dialog.) Click Current Database. Specify a startup form. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi, I now have Microsoft 2007 and just built a form that I would like to open when the database opens. It's been a while since working on these kinds of commans but I have spent about 2 hours reading up on help and searching through the threads to find the answer. I am a little basic on the programming side so if someone could help with step by step that would be so much appreciated :-) Angeline |
#4
|
|||
|
|||
Open form when database opens
Maximize should do it.
Another approach would be to set the properties of the current database to use 'tabbed documents' instead of separate windows. It's in the same area as where you set the startup form. (Access 2007 only.) We are assuming this is not a popup window here. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks so much for the response. Got it working. If you wouldn't mind answering one more thing. I'd like to maximise the form when it opens. I clicked on the Form propertys and add the following event procedure to the On Load command, but it still does not maximise the form. Are you able to help: DoCmd.Maximize |
#5
|
|||
|
|||
Open form when database opens
Hi Allen, thanks for your response (and sorry for my delayed reply) I think I meant to say how do you maximise to full screen so that you can no longer see the tool bars at the top. This form is set in the current database to open when I open the database so not sure how to also get it to maximise (to full screen) as well. "Allen Browne" wrote: Maximize should do it. Another approach would be to set the properties of the current database to use 'tabbed documents' instead of separate windows. It's in the same area as where you set the startup form. (Access 2007 only.) We are assuming this is not a popup window here. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks so much for the response. Got it working. If you wouldn't mind answering one more thing. I'd like to maximise the form when it opens. I clicked on the Form propertys and add the following event procedure to the On Load command, but it still does not maximise the form. Are you able to help: DoCmd.Maximize |
#6
|
|||
|
|||
Open form when database opens
Goodness; there are so many possibilities here.
In A2007, under Office Button | Access Options, you choose between tabbed documents or multilple windows. Tabbed will always be maximized within the Access window. Multiple child windows can be maximized with Maximize (in the form's Load event.) Ctrl+F1 toggles the ribbon on/off if that helps. Alternatively, you can set your form's Popup property to Yes, so it opens outside the Access application window. But I'm not sure Maximize will do what you want if you make that choice. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks for your response (and sorry for my delayed reply) I think I meant to say how do you maximise to full screen so that you can no longer see the tool bars at the top. This form is set in the current database to open when I open the database so not sure how to also get it to maximise (to full screen) as well. "Allen Browne" wrote: Maximize should do it. Another approach would be to set the properties of the current database to use 'tabbed documents' instead of separate windows. It's in the same area as where you set the startup form. (Access 2007 only.) We are assuming this is not a popup window here. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks so much for the response. Got it working. If you wouldn't mind answering one more thing. I'd like to maximise the form when it opens. I clicked on the Form propertys and add the following event procedure to the On Load command, but it still does not maximise the form. Are you able to help: DoCmd.Maximize |
#7
|
|||
|
|||
Open form when database opens
"Allen Browne" wrote: Goodness; there are so many possibilities here. In A2007, under Office Button | Access Options, you choose between tabbed documents or multilple windows. Tabbed will always be maximized within the Access window. Multiple child windows can be maximized with Maximize (in the form's Load event.) Ctrl+F1 toggles the ribbon on/off if that helps. Alternatively, you can set your form's Popup property to Yes, so it opens outside the Access application window. But I'm not sure Maximize will do what you want if you make that choice. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks for your response (and sorry for my delayed reply) I think I meant to say how do you maximise to full screen so that you can no longer see the tool bars at the top. This form is set in the current database to open when I open the database so not sure how to also get it to maximise (to full screen) as well. "Allen Browne" wrote: Maximize should do it. Another approach would be to set the properties of the current database to use 'tabbed documents' instead of separate windows. It's in the same area as where you set the startup form. (Access 2007 only.) We are assuming this is not a popup window here. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Angeline" wrote in message ... Hi Allen, thanks so much for the response. Got it working. If you wouldn't mind answering one more thing. I'd like to maximise the form when it opens. I clicked on the Form propertys and add the following event procedure to the On Load command, but it still does not maximise the form. Are you able to help: DoCmd.Maximize Hello, I too am new to this and don't understand a great deal about it. I've created a Contacts database which is perfect for what I want. When I click on the desktop shortcut I have created, I would like it to open in the contact details from with the form maximized to the full screen. I've read the posts on here but I'm afraid I don't understand them at all. Please would you be able to give me a step by step idea of how to do it? Many thanks, Bunximo. |
Thread Tools | |
Display Modes | |
|
|