Search results for query: *

I need to do a Distinct Count on order numbers. I have a table with order_id and line_id. What I need is the number of order with 1 line, 2 lines ect. I am at a loss on the distinct count of order_id. order_id line_id 1001 1 1001 2 1001 3 1001 4 1002 1 1002 2 1003 1 1004 1 1004 2 1004 3 1004...

I am trying to use Change Event to hide or unhide rows based on user input to a given cell. Here is what I have so far: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Windows("Deal_checklists_v6_1.xls").Activate Sheets("Deal Reg. Overall").Select...

I am trying to write vb to send several different mail messages with attachments. The issue I am running into, is if one of the recipients is taken out of the address book, then the code bombs when it hits that name. Is there a way to error check the names before sending out proceeding to...

I need to be able to find and open multiple workbooks each month. The workbooks will always be in the same folder and the name will always start with "EXP". I can find the files with the code below, I can't figure out how to open each file when it is found. Private Sub CmdFndFile_Click() Set...

I need to append the following cells into a single string adding a single quote before and after each number and a comma separating them. I also need this to occur until it reaches the last row of data. Row Col A 1 603339978 2 603339979 3 603339980 What I need in a...

I have a workbook is a download from the web, that has named sheets in it. The sheet name has been changed on some of the downloads, so I need to be able to find either sheet name. I am trying to do something like the statement below, but I am having trouble with the syntax. If Sheets.name...

Can you use 'AND' and 'OR' operators in a decode statement and if so, what is the syntax? Thanks, Lauren

I am using VB6 in Excel to do a comparitive of two tables and copy if a vlookup value does not exist in the lookup array. I am using the following code, but the value keeps coming up false. Dim vLookupValue Dim C As Integer Dim lngLastRow As Long Workbooks.Open...

I am using VB6 in Excel to do a comparitive of two tables and copy if a vlookup value does not exist in the lookup array. I am using the following code, but the value keeps coming up false. Dim vLookupValue Dim C As Integer Dim lngLastRow As Long Workbooks.Open...

I am using the following 2 variables, which I need to reset on change of invoice number. But previous forces formula to evaluate whileprintingrecords, which prohibits me from grouping on the result. Is there any way around this? 1) WhilePrintingRecords; Global stringvar FirstDiv; if...

I don't know if this is possible, but here is what I am trying to do: Inv Line Number Inv Number Account Number 1 123 2365 2 123 null 3 123 null If line...

I need to write a formula that evaluates a group sum. When I tried the following formula: IF Sum ({@Conversion}, {AP_INVOICES_ALL.INVOICE_NUM}) >= 0 AND Sum ({@Conversion}, {AP_INVOICES_ALL.INVOICE_NUM}) <= 10000 THEN '$0 - $10,000' I am getting an error message: Group specified on a...