Search results for query: *

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...

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...

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...

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...

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...

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...

I have an ACCESS 2000 db, where I have 4000 recordsets with 13 fields, one field is the date entered, which DATA TYPE is set to Date/Time. In Access I can sort by this Date field, and use the BETWEEN parameters fine.<br> <br> When I use VB6 code and load a form in the MSGrid from this database...

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...

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>

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...

Recently loaded, 2000, and no add-in's(i.e.&quot;Switchboard Manager&quot;, are installed. Did a full install.. Ideas??<br> <br> My Access 97 has them<br> <br> thanks...........