1-10 of 57 Hubssort by Hot Best Latest
77Set Table Column Descriptions in MS Access VBA
Public Function SetTableColumnDescriptions(sTable As String) As Boolean On Error Resume Next Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim prp As...
2 comments
76Free Visual Basic / in VB / in SQL / MS Access Computer Programming Code Examples I of II ( Learn / Do )
These are code fragments from business applications that I have written over the years. ... SQL... record set processing...data manipulation (field and character level)... GUI routines.
3 comments
74C# program that interface with MS Access: Conduct a simple SEARCH operation on an Access database file
1. Open a new Visual C# .NET windows application. Name the project “Search Data”. 2. Design a form. Add two Textboxes, a Button and a Picturebox. 3. Set Name property...
0 comments72MS 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 comments
88Overview of Microsoft Access
A very brief discussion on Microsoft Access and what it can be used for.
8 comments69Stored Procedure in MS Access
Unlike other objects in Access, stored procedures have no interface and cannot be created or run through the Access User Interface. The way to get them into your database is to simply code them. When a stored procedure is added to an Access...
2 comments
83Free Visual Basic / in VB / in SQL / MS Access Computer Programming Code Examples II of II (Learn / Do)
...code fragments ... business applications ... written over the years. ... SQL... record set processing...data manipulation (field and character level)... GUI routines.
0 comments71Iterate 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 comments72CurrentDb 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 comments69MS Access Conditional Formatting
Public Function HighLightForeignKeys(argFieldName As String, _ ArgFieldValue As Integer) Dim FormatCondition As String Dim CodeReception As Integer CodeReception = ArgCodeReception 'FormatCondition =...
1 comment
