Search results for query: *

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

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

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

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

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

Okay the situation is that I'm pull this information from an Olap Cube using MDX quering and VBA. The code is going through a loop and creating several worksheets within the workbook(Totaling 8 workbooks). This will be ran everyweek. The Clients wants to shade the blank cells red. What type of...

I can not figure out how to select the last four columns.The code below stores the first column, but from there i want to select the next 3 column. Within the column i want to select the cells that are null and where the cell is not already black and turn red If .cells(y - 1, x) <>...

Within my workbook i have serveral worksheets that have several columns and the last the colums on each worksheet i want to color red where it is null what should i do. Please Reply

I'm having problems with my code, Im getting a compile error next without for. What am i missing I trying to loop the code through the workbook on all the sheets Please help,Thanks in advance Private Sub CenterCells() Dim c As Integer For c = 1 To...

If anyone can help please reply. I have financial report and every where that there is a zero they want &quot;-&quot; to be showninstead. now the problem is that i also have a subreport. at the end i want to do a grand total sum from the totals. but the problem is that...