default form in a MDE file

[Bruno Alexandre]

Hi guys,

I was able to design and build a application to create restaurant menus,
and, to save my work I want to convert it to a MDE file.

To here, I can do it

But, after I have my MDE file, I open it and it goes to the Forms List
Object and I want to open a Form immediately and hide the objects list
(I also know that the user will have access to the Database contents if
he/she open the database pressing the SHIFT key while the file opens), but I
just want to have the MDE file opening a default Form.

How can I do this?

I'm using Microsoft Office 2003 Professional

--


Bruno Miguel Alexandre
Dep Informática do Grupo Filtrarte

Av General Humberto Delgado, 91
Vila Verde
2705-887 Terrugem SNT
Portugal

T. +351 219 608 130
F. +351 219 615 369
w. www.filtrarte.com
@. (e-mail address removed)

 

[Jeff Conrad]

Hi Bruno,

I was able to design and build a application to create restaurant menus,

Do you mind if I ask some general things on what the database does?
We're in food service so this sparked my interest.
Are you building a list of ingredients to price out entrees?
What else does it do?

and, to save my work I want to convert it to a MDE file.

To here, I can do it

Good, make sure you keep back-up copies (several) of the original MDB files.
Make sure your code compiles with no errors as well.

But, after I have my MDE file, I open it and it goes to the Forms List
Object and I want to open a Form immediately and hide the objects list

That's easy to change.
Go to Tools--Startup.
You'll see a list that says "Display Form".
Select the form from the list you want to see when the database opens.
Now that form will always show when the database opens.
In addition, you can also hide the database window, as well as set many
other options you don't want your users to have access to.

(I also know that the user will have access to the Database contents if
he/she open the database pressing the SHIFT key while the file opens), but I
just want to have the MDE file opening a default Form.

You can disable this as well so the users cannot bypass your start-up stuff
by holding down the Shift key. Follow this link for directions on how to do
this:

http://www.mvps.org/access/general/gen0040.htm

You may also want to download MVP Albert Kallal's nifty shift key bypass
database that you can use to do this with just a few mouse clicks:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

Look for the download that says "By Pass Shift Key Code"

Hope that helps,
Jeff Conrad
Bend, Oregon

 

[Bruno Alexandre]

Hi Jeff,

Just a simple issue I had in that cafe/restaurant.
Then sell take away food, and they always do 2 Diary menus for the Diary
Food and the Diary Take Away food (and they have Desert and Wines Menus as
well). And they had a old pc with Word 97 that they open the document and
change it and print the new Menu (always with a bad style)... the Mr who did
it is my father in law (the owner)
And they have two Screen Touch PC's holding the Restaurant Application
(tables, etc), so I wanted to build an application to create those Menus and
print it nicely and easy.
so, I ask for all the food by categories, and then I build the menu to
print, and I do that for the Take Away food as well, cause in the Diary
Dishes they have full dish and half, (so 2 prices) and for take away the
prize is about the weight (Euros by Kilo) the food have.

if you want I can send you the MDB file (in Portuguese)


About the Startup... Done! Thank you
About the Shift Key... I will do this later, but thank you.

--


Bruno Miguel Alexandre
Dep Informática do Grupo Filtrarte

Av General Humberto Delgado, 91
Vila Verde
2705-887 Terrugem SNT
Portugal

T. +351 219 608 130
F. +351 219 615 369
w. www.filtrarte.com
@. (e-mail address removed)

 

[Jeff Conrad]

Hi Bruno,

Just a simple issue I had in that cafe/restaurant.
Then sell take away food, and they always do 2 Diary menus for the Diary
Food and the Diary Take Away food (and they have Desert and Wines Menus as
well). And they had a old pc with Word 97 that they open the document and
change it and print the new Menu (always with a bad style)... the Mr who did
it is my father in law (the owner)
And they have two Screen Touch PC's holding the Restaurant Application
(tables, etc), so I wanted to build an application to create those Menus and
print it nicely and easy.
so, I ask for all the food by categories, and then I build the menu to
print, and I do that for the Take Away food as well, cause in the Diary
Dishes they have full dish and half, (so 2 prices) and for take away the
prize is about the weight (Euros by Kilo) the food have.

if you want I can send you the MDB file (in Portuguese)

Well that's very kind.
I wouldn't mind seeing it.
Certainly won't be able to make heads or tails of the code, but it sounds
interesting!

You can send the file here if you'd like:
administrator
at
ernstbros
dot
com

Please put the word "Access" in the subject line at least five times if you
don't mind. This is a "dump" e-mail account for our office and therefore
gets hundreds of junk e-mails daily. Having Access in the Subject a bunch of
times will help me spot it.

About the Startup... Done! Thank you
Good.

About the Shift Key... I will do this later, but thank you.

Using Albert's file it should be easy.
Again, make back-up copies first!

Thanks again for the sample,
Jeff Conrad
Bend, Oregon