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 microtoolmaker

  1. microtoolmaker

    Keypress Keyascii question

    I am trying to create a dialog box that allows the user to navigate from box to box using mostly the down arrow key. I cannot find the keyascii# for those keys. Does anyone know how I can acomlish this?
  2. microtoolmaker

    123 lotusscript error msg. "unable to locate database"

    I get this error ("unable to locate database") trying to connect to database "New". I am writing this script to 123 v9.5. I am able to connect with the Querry addin, but I need to automate this task. I know the path and names are correct. Here is the line of code that...
  3. microtoolmaker

    Need to turn off system warning

    I have a form with 4 graphs on it.&nbsp;&nbsp;When form is closed a warning appears that must be clicked &quot;ok&quot; to continue.&nbsp;&nbsp;This warning occurs 4 times (4 graphs).&nbsp;&nbsp;<br>It reads&nbsp;&nbsp;&quot; 'i'&nbsp;&nbsp;'The object is locked, so any changes you make will be...
  4. microtoolmaker

    change scale in graph based on query

    Worked perfect!&nbsp;&nbsp;Thanks Ricky
  5. microtoolmaker

    change scale in graph based on query

    Thanks...This looks like the right direction.&nbsp;&nbsp;I'll give it a try. I sent my email address...would like to look through the sample database.&nbsp;&nbsp;I think it will help me ubderstand how to implement the code. Thanks very much.
  6. microtoolmaker

    change scale in graph based on query

    When choosing the &quot;auto&quot; option access makes the minimum y scale to zero.&nbsp;&nbsp;This wide scale hides the details.&nbsp;&nbsp;Is there a programmatic fix for this?
  7. microtoolmaker

    change scale in graph based on query

    I need scale on y axis to change based on query results, so that;<br><br>minimum on y scale =lowest y value-1 <br>and<br>maximum on y scale = highest y value +1<br><br>Is there any way to do this?
  8. microtoolmaker

    limit number of records in a table

    I need to use this table as a &quot;template&quot; to hold 25 records with 2 fields that never change (and a dozen fields that do). This is to &quot;draw&quot; control limits on an SPC graph. And yes, I'm afraid that someone (probably me) will go too far and enter another record.
  9. microtoolmaker

    limit number of records in a table

    Is there any way to limit the number of records in a table?
  10. microtoolmaker

    need advice on add-ins

    Does anyone know of an add-in or something for developing better graphs? I am in desparate need of something straight forward with as many options as possible.<br> <br> Thanks
  11. microtoolmaker

    Problems Updating Graph

    I have a graph embedded in a form that plots a values from calculated fields in a query. The graph needs to be updated after each new record is added. I do not want to link fields since that isolates the graph view to the current record only.<br> Doing a requery does not help. The only way...
  12. microtoolmaker

    Problems with Dmax-Dmin

    WORKS PERFECT!<br> Thank you very much ! <br> dcb
  13. microtoolmaker

    Problems with Dmax-Dmin

    Exactly....<br> This is the "range" in a sample of 3 individual measurements for an Xbar&R chart.
  14. microtoolmaker

    Problems with Dmax-Dmin

    I have 3 fields in a query that hold like numerical data. I would like to find the difference between the highest number and the lowest from these 3 fields in each record.<br> In a spreadsheet this is easy(@max-@min)...column or row made no difference.<br> <br> I can use Dmax and Dmin within...
  15. microtoolmaker

    "Date()"..problem w/access97 version

    in Access 97-<br> &quot;=Date()&quot; is being used as a default value in a text box in a form. When the form is open there is an error msg. &quot;#name&quot;<br> <br> 2000 version takes this and shows it fine...anyone know what might be wrong?
See more

Part and Inventory Search

Back
Top