Search results

Yesy it's back to basic methods :banghead: ... and I have tried but I'll do it again ! Merry Xmas and Happy New Year ! Now it's homeward !

>> gasman and arnelgp Yes, it's all there ... that's the way I inserted the breakpoint :banghead:... but it DOESN'T stop here when I click the checkbox. (BTW: I still works on the other tabs !)

I have some tabs in a form and on more of these tabs I have a checkbox for setting a file reference to PRIVATE or NOT - it works well ! I got it to work on ONE tab and just copied the control and the underlaying code to the other tabs. Today I added a new tab and has done the same...

I found out constants CAN'T be multidimensional, so I'll just have to have it as a global variable instead - and I HAVE that running :) As with the other solutions I have to remember to initialize ... I thought I could shortcut here with a const ... but no :banghead:

Bacause I want it as a const

I would like to declare a multidimensional const of 11 pairs of 2 strings, but oh it hurt to find out how ! I can get this to work: Dim MainFolders As String MainFolders = [{"BILLEDE","IMG_files"; "BO_KOMMENTAR","BO_docs"; "DELTOG_I","GUEST_docs"; "GENST_KOMMENTAR","GENST_docs"...

Yeah, I've have often used that too, but in this case it's more complicated because it's in a continues form and there you can't just hide/show controls :banghead: the changes will affect ALL records in the form ! I think my demo is a good generel solution but NOT for continues forms - in such...

It's DANISH and just a warning to the user IF he makes it private he HAS TO KNOW the password if he later wants to see the data OR make them UN-private again. I think my solution is "straight for everyone to figure out" in the future when my grand-grand-son maybe wants to change something in...

I didn't get you on that idea and I now have a test solution that's "by the book" - at least, I think :) You can change the "Password idea" in the Sub getAdgangskode() See the attached file ... let me hear your comments :o

I've tried that, but it's the same problem ... the Value has changed the moment you click the checkbox ... again you have to look at Oldvalue to see what the state was BEFORE you clicked the checkbox.

The solution is to use the OldValue property :p Then you can check in the clickevent if the checkbox was checked or not BEFORE you clicked it ! I wasn't aware of this property - soeey ! :banghead:

I use it in a genealogic system where the private data should by hidden if someone is looking over my shoulders :D

I don't think it's answers my question on how to check the state of the checkbox in the mothods for that checkbox. Even in the BeforeUpdate the state is CHECKED if it was UN-checked when I clicked it . .. and visa versa. :banghead:Shouldn't the state be UN-checked ?

I have a checkbox to make some of the data on my records private. When that checkbox is checked I hide the private data and shows a button to access these data IF a password is correct. BUT ... I too need to be able to UN-privatize the data again by UN-checking the checkbox BUT ONLY if the...

DOOO ... how simple can it be - THX !

:confused::confused::confused: I can't even Google anything on "Excel FuncName()" ? :confused: Do you have a link to some sample code ?

I can run an Excel-function, placeEvent, from within Access by: xlApp.Application.Run "placeEvent", ... function arguments given here .... but how can I get the value returned by the Excel-function ? :confused:

OK, I'll look into that - thx !

I have it to work now ... but I think the table is not needed ... but I'm wrong :banghead: I'll have to live with that, I think

I have made an SQL-string from a query and I have to change the criterias for different fields from user input in a form. I can't just - in the query - reference the criterias directly in the form because the way they are given there ... I have to manipulate them into a string and incorporate...