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 derfloh 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. hmlhml

    multiple instances of a form

    This is just another update in case someone finds this thread in the future. I just want to add a few cautions. I really think that if you are considering having multiple instances of a form in a database, this is an important design decision to be taken at an early stage, because it has...
  2. hmlhml

    multiple instances of a form

    Thanks again! Yes, I'll set it up that way, with properties. The more I use access, the more I realise how little I know. I'm sorry about still having my multiple-instance form being opened traditionally at the same time. This was laziness on my part; I should go back and find all other places...
  3. hmlhml

    multiple instances of a form

    In case anyone finds this thread in years to come, a few follow-up points: (1) It is really important to avoid modal forms being open when using multiple instances. A modal form open at the same time means that even though the instance is open and visible, no one can click on it or do anything...
  4. hmlhml

    multiple instances of a form

    thanks for the mention of Excel working differently. I haven't had much to do with Excel vba, but will remember that one. I found a note elsewhere that forms started as new instances in the manner described above don't operate in the same way as a typical modal dialogue (no matter how hard one...
  5. hmlhml

    multiple instances of a form

    You hero! Thank you so much. I will be working on this by VPN later this evening, and will get going sorting it out. Yes, the explanation of local variable going out of scope makes perfect sense too. I may as well not cut corners, and do the proper implementation of a collection with relevant...
  6. hmlhml

    multiple instances of a form

    I am making a mess of opening two instances of a form. The situation is this. FormA is a menu, opening FormB (a continuous form showing a lot of records) modally. This can open FormC (a dialog form, opened modally), which sometimes wants to open a new copy of FormB for the purposes of selecting...
  7. hmlhml

    Calculated fields not displayed in Access - a disastrous bug

    Sorreeeee! Primary question is: (1) If anyone here knows a work-around for this that the people in the other thread haven't found, I'd be very grateful. Secondary reason for posting is: (2) I've just wasted half a week trying all sorts of silly approaches and wondering what triggers a...
  8. hmlhml

    Calculated fields not displayed in Access - a disastrous bug

    Oh I hate this sort of thing. I have an access database that has been working fine, but then, with no input on my part, decided spontaneously to change its behaviour so that calculated fields no longer display. I found the explanation...
  9. hmlhml

    Using a Username as the parameter to query

    Remember that if people will expect to log off, and another person log on, without closing the database between, then you will need to reinitialise the attempts counter. I personally dislike storing passwords because I feel (1) that none of the applications I use is really secure enough to...
  10. hmlhml

    Transactions, and passing Null

    Thanks so much, both! Suddenly NULL becomes a much more usable thing. Appreciated...
  11. hmlhml

    Transactions, and passing Null

    I'm afraid these are two separate questions. I'm a bit of a noobie so these are two subjects with which I struggle: (1) Transactions: I don't understand how much I can wrap in a transaction, and what happens to the public exposure of any record made after a transaction has started, but before...
  12. hmlhml

    Does anyone know what Err # -2147221233 means?

    Facetiously, that Access has at least 2147221232 other ways to go wrong? Good luck!
  13. hmlhml

    Cycle spotters

  14. hmlhml

    Cycle spotters

    Here is a fairly vaguely-presented puzzle; it's more of a topic for thought. I'm afraid it's completely politically-incorrect, and please, reader, feel free to change the genders of the subjects at will. I cannot say how I came to be aware of this one, all people and places are imaginary, and...
  15. hmlhml

    DLookup

    I still think the solutions suggested in your previous thread with this question: http://www.tek-tips.com/viewthread.cfm?qid=1666439 were better than what you are doing now. Your code as posted at the start of this thread attempts to increment NewRev instead of Number, in addition to the...
  16. hmlhml

    Excel 2003 - sum limitations??

    Tony and Loomah, this is exactly why I (almost) never use a fixed decimal format with three digits after the decimal point. I will use 1, 2, 4 etc., but not a multiple of 3. Multiples of 3 make too much confusion when data are viewed by people from different countries. Skip, you're right I...
  17. hmlhml

    Excel 2003 - sum limitations??

    Enlarging on Skip's diagnosis: You are summing numbers with 11 significant digits. By the time you've summed 1000 of them, the result may have up to 14 significant digits, and is likely to be three orders of magnitude bigger than the 1001st value to add. This value is stored to 15 decimal...
  18. hmlhml

    Is there a way to export code from a corrupt database?

    thanks everyone for this thread. I used to get lots of access crashes when writing vba but haven't since I adopted the following policies: - NEVER edit anything when code has been suspended by breaking at an error or setting a breakpoint. ALWAYS reset and then edit. - After writing vba, close...
  19. hmlhml

    What is the best approach to archive records (or handle a done status)

    sorry Aceman, haven't been here much and missed your reply until today. I meant things like purchase order or invoice numbers, which people often want to see incrementing in a logical manner, but which also should never be duplicates. I get the impression most people use autonumbers.
  20. hmlhml

    What is the best approach to archive records (or handle a done status)

    thanks... actually on a related issue (that I don't feel is important enough to start a new thread), what's the approved way to deal with the situation where records must be numbered sequentially without duplicates? All the literature on autonumbers stresses that although they are currently...

Part and Inventory Search

Back
Top