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 TouchToneTommy 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: *

  1. miletracker

    Syncronize Form With A Tab Control

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

    Sorting A continues Form

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

    Count Values in Excel

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

    Adding third clause to IIF

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

    Crosstab filter

    Why does a crosstab not allow filtering or limiting records to date parameters . or am i missing something? miletracker
  6. miletracker

    how to set printing order

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

    Date Diff Error

    Can Someone help me with the following problem I have a VB6 project with a access97 datasource I am tring to get the differance between 2 dates (in days) when I use the DateDiff function i get the following error "Data provider or other service returned an E_FAIL status" If I try to...
  8. miletracker

    Combo display Item & Cost

    I need help with the following , I have a form "ExpenseEntry" (for adding expense Items ) bound to table "Expense" with a combo that gets its values from a table named "Parts"(has part info and price) when the user selects a part from "PartNameCombo" I...
  9. miletracker

    Save a file with Item Name

    Hi Everybody this Question may have been asked before I have a query that will that will bring up records to remove( or save to a excel table) what I would like to do is attach code to a command button that would give the file its name from the dialog form that set the parameters for the...
  10. miletracker

    Saving Page Printer Settings

    Can anybody help me with the following problem. After selecting the start date, end date ect. for a report the report will open but always uses the default page settings I need the report to preview with Page as "Landscape"& margins at .25" to the sides without having to...
  11. miletracker

    Linked Report Heading?

    Me again I need to Link My report heading to an Item that was selected in the combo when setting the report parameters Miletracker
  12. miletracker

    Retrieve Sys Info on startup?

    Can I have my DB go to pc sys & retrieve info such as processor # and not open if the # does not match with an Existing # (to prevent having the db copied to a diff. pc without permission) miletracker
  13. miletracker

    Find Record After Update?

    I need help with code for the combo afterupdate. This should be easy to do, after combo [Truck List] is updated and ' Truck 1' is selected the form should display the LAST record for that truck.(The table will contain the records for all trucks in the fleet). Miletracker
  14. miletracker

    Wrap text long headings

    I need to know if there is a way to "wrap text" on a subform heading as is available in excel thanks in advance miletracker
  15. miletracker

    Saving form data ?

    What is the easiest way to save the results of expressions in forms to the underlying table ?
  16. miletracker

    Auto Expand Combo?

    Can i make a combo box 'dropdown" on "got focus" other than with F4
  17. miletracker

    Change Date Values with + - keys

    is it possible to change date value in text boxes with + - keys I have an older DOS record program where that is possible when the focus is on the date "box" pressing + 7 will add 7 days to the current date value
  18. miletracker

    Change Date Values with + - keys

    is it possible to change date value in text boxes with = - keys I have an older DOS record program where that is possible when the focus is on the date "box" pressing + 7 will add 7 days to the current date value

Part and Inventory Search

Back
Top