Create a module (name it as you like) and include a function called Startup
as follows in my sample code:
Option Compare Database
Public Function Startup()
This function changes the startutp options of MS-Access
‘Created by Wally Pons (c) 2004
‘Modified on 11-July-2005 @ 9:08 pm E.S.T.
‘Cuts the confirm question on action queries
Application.SetOption “Confirm Record Changes”, False
Application.SetOption “Confirm Action Queries”, False
‘Hides [...]
Entries Tagged as 'MS Access'
MS Access set application options
June 27th, 2007 · Comments Off · MS Access
Tags:
MS Access Thin Form
May 5th, 2007 · Comments Off · MS Access
Set your border to sizeable, and then flip into view mode.
Now, simply size the form in view mode until you have it just right…
(use a control-s while viewing to save).
Then, flip into design mode,and change the border style to thin, and then
save again. You might consider turning off auto-resize and Set autocenter = yes.
Tags:
MS Access Read HTML into variable
May 1st, 2007 · Comments Off · MS Access
‘Read content of the HTML file into variable
Dim fso As Object, fsoFile As Object
Set fso = CreateObject(”Scripting.FileSystemObject”)
If fso.FileExists(strFileName) Then
[...]
Tags:
Startup, Tool Bars, Menu Bars, Shortcuts, DB Window, etc
April 6th, 2007 · Comments Off · MS Access
In the application’s startup options (Tools-Startup) under Display Form enter the name of the form you want the user to see when the application loads.
In that form’s OnOpen event put =SetStartupOptions()
Also in the startup options uncheck the “Display Database Window.” (You can also do this from code and I have that if you [...]
Tags:
Refering to form/subform
April 2nd, 2007 · Comments Off · General, MS Access
http://www.mvps.org/access/forms/frm0031.htm
Tags: