Recent content by elgoober

Hi I have a combo box that goes to the 1st record in the recordset, - but is there a funky way of filtering on that first record that it finds? Field is CustomerNo. Any help - more than gratefully received. Cheers Paul

Hi I have a table that contains several thousand records detailing PartNo, Price and Customer. I want to do a query that ranks the price for each part number so say Part Price Rank a 1 1 a 10 2 a 100 3 b 1 1 b 10 2 b 100 3...

Hi Have a Crystal report V10 that is driven by a parameter called ShowCustomer - is there any way of viewing the detail of ShowCustomer - i.e so that it shows the customers selected by the user - say Argos,Homebase,Wickes etc in a text box? Any help gratefully accepted Cheers Paul

Cheers Namliam Have a good day Paul

Hi I have a table that contains 1 year of sales. Fields include Item,NetSale,Customer,Month. I need to count how many times an item has been bought by a customer. I can see from a report wizard how the count is achieved - but I need to action this at query level. Any thoughts/help greatly...

Perfect Thanks Bilbo.

Hi I want to remove the last 2 characters in a code - so in the stock code BS1222222ZZ I want to get rid of the ZZ. There are 6000 records that need to be amended. I was thinking about some form of query that would a) Count the number of charcters (Expr1) b) Based on the number of...

noted Duly noted- only reason I've included in table - is that the db will distributed across 100 countries + i really didn't fancy doing image files for each machine. Interestingly - if you export to snapshot format it works like a dream - Cheers Paul

Ola This is a weird one. I have a report that prints embedded Access graphics - from a table. When I originally designed it, each time I went to print - no graphics appeared - then almost overnight - they started to print and I've had no trouble since - until today... when I started adding...

fin just dumped a me!requery underneath your code - and presto Thanks again for all your time Nice one Paul

interesting top man - that works - the only quirky bit - is that when you select the 2nd yes (after changing mind) both options appear as yes - but when you close the form and check the results - perfecto - is there a way of saying requery on any of the events to get shot of the second yes...

compile copied and pasted the code onto the OnChange of the selecta I'm getting a compile error on the BedType (checked spelling - and case) Sub or Function not Defined

But the bedtype is the primary key of the table - and selecta is the yes/no field - do I use the 1st example with Me.Selecta at end and do I hang this on the OnChange of the selecta control or on 1 of the form events Don't let the wife know that I communicate more with you....

mist clear - nearly Perfect translation.. Ok - I see - but I don't - no idea how you put criteria to say current record for bedtype in the update query

still here Hi namliam I will look again @ option - but I tried that originally - and it has issues with presentation... just for my peace of mind - the update query - I've actioned these before no probs - + understand the <> etc - but I'm massively struggling with - if the user selects 1 item...