Solved

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

Posted on 2012-03-15
10
294 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 84 total points
ID: 37725593
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 167 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 167 total points
ID: 37726372
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 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 83 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 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

832 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