Recent content by miletracker

Jimmy that Works Correctly (and Easy!) Thanks Again Miletracker

I shall try that later busy right now thanks for the reply miletracker

I Would like to do the following : 2 tables named "catagories" and "items" linked to a form that would contain a combo with catagories and a 2 page tab control 1st page would contain a subform or continues form with items filtered by the catagory combo and the second page...

Mark's Idea Works Perfect What I Did is create a combo with field names and 2 buttons (a to z) and (z to a) works great any field can now be sorted thanks miletracker

Guys Have been gone all day Will try Marks Idea in the Morning thanks for the reply miletracker

I Would Like to create a continues form with multi columns and above Several of the columns buttons would allow the user to sort the form (a z) or (Z A) Where do I start???? The Form Is Based Off A Query Thanks Miletracker

I am sorry for not being clear I need to count how many rows of a list contain formulas without checking that sheet rows could be blank or contain data Thanks for the reply

I HAVE A LIST OF VALUE 1100 TO 1500 I NEED TO COUNT ALL VALUES BETWEEN 1200 AND 1299 also need to count how many rows in a list contain a formula MILETRACKER

Taking this question 1 step further I would need to do the same except i would like to add several buttons to a form and attach a clip to each one but i want the f1-F12 keys to activate the buttons miletracker ps sorry for interupting

dhookom's answer works perfectly thanks again guys miletracker

The Following Does Not Work As Expected If Both Locations Are Blank A Blank Is Returned CurrentLocation: IIf([FinisherID] Is Null,[NurseryID],(IIf([NurseryID] Is Null,"No Location Given"))) Changed slightly from CFBaber's Tip Both do not work

Thanks For the Reply Could not seem to get it will try your tip thanks

In a access Query I have 3 fields "Location 1" "Location 2" and "Current Location" Using the if function I want "CurrentLocation" to show the following : If "location 2" is null return "location 1" if location 1 is also null return...

thanks for the response guys what if the crosstab headings keep changing? how to assign that value to my report correctly and as for the first filtered qry i have noticed that it can also cause errrors mile tracker

hI everyone access 2000 I use a form with 16 combos to select items for printing certian conditions must be met or item will not print. ? is after print i need to know wich ones failed to print such as a popup form or msgbox. also on same form items will print in ascending or descending order...