1-10 of 64 hubssort by Hot Best Latest
73Seven 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...
3 comments
70MS 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 comments68String 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 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, _ ...
0 comments69MS 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 comment
68C# program that interfaces with MS Access: Open an existing Access database file
1. Open a new Visual C# .NET windows application. Name the project OpentDatabase. 2. Design a form. Add a Textbox and a Button 3. Set Name property of Textbox to “txtdatabaseName”....
0 comments
67Seven Deadly SQL Sins Part II
.... continued from part one This is the second in a series of four excerpts from the MySQL presentation I gave to my local Linux Group a while back. The presentation was inspired by Arjen Lentz's outline...
2 comments
82Overview 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 comments80C# 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...
0 comments69CurrentDb 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...
0 comments
