Bingo! Thanks for that!

You can simplify this by using Excel's CopyFromRecordset method:

Replace this:

Dim rowIdx As Integer

If (rst.RecordCount > 0) Then

...

In Access you can do a DoCmd.TransferSpreadsheet (Excel) or DoCmd.TransferText (tab or csv) using a query as the datasource

If you change the timeout to 0 it will never timeout

try this:

Function TrackApplicationUsage()

Dim cmd As ADODB.Command

On Error GoTo ErrorHandler

Set cmd...

Eric Mamet (4/18/2010)

---

I tried Parameters.Refresh but it fails all the time.

Apparently, when I do this, it seems to try and fire the stored procedure which does not work because...

Try this:

strComment = gvarInfo.strTableNameSql & ".Comment = " & Chr(34) & Me.Comment & chr(34) & ", "

The second (empty) parameter in this line is RecordsAffected - if you put a variable name there, the variable will tell you after the execution how many rows have been...

Which Chris?

There is a way of doing it - you have to retrieve the parameters from your stored procedure with the Parameters.Refresh method, then populate them, then send them back -...

From SQL Management Studio, create an empty database to hold the tables you wish to import.

Right click on the database name, then choose Tasks/Import data from the popup menu -...

David Lester (10/5/2009)

---

Well, the issue is as this is a front end for roughly 30 standardized reports, which will be all generated with the same criteria set, I have set...

Friday-Home!

Stacie Loving (3/17/2005)

---

I've managed to create labels and even have the spacing come out correctly . . . IF I don't allow the textboxes in the list control to grow...

New Job!