Recent content by InyoTom

Actually, I am working in the CorelDraw flavor of VB, which claims to be version 6.3. (Usually I am working in good old MS Access.) I can't imagine MS would remove array support for class modules when selling VB to Corel. Perhaps my problem is syntax, but VB's explanations when it complains...

Works like a charm. Not in a hundred years would I have figured it out on my own. Thanks, Rick. Tell your boss I approve your raise. ... Tom Budlong Tom Budlong TomBudlong@Adelphia.net

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

By gar that might do it. Good detective work to find this hidden in the bowels of Access Help. Thanks... Tom Budlong TomBudlong@Adelphia.net

Problem is that the click event for the command button is not executed until the loop is complete. The loop hogs all processing, it seems. Tom Budlong TomBudlong@Adelphia.net

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

I could certainly isolate adding records to one place. Then the risk reduces to making sure the code adds idnetical data to both tables, (and power doesn't go off at the wrong time.) But I like your suggestion of duplicating only the relationed fields - in this case there are two - the Company...

Scary, yes, but I would try it on some test tables before exposing the app to such risk. "Need" for >32 indexes devolves into two questions: 1) Theoretical: How to have >32 indexes, independent of cause? 2) Practical: My app - does it need >32 indexes? The home field is the...

Frink, thanks for your interest. I think you have the germ of a solution. I will try relationing all fields in the table to an identical parallel table, with cascade update and cascade delete set for all the relations. That should keep the two in sync. Fun and games. Tom Budlong...

Inefficient design is a continual thought - each time I examine the design it looks OK. It's an accounting app, and the field being relationed is the account number. Lots of other tables use account number, some in several places. An example is the asset ownership table. Fields hold account...

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

Don't want to toggle it off. Want to remove it from the list. Somehow my list is cluttered with a large number of references I will never use. Tom Budlong TomBudlong@Bigfoot.com

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

Just variables. e.g., lngX = 50 lngY = 72 lngX = 41 lngMax = Max(lngX, lngY, lngZ) would return 72. Tom Budlong TomBudlong@Bigfoot.com

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