Search results for query: *

hehe.. thanks

it's a checkbox on a normal worksheet. Is pushing space when cursor is over it the only option?

Hi, you are right.. I meant in Excel 2003. Thanks! Daniel

Hi all, How can I check a checkbox without the mouse?? Thanks! Daniel

thx for the tip!

Hi Combo, I found a solution that works: For l = i + 1 To j If Cells(i, 1).Value <> Cells(i + 1, 1).Value Then ActiveSheet.Rows(i & ":" & i).Copy Sheets("import").Select Cells(x1, 1).Select ActiveSheet.Paste x1 = x1 + 1 Sheets("Daniel_Test").Select End If...

The Autofilter and pivot options doesn't work (for me) for solving this problem.. if, I don't know how? Do you know how? Or can u help me with the macro?

They are stored as dates.. tried to store them as general, but not sure how this helps...?

The code works without problem now... but it doesnt copy anything to the "import"-sheet? The loop code looks like this: For l = i + 1 To j If Cells(l, 2).Value <> date1 Then Sheets("import").Rows(x1 & ":" & x1) = Sheets("Daniel_Test").Rows(l - 1 & ":" & l - 1) x1 = x1 + 1...

Hi combo, Yes the table has headers, but the different item numbers have different "last dates". Not sure how to sort on that? I'll try your code suggestion...

The Autofilter and pivot options doesn't work. The rows are sorted after item number and date. I have about 28000 rows. My code now looks like this: Sheets("import").Delete 'add sheet Sheets.Add.Name = "import" 'select sheet Sheets("Daniel_Test").Select 'determine how many rows j =...

Hi, In Excel I have a column with different item numbers, like this: 112004 12-01-2007 112004 27-05-2007 113204 01-02-2007 113357 01-03-2007 Each row with item number contains som data (eg. date). I need help to a macro that should take the latest date for each unique item number and then...

Hi All, I'm working on a forecast follow-up-tool. Unfortunately I must be some kind of query-idiot. This is my query result untill now. [URL=http://allyoucanupload.webshots.com/v/2003143911281666711] My Query(design) untill now (parted)...

Hi Max, Now I've tried your Sugestion - can't get it to work. We're should I put the Nz-function in my Sql?

Hi all! Have a look: [URL=http://allyoucanupload.webshots.com/v/2003143911281666711] My problem is this: Cargonumber 070003, There is also a month_of_creation from 01-04-2007 but since theres no order_qty in 01-04-2007 Access ignores it.. My SQL Looks like this: TRANSFORM Max([Alle...

Should have been like this: I'm working on a forecasting follow-up tool. I've got two tables: 1: All_Forecasts (Month_of_Creation, HC_cargoNumber, Month_of_Ordering and Forecast). 2: Actual_Orders (Varenummer, Order_Month And Order_Qty). My SQL untill now looks like this: TRANSFORM Max([Alle...

I'm working on a forecasting follow-up tool. I've got two tables: 1: All_Forecasts (Month_of_Creation, Item_number, Month_of_Ordering and Forecast). 2: Actual_Orders (Item_Number, Order_Month And Order_Qty). My SQL untill now looks like this: TRANSFORM Max([Alle Forecasts].Forecast) AS...

Hi friendly helper, I am lost! I have 1 'Result field' on a form called 'FC8'. This formular works in Excel, but not in Access (too many IIF's I Guess?)...