Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: happymc100
  • Content: Threads
  • Order by date
  1. happymc100

    AutoFiltered array formula- is it poss ??

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

    AX Calendar problem.

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

    Wildcards & "Like"

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

    wrong number of arguments or invalid property assignment

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

    Usedrange or not Usedrange

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

    Excel to Access - Preperation

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

Part and Inventory Search

Back
Top