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!

Recent content by chasmith17

  1. chasmith17

    How to create a Chart

    Hello, I need to know how to create a chart that has more than 6 fields. In the chart wizard it will not let me pick more than 6 fields per chart. When I look up help it talks about using global charts but I can't find out how to select global charts. I have a chart already made in Excel can...
  2. chasmith17

    How to Create Charts

    Okay so I just realized I am in the wrong Forum. Sorry for the confusion. I need to be in the Access forum.
  3. chasmith17

    How to Create Charts

    LB, thanks for your reply. The top row where I have GUN I, Targ I, Gun V, Bmag V, RF Drv, and PFN V are test points where I make measurments. Then where I have 18X, 6X, 6E etc. is the different energies that have the same test points. So what I am doing is taking a measurement for the test...
  4. chasmith17

    How to Create Charts

    Hello, I need to know how to create a chart that has more than 6 fields. In the chart wizard it will not let me pick more than 6 fields per chart. When I look up help it talks about using global charts but I can't find out how to select global charts. I have a chart already made in Excel can...
  5. chasmith17

    Main Switchboard resize problems

    No, it has not been set. When the Main Switchboard opens it just opens as a blank gray box. I have the database saved on my jump drive so I have been messing around with it to find out what is causing it. I start out with the normal small size Switchboard screen and then when I open it up in...
  6. chasmith17

    Main Switchboard resize problems

    Hello, It seems when I change my Main Switchboard to maximize upon opening it just displays a blank screen. I can see the switchboard if I go into design mode, but I can't get it to display in normal mode anymore. I have even undone the changes that I have made to the Switchboard and still...
  7. chasmith17

    Option button

    Randy, I figured it out. It's slowly coming back to me. Thanks for the help.
  8. chasmith17

    Option button

    Randy, I have not worked with access for a few months so it seems I have forgotten alot of things. I am having trouble remembering how to write the criteria for the query. In my query do I need to include all categories or do I create a query for each category?
  9. chasmith17

    Option button

    Hello, I have a parts database that has Part desc., Part number, and part location feilds. Also I have a few categories where the parts belong to that are designated by Option buttons. I would like to know how to setup a form to search by parts that belong to a category? For instance when I...
  10. chasmith17

    Tracking number changes in fields of a form

    I can sort by Date. Your example you gave is just what I am looking for. Just curious, what other kinds of things can I do? There are way too many fields to post. Thanks alot for your help MajP.
  11. chasmith17

    Tracking number changes in fields of a form

    MajP, Your assumption is right, it is the last pm record entered. You are also right in that each pm record has an ID. Will the above code send me to the last pm record entered or will it just flag me when a particular field is out of the tolerance? Also what do you mean by Unique field?
  12. chasmith17

    Tracking number changes in fields of a form

    MajP, On my form I have Asset ID and some other test point fields that I record for Preventative Maintenance on an Asset. I would like for the field to flag me if the new value I enter in the field is let say 0.9 different than the previus record. Thanks for your help
  13. chasmith17

    Tracking number changes in fields of a form

    Thanks for the reply rjoubert, That sounds like what I am trying to do. Can you tell me how it works?
  14. chasmith17

    Tracking number changes in fields of a form

    Hello, Can someone advise me on how to track changes in fields of a form. For example if I enter a value in a field on my form for one record and then the next time I enter a value in that same field on the same form but using a different record, how can I setup where I can either see what the...
  15. chasmith17

    Linking calculated fields to a control source

    Thanks for your help guys, I thought about what I was trying to do and it turns out I shouldn't ever need to run any queries or reports for this form. All I need is right there in the form. Thanks agian for helping this newby.
See more

Part and Inventory Search

Back
Top