- Hubs »
- tagged ms access vba
1-10 of 23 Hubssort by Hot Best Latest
70MS Access: Where is a field used?
Microsoft Access: VBA Programming Code Provided by Allen Browne, April 2007 Where is a field used? The code below lets you search for where a field name is used - in any tables, queries, forms, or reports. (This is a work in progress) ...
1 comment68Bind MS Access forms to ADO recordsets
This article was previously published under Q281998Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies to a Microsoft Access database (.mdb) and to a ...
1 comment66String Functions Library for MS Access
'* String Functions'*'* See the subroutine "examples" to test the supplied functions.Option Compare DatabaseOption ExplicitSub example_of_parsing()'* This is an example of how to parse a sentence into...
0 comments67MS Access Format Function
In Access, the Format function takes an expression and returns it as a formatted string. The syntax for the Format function is: Format ( expression, [ format ] ) expression is the value to format. ...
2 comments62Use DSN-Less Connection (MS Access / SQL SERVER)
You can open a connection to a database without creating or specifying a named data source. Connections made in this way are called "DSN-less", because they don't require the system administrator to create...
0 comments63ShellExecute in MS Access
Const SW_SHOW = 1 Const SW_SHOWMAXIMIZED = 3 Public Declare Function ShellExecute Lib "Shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal lpParameters As String, _ ...
1 comment69Iterate through controls for MS Access Forms
Private Sub Form_Load() For Each ctl In Me.Controls If ctl.ControlType = acLabel Then On Error Resume Next ctl.Caption = DLookup("LABEL_USER_COURT", "MAPPING_TABLE",...
0 comments67TypeName Function (MS Access)
Returns a String that provides information about a variable (variable: A named storage location capable of containing data that can be modified during program execution. Each variable has a name that uniquely...
0 comments71CurrentDb Method (MS Access)
According to this article from Microsoft, CurrentDB should be used instead of DBEngine.Workspaces(0).Databases(0). But we encountered some cases where CurrentDB is really slow so that DBEngine.Workspaces(0).Databases(0) was used to solve the problem.
0 comments67How to Programmatically Change a Control Type for MS Access Form
This article shows you how to programmatically change a control on a form from one type to another. By using the ControlType property in a Visual Basic for Applications procedure, you can change a text box...
0 comments
