Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pkj14
-
Export Query to Excel code
Try this - Sub Export2xl() Dim xl As Excel.Application Dim ws As Excel.WorkSheet Dim wb As Excel.Workbook Dim tbl as ADODB.Recordset Dim x As Long Set tbl = New ADODB.Recordset Set xl = New Excel.Application Set wb = xl.workbooks.Add Set ws = wb.sheets("Sheet1") 'First row contains Field...- pkj14
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do I create a query using VBA?
A good code which should serve your purpose is given in "Access Data Analysis cook book" by Ken Bluttman & Wayne S Freeze(O'Reilly) on page 106. One more idea is to build a SQL string to be used as WhereCondition of a form's controlsource [see more in John L Viescas & Jeff Conrad's "Access 2007...- pkj14
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
