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

  • Users: InyoTom
  • Content: Threads
  • Order by date
  1. InyoTom

    Property Let to define an array variable in a class module

    I want to make an array variable be a property definition in a class module. In the class module, statements such as: Dim dblArray() as Double Property Let MyProperty(dblWPT As Double) dblArray() = dblWPT End Property Access Help does not talk about arrays as properties, only scalar...
  2. InyoTom

    Command button to stop processing

    How do I configure a command button to stop a program loop, and return control to the user? Tom Budlong TomBudlong@Adelphia.net
  3. InyoTom

    Maximum Number of Indexes

    Access won't allow more than 32 indexes in a table. Any way to get around this? Tom Budlong TomBudlong@Adelphia.net
  4. InyoTom

    Remove reference in Tools, References. How to?

    Anyone know how to emove an entry from the 'Available References' list in Tools, References? Tom Budlong TomBudlong@Bigfoot.com
  5. InyoTom

    Min and Max Functions

    Search as I might, I can't find Min and Max function, which would suck out the minimum or maximum value from a list. It would be something like: lngMaxValue = Max(lngX, lngY, lngX) So I have had to write my own. Hard to imagine a programming language without these, so I suspect I have not...
  6. InyoTom

    Too Many Indexes

    Access won't let me define more relationships. It claims I would exceed the limit of 32 indexes. This is an accounting app, and I do have a lot of relations defined for the AccountNumber field. The specific message, when I try to create another relation to AccountNumber is: "The operation...
  7. InyoTom

    What Good are Null Values

    My code is littered with IsNull and Nz, defenses against the Dreaded Null Value. So far I have not discovered a good use for null values. Perhaps I am missing something. Anyone out there know any beneficial uses? Tom Budlong TomBudlong@Bigfoot.com
  8. InyoTom

    Invalid Outside Procedure message

    All of a sudden, almost all events (Open, Update, ...)on my forms and controls on forms get an 'Invalid Outside Procedure' error message, and suggest that perhaps the event expression is not [Event Procedure], which is silly. Can't find anything in Help about this. Backup copies of my database...
  9. InyoTom

    Read data under the cursor

    In a form or report, I want to right-click and read the data the cursor was pointing to. So I can bring up a form to edit that data and associated data. Any ideas how I can do that? Tom Budlong TomBudlong@Bigfoot.com
  10. InyoTom

    How to put Find dialog in a program

    When viewing a table, Edit Find (or the binocular icon) puts up a nice dialog so you can specify such things as matching full-field or partial field, etc. How can I put this dialog in my program? <p>Tom Budlong<br><a href=mailto:budlong@who.net>budlong@who.net</a><br><a href= > </a><br>
  11. InyoTom

    Driving Peachtree from MS Access

    I use an MS Access program to send transactions to Peachtree Complete Accounting using Peachtree's DDD capability. (Apparently Peachtree does not support OLE in any form).<br><br>The interface works well, after some agony, for some functions. Other functions are not supported as far as I can...
  12. InyoTom

    SendKeys compiler error.

    Attempting to run a module with the following statement gets error &quot;Compiler error: Wrong number of arguments or invalid property assignment.&quot;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;SendKeys &quot;%FX&quot;, False<br><br>This statement is from code-conversion of a macro with SendKeys action...

Part and Inventory Search

Back
Top