• Hubs
  • tagged ms access

1-10 of 64 hubssort by Hot Best Latest

These sins scream "Noob Noob Noob!"73

Seven 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    programming data database
msaccessmemento profile image70

MS 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 comments    ms access
msaccessmemento profile image68

String 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    ms access vba string functions
msaccessmemento profile image63

ShellExecute 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 comments    shellexecute ms access win32
msaccessmemento profile image69

MS 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    ms access ms access function format function
68

C# 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    ms access vs dot net
They will bite you unless you exterminate them67

Seven 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    programming data table
Customer Data (click to enlarge)82

Overview 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    technology education computers
80

C# 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 comments    ms access vs dot net
msaccessmemento profile image69

CurrentDb 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    ms access ms access vba
working