We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Northwind 7.0 startup screen

kulikuli
kulikuli asked
on
Medium Priority
471 Views
Last Modified: 2012-05-04
Can anyone tell me how I can create a property like there is in the Northwind database sample of Access 7.0 that lets appear a startup screen? There is no autoexec used..... I think I can learn something completely new on this....
I would like to be able to create such a property and would like to know if it is possible to create methods on the database too.

Thank you very much in advance,

Kulikuli
Comment
Watch Question

Victor SpiridonovDatabase Director

Commented:
If you go into Tools-> Startup, you will differrent 'things' you can do at startup. One of them is 'Display Form'. Other options are also quite usefull. You can hide database window, change APP title,icon etc.

Author

Commented:
Can you tell me how to set this property in code? And how to create methods to the db object?
Victor SpiridonovDatabase Director

Commented:
I doubt, that you can set this in code. Have a look at Application object properties.

Commented:
This is explained in detail in the Solutions database that comes with Access - Look under Work with Forms and Controls, then Create a startup form.

It uses the Timer property to display the splash screen for a certain amount of time.

Good luck
CEkman

Author

Commented:
Sorry cekman, I think I need to be more specific:
-I want to create a property that holds the value of a password
-I want to create a method that minimizes the application/database

Commented:
Do you mean the screen that allows you to check the box so that screen doesn't appear again? If so - that is also described in detail in the Solutions.mdb. If not - exactly what startup screen are you talking about? When I open Northwind - I go directly to the main switchboard.

Also - what do you mean by 'minimizing' the application? Do you mean the database window?

There is nothing special about how the main switchboard is displayed in Northwind. Open Northwind - go to TOOLS on the menu, then Startup - the main switchboard is defined as the Display form property. There is nothing in the Northwind DB that looks at passwords.

Please clarify and I'll try again
Thanks
CEkman

Author

Commented:
By minimizing the 'application' I mean the whole MS Access environment.
I know there is nothing to store passwords in by default. That's why I want to create it by creating the property. I would like to append a custom property to the database.
Any comments/suggestions are more than welcome.

Commented:
I'll have to pass on this one. I guess I'm not understanding what you want. Your original question stated that you want to do a startup form - like Northwind. That has been answered. I'll let another expert give this one a try.

Good luck
CEkman

Author

Commented:
Cekman,
I mean the window, that generally has 'MS Access' in its header. That's what I like to minimize. If you open Access then at its right upper corner there is a minimizer(underscore). If you click it that is exactly the action I want to perform.

Furthermore if you open your databasewindow and right click on it then you are able to choose 'database properties'. I'd like to append(add) one to that list.


Victor SpiridonovDatabase Director

Commented:

>I'll let another expert give this one a try.
Cekman, so do I.

Kulikuli, I agree with cekman, your initial question has been answered, if you want to ask another question ,post it separately.

Author

Commented:
I repeat my same old question:How can I CREATE a property on the database and how can I CREATE a method on the database. None of these questions haven't been answered yet!! I did not ask for some menu item.
Try Database Properties under help. If I understand you right you are trying to create a new property for the database object.There is a good example of how to do this in help


Author

Commented:
Thank you very much, Helicopter. I am now able to create a property  and append it to the database. Can you please tell me how I can create a method to for the database. For example a method that opens a form when the user exits the application by clicking the cross at the right upper corner of MS Access.
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I think I'll do it that way then... but there has to be a better way finally...

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.