Access 2007 Form Popup issue

[JAy3k1]

Good evening all, I'm looking for a little assistance with a database I am making if possible?

It must be 10 years since I last used a DB program so I have been teaching myself access 2007 over the last few weeks. And there is one problem I cannot seem to get over.

The DB I am making is setup as follows:

• Form is set to open up from loading the DB file,
• Access menus are set to minimize,
• Form is set to popup,
• Form is set to full screen display.

This all seems to work wonderfully until the form window has to popup, it seems to stay on the taskbar and for the life of me I cannot get it to popup on start up. I have to click it from the taskbar each time.

The code I am using is as follows in the OnLoad parameter:

DoCmd.RunCommand acCmdAppMinimize
DoCmd.Maximize

I believe this to be correct? If this is not the correct way to do this or there is a better way please do correct me.

Unfortunately I think the issue maybe a DB that is already running on the desktop. The DB that is already running is setup as a switchboard (which is beyond me as yet) and set to be ontop of every other window. But I am hoping that this is not the issue.

And I cannot do anything about how that DB is running as it is a requirement to be setup and ran like this.

So any help given would be greatly appreciated.

 

[vbaInet]

A screenshot of what you're talking about would help.

 

[JAy3k1]

Thank you for the reply vbaInet. I have managed to solve the issue by adding another command to maximize the window. But for some reason I can now right click and gain access to the Design view, which is something I don't want on a multiuser environment.

Is there a way to turn this off? I would post an image but I don't have 10 posts.

Edit: sorry, turning Modal on solved the pop-up issue.

 

[vbaInet]

In the link below, have a look at the File Types section:

http://office.microsoft.com/en-us/a...007-file-format-HA010067831.aspx#BMextensions

I think you can still upload an image even with 1 post count. The only thing you can't do is embed urls or links.

 

[JAy3k1]

The file extension I'm using is: accdb and the other one is: mdb.

ttp://i53.tinypic.com/25uh1z8.jpg

Add the H to that link vbaInet.

 

[vbaInet]

Just blocking the Design View is not the only issue to deal with. If they can get to your code then they can get to the design view of any object. The link I gave you explains the different file types and those that disallows design changes.

Here's more about accde:

http://office.microsoft.com/en-us/access-help/hide-vba-code-from-users-HA010239557.aspx
http://msdn.microsoft.com/en-us/lib...rations_ACCDEFormatSecurityProgrammableObject

Also read about accdr.

For mdb, have a look here:

http://www.databasedev.co.uk/distribute_secure_app.html

 

[JAy3k1]

Ahhh, got you. Thanks for the links vbaInet.

 

[vbaInet]

No probs!

 

[JAy3k1]

VbaInet, I've got to the point all the development is done on my database and have read through the.links you supplied and attempted the splitting of my database, which went fine. I then created a ACCDE file from the original file and that too seemed to work.

But when I test the ACCDE file it opens the database up.in the access design window, and not as a pop-up which is not so great. I'll be honest I don't fully understand what im doing with these files, so it must be something I am doing wrong.

Any ideas? The design window is fully locked down.

ttp://tinypic.com/r/szbii9/7

 

[JAy3k1]

Got it fixed. I just split the database, made a backup and then with the networked version I locked the Shortcuts from within the access settings which stopped all right clicking.