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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dewey
  • Order by date
  1. Dewey

    Import Excel data to simple array in VB

    NoHandle,<br>thanks again.<br>I finally dropped the &quot;.worksheet01&quot; out of the workbook name, which then gave me:<br>appExcel.Workbooks.Open &quot;c:\reports\march00.xls&quot;<br>It now accesses the workbook and I need to figure out code to address each worksheet in the workbook,( there...
  2. Dewey

    Import Excel data to simple array in VB

    NoHandle(one more time)<br>I edited the typo, but I get the VB error '1004' when I try to run. It says that the file &quot;c:\reports\march00.worksheet01.xls&quot; can not be found.<br><br>I&nbsp;&nbsp;Know it is there and spelled correctly.&nbsp;&nbsp;I understand your code now, just can't...
  3. Dewey

    Syntax Help - appExcel statement

    I can not figure out why this won't work.&nbsp;&nbsp;It must be something very simple.Option Explicit<br><br><br><br>Private Sub Command1_Click()<br>Dim i As Integer, j As Integer<br>Dim aryExcel()<br>Dim appExcel As Excel.Application<br>Set appExcel = New Excel.Application<br>ReDim aryExcel(7...
  4. Dewey

    Import Excel data to simple array in VB

    Nohandle:<br>Thanks for the response.&nbsp;&nbsp;I tried the following:Option Explicit<br><br><br><br>Private Sub Command1_Click()<br>Dim i As Integer, j As Integer<br>Dim aryExcel()<br>Dim appExcel As Excel.Application<br>Set appExcel = New Excel.Application<br>ReDim aryExcel(7...
  5. Dewey

    Import Excel data to simple array in VB

    I have tried many like:<br><br>SELECT [A53:G78] FROM &quot;c:\Reports\March00.Worksheet01.xls&quot; <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
  6. Dewey

    Import Excel data to simple array in VB

    Elementary but i am trying to do the following:<br>From an Excel 2000 file &quot;c:\reports\march00.worksheet01.xls&quot;, I need to load into a simple array in VB6 the grid of &quot;A53:G78&quot; so that I can strip some data out. <br>I am somewhat lost and confused. I can create a connection...
  7. Dewey

    Input mask -- Parameter Input

    try to explain further.. my form is a datasheet, and when it first opens, you get the query date (where i would like to have the mask, without the slashes.&nbsp;&nbsp;Once the form is opened and displayed( approx 4000 records, we then sort or find on a particular field.&nbsp;&nbsp;Each time, it...
  8. Dewey

    Input mask -- Parameter Input

    Doug, that is what I am doing now. Why i would like the mask is that you do not have to input the <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
  9. Dewey

    Mouse On Startup

    When I open a form for the first time, I want the Mouse to be at a certain location, so that the ToolTipText becomes visible immediately.&nbsp;&nbsp;I know this must be simple, but I have never needed to do this before.....I have looked in many VB books, and can't get an answer....Any help would...
  10. Dewey

    Input mask -- Parameter Input

    Is there a way to set a Input Mask &quot;__/__/__&quot; in the Enter Parameter Box at the start of a Query&nbsp;&nbsp;&nbsp;Throughout the forms, you can, I have been looking and can find no answer, maybe someone knows for sure... thanks in advance for reading this <p>Dewey Davis<br><a...
  11. Dewey

    BETWEEN [start date] AND [ending date]

    Thanks for all the help... I'll keep &quot;puttering&quot; with it.. <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
  12. Dewey

    BETWEEN [start date] AND [ending date]

    this may be easy but i've missed it...<br> <br> I am using the query criteria to input 2 dates via the parameter screen, which are [start date], [ending date]. The query runs fine, but I can not figure out how to get these dates set to a variable to print on the form in a label or textbox...
  13. Dewey

    VB6, Access2000 and ADO

    It may be elementary to add but your might look at:<br> <br> &quot;<A HREF="http://support.microsoft.com/support/kb/articles/q238/4/01.asp&quot" TARGET="_new">http://support.microsoft.com/support/kb/articles/q238/4/01.asp&quot</A>;<br> <br> This told me what I needed to know to make VB6 and...
  14. Dewey

    MSHFlexGrid - format columns(bands)

    Using the Adodc control I have an ACCESS 2000 table, that I have connected to and view in VB6. It is 4500 rows long with 14 columns wide. In MSHFlex Grid they call the columns bands.<br> My problem is that one of the columns(or bands)(column 12 or band 12 named &quot;ScaleAmt&quot;) is .40, but...
  15. Dewey

    Date is str - from ACCESS 2000

    ...quirk. I have run out of ideas.. <br> <br> my SQL code is elementary:<br> <br> PUBLIC VarStartDate as Date<br> PUBLIC VarEndDate as Date<br> <br> SELECT * FROM tblKillSheet BETWEEN varStartDate AND varEndDate <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= >...
  16. Dewey

    Query - Between [start date] and [ending date]

    When I use the parameters in the QBE grid of 'Between [start date] and [ending date], I can pass to the reports these dates to print on the report, using the [start date] and [ending date] as the variables to print. When I try to pass these variables to a form, I get Name?. Somewhere I am...
  17. Dewey

    default input in text box from previous form

    It is for 200+ forms, not records... <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
  18. Dewey

    ActiveX for printer

    Yep... thats just the problem... It takes a lot of code to do the formatting that I need..I was hoping that there is an addin (I guess I am lazy),
  19. Dewey

    ActiveX for printer

    Any suggestions on an addin, to make VB6.0 print to paper a lot easier. i do a lot of hard copy print outs, and the printform just doesn't give me what i need... thks <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
  20. Dewey

    default input in text box from previous form

    I have ACCESS 2000 running a form, that the first text box calls for the date, which is formatted and masked. However at each session I may enter 200 forms in this db. I would like for the next form to remember the date from the previous form. This would save numerous keystrokes daily. maybe...

Part and Inventory Search

Back
Top