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!

Register Log in
  • Congratulations Rhinorhino 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. juli5e

    Menu Bar

    I have generated a form that would run off a query. Now I would like to create a menu bar for user friendly purpose. How would I do this? Thank you in advance.
  2. juli5e

    Need help on Macro

    Eric, Did exactly what you had instructed and when I click on the button, it would give all warehouse locations. Just to clarify things, the "unbound" text box, in the "other" tab, I should label it txtWhseLoc. In the command button, since I am using Access 2000 still, the button wizard...
  3. juli5e

    Need help on Macro

    Yes. My report is an inventory report that consists of all warehouse location and I was able to do that. As you know, at the query level, I can input a warehouse location and pull the inventory info. from there. I would like to perform a macro that would give me a form so I can input my...
  4. juli5e

    Need help on Macro

    If I have generated a query successfully and would like to create a macro to automatically pull the query and give me a form format to input my criteria before running the query. How would I do this? Thank you in advance.
  5. juli5e

    ODBC - call failed (error 3146)

    I am currently using Access2000. I am using it to perform custom functions drawing data from our ERP system (Visual Foxpro 8). With the latest upgrade of our ERP system, Access is indicating an error code 3146 ODBC - Call failed. How do I find out what this error mean? Thank you.
  6. juli5e

    Convert Field display into different text

    What would be the best way to convert a field display, ie. "standard" into "std"? For example: if I have fields that contain text "standard", "mfg hold", and "cancel" and I want them to show as "std", "hold", and...
  7. juli5e

    Record Selection Question

    I am using CR8. Most likely due to some multiple linking but it would take too long to explain the inadequate databse structure (Manex). Yet, my results are showing up but it has multiple items that are the same.
  8. juli5e

    unique record selection

    I am using CR8 but it does have the "distinct" function. Thanks a million!
  9. juli5e

    unique record selection

    How do I select only unique records? For example, if CR is showing me duplicate records such as: workorder# qty sales order# Line# 1111 100 4555 1 1111 100 4555 1 How do get CR to show me only one record? Suppressing will not help my calculations.
  10. juli5e

    Record Selection Question

    How do I select only unique records in Crytal Report? For example, if my report is showing duplicate entries of record such as: Workorder# Qty Sales Order Line# 1111 100 4555 3 1111 100 4555 3 How would I tell CR to just show me one record only if...

Part and Inventory Search

Back
Top