Hey everyone, Probably a simple question but how do I make a form that is non sizable and is roughlt the size of a business card?
Hey everyone, Probably a simple question but how do I make a form that is non sizable and is roughlt the size of a business card?
Try setting the border style of the form to Dialog and sizing it in design view to the size you want. In 2007, you'd need to make sure you're not in the tabbed view, where each form appears on a tab.
Still no good, Just not sure what I am doing wrong. I am a beginner with Access, but have performed this before with success, just not recently.
Are you showing forms in tabs?
Office Button/Access Options/Current Database/Document Window Options
You want Overlapping Windows.
Hello, Wow do I feel like a total idiot. Thanks so much for the help.
No problem. Those options aren't exactly out in plain sight.
Not sure if I'm doing the right thing by replying to a closed thread but I just wanted to thank pbaldy for his reply which almost solved my very similar problem.
Is there anyway of setting this as a global preference?P
Please advise if I need to start a new thread or send a private message etc.
Thanks also to mikesevo for asking.
Thank you very much pbaldy
Access Options/Current Database/Document Window Options/Overlapping Windows.
I was looking for this answer
Happy to help! To my knowledge there's no way to make that a default setting. If you find a way, post back here because I'd love to change mine too.
In Access 2007 and later, you can also create a default database, with the properties, objects, and configuration you want whenever you create a new (blank) database.
Click the Office Button, and click New. Enter this file name:
C:\Program Files\Microsoft Office\Templates\1033\Access\blank
and click Create. The name and location of the database are important.
If you installed Office to a different folder, locate the Templates on your computer.
To set the database properties, click the Office Button and choose Access Options.
On the Current Database tab of the dialog, uncheck the Name AutoCorrect options to prevent these bugs.
On the Object Designers tab, uncheck Enable design changes for tables in Datasheet view to prevent users modifying your schema.
Set other preferences (such as tabbed documents or overlapping windows, and showing the Search box in the Nav Pane.)
After setting the options, set the references you want for your new databases.
Open the code window (Alt+F11) and choose References on the Tools menu.
Import any objects you always want in a new database, such as:
the default form and report above,
modules containing your commonly used functions,
tables where you store configuration data,
your splash screen, or other commonly used forms.
To import, click the External Data tab on the ribbon, then the Import Access Database icon on the Import group.
Now any new database you create will have these objects included, properties set, and references selected.
You can create default databases for both the new file format (accdb) and the old format (mdb) by creating both a blank.accdb and a blank.mdb in the Access templates folder.
Found it on Allen Browne http://allenbrowne.com/ser-43.html, not sure if it works though.
EDIT: Just tried this and it worked for me. Any default options you use for a new database can be set this way. Woo hoo
~Matt
Thank you subwind. I presume this is something akin to the word Normal.dot.
Looks a bit beyond my current scope but will give it a whirl when I've finished tinkering with my first db.
Thanks again.