Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

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

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
SeyerIT
Asked:
SeyerIT
  • 3
  • 2
  • 2
  • +2
6 Solutions
 
Rey Obrero (Capricorn1)Commented:
0
 
Jeffrey CoachmanCommented:
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
 
SeyerITAuthor Commented:
Thanks you two.. Let me browse through these.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Jeffrey CoachmanCommented:
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
 
WiesjeCommented:
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
 
WiesjeCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
SeyerITAuthor Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now