Excelguru Help Site - Access

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (6)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (11)

Excel - PowerPivot (6)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (48)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (0)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (3)

Word - VBA Programming (8)

Access - SQL
Creating an Access Database (on the fly) Using VBA and SQL

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-09-05 06:22 AM Number of Views: 14761

I recently had reason to create a database on the fly if one did not exist. Since it took me some trial, error and searching (and then more trial and error,) I decided to share the method to do this. The following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc...
...

Read More
Retrieve Data From A Database To Excel Using SQL

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-04-12 06:52 AM Number of Views: 29245

This article shows how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings. ...

Read More
Populate Multi-Column Listbox With Data From Access

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-02-16 08:11 AM Number of Views: 6735

Macro Purpose:

Retrieves data from an Access database, and fills it into a userform listbox.
...

Read More
Export A Range Of Excel Data To A Database

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2004-12-21 07:09 AM Number of Views: 14140

Macro Purpose:

Exports a table of data from Excel into a database, using an ADO connection to pass SQL strings.

...

Read More

Recent Forum Posts

bar charts with two axes

Excel 2010, Table, PivotTable, PivotChart
Bar chart with 2 non-overlapping series.
http://58918aa17d4002474361-7ac2b7ee...05_21_13b.xlsx...
Herbds7 Today, 12:22 AM

Help with charting. How to use only last 15 rows after updating.

Excel 2010 Table, Chart
Use Defined Names
Tables are dynamic.
http://58918aa17d4002474361-7ac2b7ee.../05_21_13.xlsx...
Herbds7 Yesterday, 08:25 PM

IF AND Statement with ISBLANK and conditional

Great - Im glad you resolved it.

Herc...
Hercules1946 Yesterday, 05:42 PM

Unsure how to change vba code to work properly select case and me.controls

I have this code: It works as displayed in the first table.
Set wbk = Workbooks("News.xlsm")
For i = 2 To 11
Select Case Me.Controls("Combobox"
...
cane Yesterday, 05:40 PM

got it!

Hi--got it, I inserted an IF statement in the vlookup that pulls the container # from the other tab that way it returns a blank cell if there is no value...
emartz Yesterday, 04:52 PM

Knowledge Base Articles By Category

Access - SQL

Recent Forum Posts