running forms on desktop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Smith - 25 Jul 2007 13:59 GMT

hi all, i couldn't find an answer to this one, and i was hoping to run a
small phone no. database on my desktop, that is, without the Access Program
window in the background. So my 2 small forms would appear on the desktop
itself. i have Access 2003 and WinXp Sp2

thanks in advance

Dave

Reply to this Message

Douglas J. Steele - 25 Jul 2007 14:10 GMT

See whether what's presented in http://www.mvps.org/access/api/api0019.htm
at "The Access Web" does what you want.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hi all, i couldn't find an answer to this one, and i was hoping to run a
> small phone no. database on my desktop, that is, without the Access
[quoted text clipped - 4 lines]
>
> Dave

Reply to this Message

Dave Smith - 26 Jul 2007 12:59 GMT

hmm if i read it right i am to put this code in the 'On Open' event in the
properties box of my form? if so i cant seem to get it to work at all, i get
error messages saying only comments are allowed after the 'end function'
command, although there is nothing after the 'end function' command. i tried
removing the green text above and below the actual code, but no different.
hope im just doing something wrong?

thanks

> See whether what's presented in http://www.mvps.org/access/api/api0019.htm
> at "The Access Web" does what you want.
[quoted text clipped - 7 lines]
>>
>> Dave

Reply to this Message

Douglas J. Steele - 26 Jul 2007 13:51 GMT

No, you don't put the code into an event's Property box.

Create a new module (not a class module, nor a module associated with a
form), copy everything between "Code Start" and "Code End" from that page
and paste it into the module, then save the module. Make sure the name of
the module is something different than the name of any routines contained
within the module. Use "mdlSetWindow" to be certain (unless you've already
got a module with that name!)

You could simply set the Open property for the form to
=fSetAccessWindow(SW_HIDE), but I'd recommend setting it to Event Procedure,
and using VBA to call the function so that you can trap any errors that
might occur:

Private Sub Form_Open()
On Error GoTo Err_Form_Open

Call fSetAccessWindow(SW_HIDE)

End_Form_Open:
Exit Sub

Err_Form_Open:
MsgBox Err.Number & ": " & Err.Description
Resume End_Form_Open

End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hmm if i read it right i am to put this code in the 'On Open' event in the
> properties box of my form? if so i cant seem to get it to work at all, i
[quoted text clipped - 17 lines]
>>>
>>> Dave

Reply to this Message

Dave Smith - 27 Jul 2007 13:48 GMT

ok, you have been really patient and i appreciate that :P, i did as you said
and it is trying to work. when i open my form, initially i got "cannot hide
Access UNLESS a form is on screen" so i made a switchboard and then i got
"Cannot hide Access with switchboard on screen", so i made a form with a
button that opens my "starting" form (the one with your code in the On Open
property) and then i get "Cannot hide Access WITH form on screen"

so i seem to be stuck...

thanks again...

Dave

> No, you don't put the code into an event's Property box.
>
[quoted text clipped - 45 lines]
>>>>
>>>> Dave

Reply to this Message

Douglas J. Steele - 27 Jul 2007 14:26 GMT

Did you set the form's Popup property to True, like the article states is
required?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> ok, you have been really patient and i appreciate that :P, i did as you
> said and it is trying to work. when i open my form, initially i got
[quoted text clipped - 58 lines]
>>>>>
>>>>> Dave

Reply to this Message