I don't suppose anyone knows a way to get rid of the entire Access 
window, so that a form, with a borderstyle set to none (or anything else 
for that matter) is the only thing that shows up or makes it run 
fullscreen? Or is this one of those things that makes me think "I really 
should have made a VB frontend instead"  ?

Steven

I'm pretty sure you can minimise the Access window and still have a pop-up
or modal form visible....

Anyone?? Bueller??


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Friday, 27 September 2002 5:27 PM
To: Access
Subject: [access] Getting rid of the access window/ running full screen


I don't suppose anyone knows a way to get rid of the entire Access 
window, so that a form, with a borderstyle set to none (or anything else 
for that matter) is the only thing that shows up or makes it run 
fullscreen? Or is this one of those things that makes me think "I really 
should have made a VB frontend instead"  ?

Steven

Steven,

<< I don't suppose anyone knows a way to get rid of the entire Access 
window, so that a form, with a borderstyle set to none (or anything else 
for that matter) is the only thing that shows up or makes it run 
fullscreen? Or is this one of those things that makes me think "I really 
should have made a VB frontend instead"  ? >>

There are several things you can do to come close.  You can convert your 
MDB into an MDE to hide the code.  Then on the MDE you can use TOOLS | 
STARTUP to UNcheck all the checkmarks and get rid of all menus, etc.  
Warning, Will Robinson!  Don't do this unchecking on your MDB file or 
you'll give yourself a big headache!

Greg

Hi Steven,
1) copy this code into a module:

'~~~~~~~~~~~~Start of code to show hide access window~~~~~~~~~~~~~~~~~
Private Declare Function IsWindowVisible Lib "user32" (ByVal hWnd As Long)
As Long
Dim dwReturn As Long
Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3
Private Declare Function ShowWindow Lib "user32" (ByVal hWnd As Long, _
     ByVal nCmdShow As Long) As Long
     
Public Function fAccessWindow(Optional Procedure As String, Optional
SwitchStatus As Boolean, Optional StatusCheck As Boolean) As Boolean
If Procedure = "Hide" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
End If
If Procedure = "Show" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
If Procedure = "Minimize" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMINIMIZED)
End If
If SwitchStatus = True Then
    If IsWindowVisible(hWndAccessApp) = 1 Then
        dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
    Else
        dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
    End If
End If
If StatusCheck = True Then
    If IsWindowVisible(hWndAccessApp) = 0 Then
        fAccessWindow = False
    End If
    If IsWindowVisible(hWndAccessApp) = 1 Then
        fAccessWindow = True
    End If
End If
End Function

'~~~~~~~~~~~~end of code to show hide access window~~~~~~~~~~~~~~~~~

2)create a macro called "autoexec". (this will automaticaly execute when the
DB is opened)
Give it two actions: 
a:run code - in the function name field put-> fAccessWindow
("Hide",false,true) 
b:open form - Your menu form or whatever you want to open first.

3)Make sure all your forms have their Popup property is set to true

Notes:
if you close all your forms the DB will still be running in the background
with no way to close it, so make a button on one of your forms to close the
DB and make it the only way to close the form.

you can bypass the autoexec macro by holding down the shift key when the DB
is opening

The DB is not displayed on the taskbar when it is running or as an
application in the Task Manager, but is showed as a process in the task
manager.

>>>>
>>>>I don't suppose anyone knows a way to get rid of the entire Access 
>>>>window, so that a form, with a borderstyle set to none (or anything else

>>>>for that matter) is the only thing that shows up or makes it run 
>>>>fullscreen? Or is this one of those things that makes me think "I really

>>>>should have made a VB frontend instead"  ?
>>>>
>>>>Steven


**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************

I tried this code before, which is good but only for viewing forms not in reports.
Do you have any idea how to use this in reports?

P.S.
Addition to Item# 3
Make sure all your forms have their Modal property is set to true also.

Cheers,
George




-----Original Message-----
From: NAME REMOVED (Ext. 816) [mailto:EMAIL REMOVED]
Sent: Friday, September 27, 2002 5:36 PM
To: Access
Subject: [access] RE: Getting rid of the access window/ running full
scree n


Hi Steven,
1) copy this code into a module:

'~~~~~~~~~~~~Start of code to show hide access window~~~~~~~~~~~~~~~~~
Private Declare Function IsWindowVisible Lib "user32" (ByVal hWnd As Long)
As Long
Dim dwReturn As Long
Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3
Private Declare Function ShowWindow Lib "user32" (ByVal hWnd As Long, _
     ByVal nCmdShow As Long) As Long
     
Public Function fAccessWindow(Optional Procedure As String, Optional
SwitchStatus As Boolean, Optional StatusCheck As Boolean) As Boolean
If Procedure = "Hide" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
End If
If Procedure = "Show" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
If Procedure = "Minimize" Then
    dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMINIMIZED)
End If
If SwitchStatus = True Then
    If IsWindowVisible(hWndAccessApp) = 1 Then
        dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
    Else
        dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
    End If
End If
If StatusCheck = True Then
    If IsWindowVisible(hWndAccessApp) = 0 Then
        fAccessWindow = False
    End If
    If IsWindowVisible(hWndAccessApp) = 1 Then
        fAccessWindow = True
    End If
End If
End Function

'~~~~~~~~~~~~end of code to show hide access window~~~~~~~~~~~~~~~~~

2)create a macro called "autoexec". (this will automaticaly execute when the
DB is opened)
Give it two actions: 
a:run code - in the function name field put-> fAccessWindow
("Hide",false,true) 
b:open form - Your menu form or whatever you want to open first.

3)Make sure all your forms have their Popup property is set to true

Notes:
if you close all your forms the DB will still be running in the background
with no way to close it, so make a button on one of your forms to close the
DB and make it the only way to close the form.

you can bypass the autoexec macro by holding down the shift key when the DB
is opening

The DB is not displayed on the taskbar when it is running or as an
application in the Task Manager, but is showed as a process in the task
manager.

>>>>
>>>>I don't suppose anyone knows a way to get rid of the entire Access 
>>>>window, so that a form, with a borderstyle set to none (or anything else

>>>>for that matter) is the only thing that shows up or makes it run 
>>>>fullscreen? Or is this one of those things that makes me think "I really

>>>>should have made a VB frontend instead"  ?
>>>>
>>>>Steven


**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************

NAME REMOVED, you are indeed a genius. It works perfectly! It's exactly what I wanted.

Steven

George - I found one way to get that code to work with reports - use 
AccessXP - XP lets you set the popup properties for reports as well.
Unfortunately for me - only 4 (including me) of my 17 users for that 
database actually have XP - all the others have 2000.

> I tried this code before, which is good but only for viewing forms not 
in reports.
Do you have any idea how to use this in reports?

I will try that, but I don't still trust XP to join to my 2K db. Every time I used one of our machine
having XP it used to corrupt
my 2k db.

Thanks for the tips...


Cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Monday, September 30, 2002 4:55 AM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


George - I found one way to get that code to work with reports - use
AccessXP - XP lets you set the popup properties for reports as well.
Unfortunately for me - only 4 (including me) of my 17 users for that
database actually have XP - all the others have 2000.

> I tried this code before, which is good but only for viewing forms not
in reports.
Do you have any idea how to use this in reports?

What you could do is launch all reports from a form, and in the "On Open"
event of the reports unhide the access window and close your popup forms and
in the "On Close" event of the reports hide the access window again and open
your whatever forms you want.

 fAccessWindow ("Show",false,false) -will show the window
 fAccessWindow ("Hide",false,true) -will hide the window

I'm not sure how this would effect performance though.

NAME REMOVED.

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 30 September 2002 05:48
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


I will try that, but I don't still trust XP to join to my 2K db. Every time
I used one of our machine having XP it used to corrupt
my 2k db.

Thanks for the tips...


Cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Monday, September 30, 2002 4:55 AM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


George - I found one way to get that code to work with reports - use
AccessXP - XP lets you set the popup properties for reports as well.
Unfortunately for me - only 4 (including me) of my 17 users for that
database actually have XP - all the others have 2000.

> I tried this code before, which is good but only for viewing forms not
in reports.
Do you have any idea how to use this in reports?




**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************

It doesn't work in 2K.

Cheers,
George


-----Original Message-----
From: NAME REMOVED (Ext. 816) [mailto:EMAIL REMOVED]
Sent: Monday, September 30, 2002 3:26 PM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full s
creen


What you could do is launch all reports from a form, and in the "On Open"
event of the reports unhide the access window and close your popup forms and
in the "On Close" event of the reports hide the access window again and open
your whatever forms you want.

 fAccessWindow ("Show",false,false) -will show the window
 fAccessWindow ("Hide",false,true) -will hide the window

I'm not sure how this would effect performance though.

NAME REMOVED.

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 30 September 2002 05:48
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


I will try that, but I don't still trust XP to join to my 2K db. Every time
I used one of our machine having XP it used to corrupt
my 2k db.

Thanks for the tips...


Cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Monday, September 30, 2002 4:55 AM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


George - I found one way to get that code to work with reports - use
AccessXP - XP lets you set the popup properties for reports as well.
Unfortunately for me - only 4 (including me) of my 17 users for that
database actually have XP - all the others have 2000.

> I tried this code before, which is good but only for viewing forms not
in reports.
Do you have any idea how to use this in reports?




**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************

Which bit doesn't work

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 30 September 2002 15:27
To: Access
Subject: [access] Re: Getting rid of the access window/ running full s
creen


It doesn't work in 2K.

Cheers,
George


-----Original Message-----
From: NAME REMOVED (Ext. 816) [mailto:EMAIL REMOVED]
Sent: Monday, September 30, 2002 3:26 PM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full s
creen


What you could do is launch all reports from a form, and in the "On Open"
event of the reports unhide the access window and close your popup forms and
in the "On Close" event of the reports hide the access window again and open
your whatever forms you want.

 fAccessWindow ("Show",false,false) -will show the window
 fAccessWindow ("Hide",false,true) -will hide the window

I'm not sure how this would effect performance though.

NAME REMOVED.

-----Original Message-----
From: George Oro [mailto:george@c...]
Sent: 30 September 2002 05:48
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


I will try that, but I don't still trust XP to join to my 2K db. Every time
I used one of our machine having XP it used to corrupt
my 2k db.

Thanks for the tips...


Cheers,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Monday, September 30, 2002 4:55 AM
To: Access
Subject: [access] Re: Getting rid of the access window/ running full
screen


George - I found one way to get that code to work with reports - use
AccessXP - XP lets you set the popup properties for reports as well.
Unfortunately for me - only 4 (including me) of my 17 users for that
database actually have XP - all the others have 2000.

> I tried this code before, which is good but only for viewing forms not
in reports.
Do you have any idea how to use this in reports?




**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************