1-10 of 64 hubssort by Hot Best Latest
83Overview of Microsoft Access
Before you go out and plunk down some serious dollars (or euros our pounds) on lengthy and involved Microsoft Access courses, it might be a good idea to know what it is and how it's used. That is the focus of...
2 comments
82C# program that interfaces with MS Access: Store data (text, image) in an Access database file
1. Open a new Visual C# .NET windows application. Name the project CreateDatabase. 2. Design a form. Add three Textboxes and two Buttons 3. Set Name property of Textboxes...
1 comment
75Free ms access tutorial for beginners
Microsoft Access is a window based relational database application that can run on a window based operating system like Windows xp. For one to understand ms access, one should have knowledge of window as...
0 comments
72Seven Deadly SQL Sins Part I
This is the first in a series of four excerpts from my live SQL presentation of the same title that I have given to technical groups in my area. It is inspired by an excellent outline by Arjen Lentz...
5 comments
72MS ACCESS IN SELECT
SELECT PK FROM T1 INNER JOIN T2 ON T1.PK = T2.FK WHERE (((PK) In (SELECT * FROM T_LIST))); CP1500 Tutorial Solution - Using Microsoft Access
0 comments69Set 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 DAO.Property ...
0 comments69C# program that interface with MS Access: Modify data in an Access database file
1. Open a new Visual C# .NET windows application. Name the project “Modify Data”. 2. Design a form. Add two Textboxes, a Button and a Picturebox. 3. Set Name property...
0 comments68MS 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. format...
1 comment68MS Access Conditional Formatting
Public Function HighLightForeignKeys(argFieldName As String, _ ArgFieldValue As Integer) Dim FormatCondition As String Dim CodeReception As Integer CodeReception = ArgCodeReception 'FormatCondition =...
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 comments
