Search results

Late binding of me! does work in this case. It does resolve the new field. However, it would be much nicer if there was a way to force the compiler to re-evaluate the bindings of me. Decompiling didn't help.

This is curious. When is me. computed and is it ever re-computed? The question arises because I find that if I add a field to my table after the VB module has been created the VB compiler doesn't seem to notice that there is a new field. In the attached file the one table has two fields cia and...

No that works for getting the state of the buttonAnd like I asked earlier, which I don't understand your response, are you saying using Me.OptionButtonName didn't work? That works for getting the state of the button. My question was how to access an unbound field to assign a value. My real...

I am trying to use a group of optionbuttons to set individual bits of a mask. The buttons are not grouped in an optiongroup because I want them to operate independently rather than as radio buttons. The buttons are unbound because I want to control their appearance based on a single bit rather...

Thanks, I'll try that.

forms!myform!field works but isn't there some way to do this relative to me. that would be simpler? I have yet to really understand what me. entails and what it does not. Hank

Vlad, Getting Access to enforce referential integrity was pretty easy. It was just a matter of defining a many to many relation between the tables and requesting referential integrity. However, once that is done it will raise a runtime error if the user actually tries to add a duplicate...

I think I have found the fix. In the subform on current event handler the AssetID.RowSource property needs to be set to "qryNewAssetCurrentVulnerability for all records, not only new records. This will prevent a user from going to a previously set record and choosing a duplicate asset. But it...

Vlad, The referential integrity problem does not happen when the junction table fields are initially created but can occur if you change the value of a previously set record. Still this is a big step forward in my understanding. I am studying your queries very carefully.

Vlad, Thanks for looking at this. Your example doesn't exactly achieve what I want. I want to have a many to many relation defined between the assets assets_vulnerabilities and vulnerabilities tables and to force referential integrity. This means that a particular asset can only be assigned...

Actually it didn't really work. No syntax errors and it did generate a table but the table was simply the cross product of the Assets and Vulnerabilities tables. This was the same for both quereys. Maybe I wasn't clear about this. I need a list of assets for which there is no existing row in...

Easy to blame the workers. But it would be better to ask who hired them, what qualifications were they looking for, how much training were they given, and how much were you willing to pay.

Interesting. My first programming language was FORTRAN, followed by Basic, Cobol, assembly language, and Pascal. My computing mentor at the time said of Pascal, "It will help when you learn C." It helped even more when I learned Java. Basic was an innocent little thing back then when nobody...

Thank you, thank you, thank you. Looks like I mistook the dash which is on the = key for the underscore. Weird two finger typo. It's working now.

arnelgp, I am immensely thankful for your help. I thought this would be a one-liner. Looking at your answer I realize that the question was hopeless for a newbie like myself. I created the first query without a problem. [Actual field names from my tables] saved as qryAssetVuln SELECT...

I think I know what I need but i don't know enough SQL to write it. I have a many to many relationship between assets and vulnerabilities (and a bunch more but one is sufficient) and a junction table assets_vulnerabilities. A vulnerability may apply to multiple assets and an asset can have...

Hello, My name is Hank Cohen, I have worked all my life in computing, compilers, real-time systems, data acquisition & signal processing, network security, security protocols, crypto devices. Over 35 years of it but never until just recently did I ever do any relational database programming...