I am looking for VBA code to make a form opening at fixed position every time.
Can someone help me?
In VB6 or VB.NET, this is very easy but for Access no.
I am looking for VBA code to make a form opening at fixed position every time.
Can someone help me?
In VB6 or VB.NET, this is very easy but for Access no.
Maybe this will help: http://www.baldyweb.com/Bookmark.htm
This is a different issue.
Maybe if you described your issue in more detail we could give more accurate suggestions.
When you say "opening at fixed position' are you referring to the actual position of the Form vis-à-vis the screen, as in 'upper/center of screen' or 'bottom/right side of screen?'
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
For example, center
aspfun,
You are a person of few words. Could you please give us a 2 sentence description of exactly the issue you are trying to solve?
We're trying to help, but you have to participate.
Sorry about it.
For example, to open a form, I want it stay in the center of screen and do not display full screen.
Since property of form do not have this feature.
I try to set "Auto Center = Yes" but have to resize form each time.
I need a code to make all forms open at fixed size: Width =80% width of screen, Height=70% of height of screen and stay at center of screen.
I found this using Google. It may help, if not try Google or Bing.
If any form displays full screen then *all* forms will display full screen since it is a system wide variable. Are you still using ac2003?
yes, ac2003
Forms should remain the size and location where you put them while in Design mode if you save the form. Do any of your other forms put the form in FullScreen mode? (DoCmd.Maximize)
AutoCenter only centers Horizontally, and actually interferes if you try to manually position a Form, which is the only reliable way to center a Form, on both axies, that I’ve found, without using MoveSize. I tried MoveSize in the past, but found it to be more trouble than it was worth; of course, that’s just me! This method has worked for me for years:
- Set AutoCenter to No
- Set AutoResize to No
- Size and Move the Form to desired position
- Click on Save
- Close Form without doing anything else!
You might have to tweak this a little, by repeating Steps 1-5, to get it to the exact, desired position.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007