Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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