Re: Loading Listbox on Userform from Access recordset: Plese Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Gentlemen, Here is a ruff scenario.
I'am using excel 2003..
I type a value in a cell(that is my variable)
I press the enter key
The variable is passed to an sql statement to open n access database.
What I need:
Once the sql statement is issued it brings the result into a listbox on
a Excel 2003 Userform.
Hope this helps!
Thanks for the replys very much...

.

Relevant Pages

  • Re: SQL statement format for readability and making adjustments purposes
    ... would do something with the SQL statement, that would make my text file ... create a table in the BE file with the query name and the memo ... I knew Excel inside out ... allowed me to get a production reporting system in place, fully debugged, ...
    (microsoft.public.access.queries)
  • RE: weird problem when using MS Query from Excel
    ... strange non-ODBC driver? ... Wizard in Excel... ... Create a simple query against the db using the MS query wizard, ... > If I look at the SQL statement before I return to Excel it looks like this: ...
    (microsoft.public.excel.programming)
  • Re: How to run a complex SQL statement against Excel spreadsheet r
    ... Dim oCmd As ADODB.Command ... ' Open a connection to the Excel workbook. ... Set oConn = New ADODB.Connection ... ' This SQL statement selects a named cell range defined in the workbook. ...
    (microsoft.public.excel.programming)
  • Microsoft Excel is not a database
    ... big table *looks* like a database, ... Thankfully one thing Excel *is* good for is ... creating SQL insert scripts. ... more than one SQL statement, or even SQL statements more complex than SELECT ...
    (uk.misc)
  • Re: How to run a complex SQL statement against Excel spreadsheet r
    ... Is there any advantage to using straight Excel such as: ... on a sheet that wasn't the first sheet. ... Referencing entire sheets ... ' This SQL statement selects a cell range in a particular worksheet. ...
    (microsoft.public.excel.programming)