Jasiek’s Blog

Jasiek’s Blog header image 4

Entries Tagged as 'MS Access'

MS Access set application options

June 27th, 2007 · Comments Off · MS Access

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 [...]

[Read more →]

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.

[Read more →]

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
[...]

[Read more →]

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 [...]

[Read more →]

Tags:

Refering to form/subform

April 2nd, 2007 · Comments Off · General, MS Access

http://www.mvps.org/access/forms/frm0031.htm

[Read more →]

Tags: