Search results for query: *

All I can say ppl, is that with so many disatisfied IT pro's out there, means there is more chance of that good position for myself. Take it from me, compared to the general public IT is a hell of a well paid career. If people chose to over extend themselves financially, then whatever job they...

Kevin, Thanks for that, It really hits the mark. So simple really. Ive used the subtotal before for nr.s but not type. Many thanks again Mike

Afternoon Everyone, I hope someone can help me. I have entered for someone the following formula in cell K2. It counts the number of times a selection appears in column K below the fomula. "xxx" is only sample data...

Hi People, Quick question, but it is bugging me.... Using the AX Calendar in A2000, and it works great. However when you open the form with the calendar on, it only appears as a white rectangle, until one of the other fields on the form has data entered into it. Then, it appears correctly. Does...

Aceman, Thanks for your help so far. Im wondering if other people who are making this work, have primary fields, or have had to remove them. Not really something Id want to do. Cheers Mike

IT WORKS !!! So blindingly obvious.....Thanks. I already use it all the time in Excel to format SAP reports. Ive been struggling with this for two days now. I must have been brain dead the last few days . Thanks for the help Mike

Hi People, I know this has probably been asked before, but until search is working again, Im a little stuck. I have set up the criteria on a query as below: This works fine when I enter a complete string that resides in the field. However it returns nothing when I input a partial string. Like...

Sorry... faq702-1177 Mike

thread181-27567 Hi Folks, Im trying to adapt the code for the search utility on the above FAQ. However I keep getting the error "wrong number of arguments or invalid property assignment" when it gets to "AddToWhere [Find1], "[CustomerName]", MyCriteria, ArgCount" I have defined the...

Ken, Thanks for that, It works great. Now all I need id for it to create a virtual Kylie Minogue for me, and I'll be the happiest person in the world ;-) Cheers Mike

Hi people, I am using Usedrange to select my area for using special cells to select and fill blank cells. However, how do I do this, but not select the last column of data. Rgds Mike

Hi Folks, I Have a spreadsheet pulled from a maiframe report. Column A contains a Vehicle nr. Column B contains a Product Code. Column C contains a Qty for the product in 'B'. Now I want to build a database, based on this (and other) info, but if a vehicle has more than one product (upto 30)...