Recent content by tuna

How is numeric data stored in variant data types? It seems that numbers in variant data types don't respond well to high-precision calculations. I had the calculation (data types as in the names): dblX = varY - dblZand I had a case when: varY = 0 dblZ = 0.0000000121But dblX returned 0, not...

Hi, is there any way to cancel navigation to a different record? I want to make sure that a subform has exactly one record before allowing the user to move away from the current record or close the form, and cancel the close/navigation if necessary. The close event was easy enough, but I can't...

I'm trying to run the following SQL (PropertyID is Double, TimeStamp is Date/Time) but the TimeStamp part is causing a syntax error (Runtime error 3134) - am I missing something? DoCmd.RunSQL "INSERT INTO tblProperties (PropertyID, TimeStamp) VALUES (1, #07/08/2010 06:37:43#)"I've also tried...

Hi, I want to write a sub to duplicate a record in any table, i.e., the only parameters are the table name and sql criteria like so: DuplicateFunc(strTableName As String, strSQLCriteria As String). I've started by using "INSERT INTO" statements but that requires knowing the number of fields of...

Thanks for your responses - I'll have a good think about your suggestions and get back to you. But the first question that pops up is what about different data types? You both suggest methods that tries to avoid the creation of new fields (or tables) for new types of properties, but what if I...

I have a lot of structures in my database like so: Consider inventory - I might have stocks of balloons, for which I need to record colour, or I might have stocks of cars for which I need to record their registration plate numbers, and so on. The point is, I will need to record different...

Hi, anyone else notice that if you type "p" on a new line, VBE capitalises the first letter? Any way to switch this off? Thanks

Thanks - I mean in all events that originate from the datasheet part of the split form fails to retain module-wide variables - i.e. if I have a hyperlink set on field Field1, something simple like this would fail to give the desired result: Option Compare Database Option Explicit Private...

Hi, is anyone else finding that form variables don't retain their value in split form mode? Is there anything that can be done? Thanks.

Hi, I've got an object (called "Super" below) declared as private in a form class ("Form_frmMyForm"). However, it doesn't seem to retain its value after the Form_Open. In the VBE Watch window the value of the object (Super) is marked "<Out of context>" immediately after the Form_Open...

Well, I just wanted to get a little more info on exactly how to implement inheritance. My problem, so to say, is that I would like to create a subclass of forms with specialized methods and I would also like to extend the original forms class to include my own additional methods that apply to...

Hmm that's what I thought but I got wind you could spoof inheritance with it - forget that then. But is there any other way to simulate inheritance? What's the best option in your opinion? Thanks very much

Hi, I've recently read that you can fake class inheritance by using the "implements" keyword. How can this be done? A very quick example would be helpful. Thanks

Given that all form modules are class modules, is a Class_Initialize sub valid? Or does the on open event have exactly the same effect? Thanks

VBA equivalent of regex match Hi, is there any function that can find a string and return the match while also supporting the use of wildcards in the needle expression? e.g. for such a function named StrMatch, StrMatch("Haystack", "s*") would return "stack" Thanks