Recent content by missprogrammer

BRAInDead values are assigned strRegion = "Special Account" intRound = 82 After I made the changes you suggested it's running but ONCE AGAIN no value

This query is running but it is not retuning a value. Is there something wrong with my "having" clause It returns a value when I just have the Round(intRound) alone, but when I include the Region(strRegion) it does not return any value. What am I doing wrong? Dim intRound As Integer...

OKAY GUYS GOT YOU THANKS ALOT.

WsRecordset.Open _ Source:="SELECT DISTINCT Count(dbo_F2KCube_Calls.CallID) " & _ "FROM OUTLETPROGRAM INNER JOIN dbo_F2KCube_Calls " & _ "ON (OUTLETPROGRAM.CallID = dbo_F2KCube_Calls.CallID) " & _...

sorry, should of been more detailed. I am pasting my results of several recordsets into excel using vba. My thing is I wont know how may records exist in each recordset. So I can I find the last used cell or fist empty cell. AccessIsFun (Programmer) Nov 19, 2001 You could count the...

AccessIsFun;call me stupid, but I dont understand.

sorry, should of been more detailed. I am pasting my results of several recordsets into excel using vba. My thing is I wont know how may records exist in each recordset. So I can I find the last used cell or fist empty cell.

can you help me to get started on finding the first empy cell in a column

okay, quys you to have lost me...So what exactly is your conclusion....

well, what i did the first time is probably stupid, and the more i think about it I wonder why I approached the situation like that.. But, I am learning... I have the db already in SQL an odbc conn. and i linked the tables in access(which is what i did the first time). But anyway the report I am...

I run this report weekly and I want to increase the processing time. I dont know if the way I did it the first time was the best way, I created a connection to a SQL Database using Access(ado). Would it have been better for me to use VBA using a sql to the sql tables... by doing so would this...

Thank you so much Dutt, one more thing. This is working find. I run this report weekly and I want to increase the processing time. I dont know if the way I did it the first time was the best way. But I created a connection to a SQL Database using Access. Would it have been better for me to use...

I am new to vba and I want to create multiple queries in vba using ado connection and export the results into excel spreadsheet.

DarkSun no I dont. Not only That how would i specify only the to incude the next 3 columns. I dont want to shade in anything outside of the range

The column count will differ for each sheet(possibly evertime its ran) Private Sub Check() Call ChangeColor(1, 10) End Sub Private Sub ChangeColor(MyCol As Integer, MaxRows As Long) For i = 1 To MaxRows If ActiveSheet.Cells(i, MyCol).Value = "" And ActiveSheet.Cells(i...