?
Solved

Can a user level version of access be run without the backround application displayed?

Posted on 2012-03-15
10
Medium Priority
?
303 Views
Last Modified: 2012-03-16
Anyone know if it is possible to only display a form when the access program is launched without displaying the entire Access App?

In other words, hide the part of the application highlighted in red in this screen shot;
sh
0
Comment
Question by:SeyerIT
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 336 total points
ID: 37725593
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 668 total points
ID: 37725772
See here too:
http://access.mvps.org/access/api/api0019.htm

There was a thread a while ago where it was explained how to "Dim" the background, ...I'll try to look that up tonight.
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 37725863
Thanks you two.. Let me browse through these.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 668 total points
ID: 37726372
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 664 total points
ID: 37726478
It's not possible to hide the Access window, but you can set your Form to run as a popup the same size as the Access window (which is what the code suggested by others does). This will work to some degree - the user won't be able to see the Access window - but it comes with quite a few "gotchas".

For example, if the host program throws an error it could very well end up behind your giant popup form. The user couldn't get to it (since it's modal, and they can't move the popup form to get to it), so your app will be hung. Proper error handling is absolutely critical (and no more macros, period).

Also, this means that ALL of your forms must be set to popup. This may or may not work for you.

Also, your program must then be managed in a "linear" fashion, which detracts from one of the nice features of a Windows based program (the ability to switch back and forth easily between windows, and to have two windows side-by-side).

Those are just a few. If your do a search on the same topic, you'll inevitably see much more.

As I've said time and again - if you don't want the user to know this was done in Access, then don't do it in Access.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37726690
Thanks LSM

...sometimes we forget to mention the "gotchas"

Stuff like this always seems "slick", but for the reasons you listed, (for me at least) it was just never worth all the hassle

I'll wit for Access to support this directly...

;-)

Jeff
0
 
LVL 8

Expert Comment

by:Wiesje
ID: 37726875
There is another solution - you can actually create an Access executable (if I remember rightly). You only need the access runtime on the computer to be able to run it... and otherwise you do not see the Access background at all.

I will investigate this right now - and let you know how you go about this!!
0
 
LVL 8

Assisted Solution

by:Wiesje
Wiesje earned 332 total points
ID: 37726898
Ok, I may have remembered wrongly. The only suggestions I see is using a RunTime version of Access instead of the full - but that doesnt solve your issue of hiding the background - as this you can still see.

The nicest solution I have found though - is using a VB or C# or other programming language front end - and only using the access database. Which means you can have a front end completely free of the access database. (And thus, hides all that).
See: http://www.access-programmers.co.uk/forums/showthread.php?t=153686 the esb1922 suggestion.

It's not as simple as the solutions suggested above - but it would work!

Hopefully you did not get your hopes up to high with an executable version - I must be remembering it wrong... sorry about that.
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 664 total points
ID: 37728647
There is no way to create an Access executable. Period. Full Stop. There are ways to kludge around it - create a "loader" program, etc etc - but all those do is implement the same sort of mechanism as described above (open the forms in Popup mode, and size them to hide the database window).

The Runtime version of Access is basically nothing more that the full version without the design-time capabilities. You still must "run" it to open your Access database, unlike other languages which rely on frameworks and such to generate the interface.
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 37728912
Thanks for all your help guys! I wasn't necessarily trying to make the program seem as though it didnt run in access.. I just made a simple widget that was rather small in window size that runs stand alone.. It's the entire program. So when it launched it also launched the backround window which took up the entire screen.. No biggie, I was just curious.

Thanks again for all your help!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question