Two (Hopefully Simple) Access Questions

[markmcgookin]

Hi Folks, Happy new year to all!

I have two questions here, which I hope will be relatively simple you you guys to answer!

1) Is it possible to stick a line or two of code in a form somewhere so that it is always maximised? I have created a form on a machine, but then when I run it in other machines with different resolutions the size goes iffy.

I found this

Global FormHeight
Global FormWidth
 
 
In the Forms load event insert the lines
 
Formheight = me.height
formwidth = me.width
 

Here http://www.thescripts.com/forum/thread555175.html But I don't know if it's what I'm looking for, should that be at the top of every form? (I only have about 10 forms, so if i need to put that into each one it won't be a problem!)

2) My system is relatively simple, in that if a user closes the login form it wipes a temp value that will essentially log them out, this is not a problem as I am only using a prototype here. However, I want to create a "log-out" button which will simply close all the open forms and then open my login form (frmLogin) leaving the system all nice and ready for the next poor soul to test it out :D

I have played with macros, but the only ones in access seem to just close the existing form. A worst case scenario would be a form-specific log-out button, where I could code in some thing like,

close frm1
close frm2

and then for another form have a button that looks the same going

close frm3
close frm4
close frm5 etc etc.

I just wondered if there was a closeallforms() I could bind to a button?

Some help would really be appreciated!

Cheers folks!

Mark

[NeoPa]

You're keeping me busy tonight Mark.
1.

DoCmd.Maximise

will do you for the maximising of the forms. I often have it in the OnOpen event procedure.
2. There is no global close forms command (that I'm aware of). You can write some code though, to cycle through the open forms and close them.

Dim frmThis As Form
 
For Each frmThis In Forms
    Call frmThis.Close
Next frmThis

[markmcgookin]

You're keeping me busy tonight Mark.
1.

DoCmd.Maximise

will do you for the maximising of the forms. I often have it in the OnOpen event procedure.
2. There is no global close forms command (that I'm aware of). You can write some code though, to cycle through the open forms and close them.

Dim frmThis As Form
 
For Each frmThis In Forms
    Call frmThis.Close
Next frmThis

Once again I must bow my head and thank you! I really wish there is something I could help you with! haha. But other that web authoring and some SSL theres not much. (Unless you want me to talk you through completing Gears of War in about 6 hours :D )

[NeoPa]

'Gears of War' - Sounds like a game :)
Do u use TS or Vent?

[markmcgookin]

'Gears of War' - Sounds like a game :)
Do u use TS or Vent?

Hehe, yeah great game. Our server for CS has TeamSpeak on it.

I meant to add, an easier way to get the window maximising is to create a line in the autoexec macro in access with "Maximise" in it. Works a treat!

[NeoPa]

Mark,
That's true but I don't think anyone here would ever recommend doing anything with Access Macros. I just pretend they don't exist - fewer problems that way ;)
Good to know you have TS - may prove useful in future (possibly) as you live in UK.
-Adrian.