473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Hiding access in the background, but still displaying reports and results of queries in a "front end"

BA
Hi there
I am trying to write an "application" in Access 2000, that displays a front
end and allows the user to interact with the database without seeing Access
loaded, in the background, nor on the taskbar.

When I click on the generate report button, from the front-end's form, no
report/query is displayed. However, if i disable the code that "hides"
Access, the reports and queries work perfectly.

How do I get this functionality working together?
Is it possible?

The code I used to hide Access is :
const SW_HIDE = 0
private declare function ShowWindow Lib " users32" (byval hwnd as long,
byval ncmdshow as long) as long

[In the switchboards open form event the follow exists.]
dim hwindow as long
dim nresult as long
dim ncmdshow as long

hwindows=application.hwndaccessapp
ncmdshow=SW_HIDE
nresult = showwindow (byval hwindow,byval ncmdshow)
Your help is sincerely appreciated
BA
Mar 27 '07 #1
5 3180
On Mar 27, 6:38 am, "BA" <bara...@ateam.comwrote:
Hi there
I am trying to write an "application" in Access 2000, that displays a front
end and allows the user to interact with the database without seeing Access
loaded, in the background, nor on the taskbar.

When I click on the generate report button, from the front-end's form, no
report/query is displayed. However, if i disable the code that "hides"
Access, the reports and queries work perfectly.

How do I get this functionality working together?
Is it possible?

The code I used to hide Access is :
const SW_HIDE = 0
private declare function ShowWindow Lib " users32" (byval hwnd as long,
byval ncmdshow as long) as long

[In the switchboards open form event the follow exists.]
dim hwindow as long
dim nresult as long
dim ncmdshow as long

hwindows=application.hwndaccessapp
ncmdshow=SW_HIDE
nresult = showwindow (byval hwindow,byval ncmdshow)

Your help is sincerely appreciated
BA
not sure what you mean with "hiding Access"
do you mean the database window and menus?
look at startup options under tools menu
there was a way in A97 to mimic runtime environment in the command
line for starting your ap...not sure what it is again
look at the "runtime environment" topic in help and the google groups
hope it helps

Mar 27 '07 #2
BA
Thank you for your reply.
I want to not only hide the database menus, but also the fact that Access is
open. Ideally I wouldn't want it in the background, or with an icon on the
bar, however I would still like the app to work and maintain full
functionality.

I can hide Access with the code, however I can not generate reports then.
Plus making the forms modal result in a report appearing behind the form and
can not be accessed.

<lg********@gmail.comwrote in message
news:11**********************@p15g2000hsd.googlegr oups.com...
On Mar 27, 6:38 am, "BA" <bara...@ateam.comwrote:
>Hi there
I am trying to write an "application" in Access 2000, that displays a
front
end and allows the user to interact with the database without seeing
Access
loaded, in the background, nor on the taskbar.

When I click on the generate report button, from the front-end's form, no
report/query is displayed. However, if i disable the code that "hides"
Access, the reports and queries work perfectly.

How do I get this functionality working together?
Is it possible?

The code I used to hide Access is :
const SW_HIDE = 0
private declare function ShowWindow Lib " users32" (byval hwnd as long,
byval ncmdshow as long) as long

[In the switchboards open form event the follow exists.]
dim hwindow as long
dim nresult as long
dim ncmdshow as long

hwindows=application.hwndaccessapp
ncmdshow=SW_HIDE
nresult = showwindow (byval hwindow,byval ncmdshow)

Your help is sincerely appreciated
BA

not sure what you mean with "hiding Access"
do you mean the database window and menus?
look at startup options under tools menu
there was a way in A97 to mimic runtime environment in the command
line for starting your ap...not sure what it is again
look at the "runtime environment" topic in help and the google groups
hope it helps

Mar 27 '07 #3
BA wrote:
Thank you for your reply.
I want to not only hide the database menus, but also the fact that
Access is open. Ideally I wouldn't want it in the background, or with
an icon on the bar, however I would still like the app to work and
maintain full functionality.

I can hide Access with the code, however I can not generate reports
then. Plus making the forms modal result in a report appearing behind
the form and can not be accessed.
To what end? The functionality you are using is really only apropriate for
very simple utility apps that have only a few forms. Using it in a
full-featured app just doesn't make sense.

If your goal is to make your app look like it was not made using Access then
I would suggest you use something other than Access to develop it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 27 '07 #4
"BA" <ba*****@ateam.comwrote in
news:eu*********@wblv-ip-nnrp-1.saix.net:
Thank you for your reply.
I want to not only hide the database menus, but also the fact that
Access is open. Ideally I wouldn't want it in the background, or with
an icon on the bar, however I would still like the app to work and
maintain full functionality.
Maybe Dolly Parton could help. I know that she has this trick mastered when
she comes on stage weaing a 32-A bra.
--
lyle fairfield

Ceterum censeo Redmond esse delendam.
Mar 27 '07 #5
I used to write these types of MS-access applications a long time ago
(Win '95 and Access '97 according to my notes).

One thing that the notes hammered on was that the 'Popup' property had
to be set in every form and report, or it wouldn't display (which fits
your symptoms). Does your report have the 'Popup' Property set to
'Yes'?


On Mar 27, 6:38 am, "BA" <bara...@ateam.comwrote:
Hi there
I am trying to write an "application" in Access 2000, that displays a front
end and allows the user to interact with the database without seeing Access
loaded, in the background, nor on the taskbar.
<SNIP>
Mar 27 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Douglas Collie | last post by:
Is there a bug using an untyped memory based data set? I have a form with a tab control, on one tab is a data grid linked to a dataset which I add data to at regular intervals. I have a second...
2
by: JohnR | last post by:
Wow, this is unbelieveable. I've narrowed it down to a few lines of code. Create a new project in VB.NET and put 2 buttons on it (a FBD button and an EXIT button) and enter these lines for the...
13
by: Simon Wigzell | last post by:
Can I trap when the scroll is ended? This is what I want - the calculator disapears when the site visitor starts scrolling the main page. I'm doing that with an "onScroll()" function. I'm bringing...
1
by: Najm Hashmi | last post by:
Hi all , I am trying to create a store procedure and I get the following error: SQL0104N An unexpected token "END-OF-STATEMENT" was found following "END". Expected tokens may include: "JOIN...
3
by: Summit | last post by:
Does anyone know what the C# equivalent for VB6 End is? I'm starting up a form with a boolean test. If I fail, I just want to end the app. Even though I close the form, it picks up on the line...
0
by: Tom Bower | last post by:
In the Windows Task Manager if I select a Process and right-click, I can choose to "End Process" or "End Process Tree." Is there a VB equivalent for "End Process Tree" if you have a handle to a...
4
by: Alex Maghen | last post by:
Does a call to Response.Redirect result in an immediate exit from the current page function (i.e. a "return()")? I want to make sure that the statements after the Response.Redirect() do not get...
28
by: kaleolani65 | last post by:
I have been having an ongoing problem with a DB at work concerning people getting "locked out". Access warnings relating to "exclusive" mode The research I have done and the replies received...
2
by: jahanas | last post by:
Private Sub txtBox1.txtLife_Enter(ByVal frmQuote) Handles txtLife Me.txtQuote.Text = "I like life, it's something to do." End Sub Private Sub txtBox2.txtFuture_Enter(ByVal...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.