Search results

So the two functions I posted allows us to set or create a property in a remote database, and read it back. However that is only working with properties belonging to the remote database itself, not any of it's objects such as forms, recordsets, queries etc. I will give 10 CC Bucks to the first...

I was going through C2DbProperties testing it before the demo next week and ran into this exact issue. The AllowBypassKey and allowBreakIntoCode were not there and my code couldn't modify them - just set the value. It could modify all the others. It turned out that the properties did not...

Hmmmm I wonder if one can add a property to a command button to give it a raised / sunken outline. Things like a combo or text box have a special effect property which can have the values flat, raised, sunken etc. A button doesn't have that. Not sure if that would have any value, just idle...

Go to the debug window and enter: ?ccSetCustomProperty ("d:\dev-access\CruiseAmericaSales.accdb", "CC CopyRight", dbText, "© Colby Consulting 2025" ) -1 ?ccGetCustomProperty ("d:\dev-access\CruiseAmericaSales.accdb","CC CopyRight") © Colby Consulting 2025 Thank you @Edgar_ ! So far you are...

No, I meant something more like this: ' 'Comments : SETS A CUSTOM (USER DEFINED) PROPERTY FOR A GIVEN DATABASE ' CREATES THE PROPERTY IF IT DOESN'T EXIST 'Parameters: strDBName IS A STRING CONTAINING THE FULL PATH TO THE DATABASE ' strPropName - THE NAME OF THE...

Boy did this thread go sideways in a hurry. :D ;)

AWF's "Ignore List Poster Boy"? :ROFLMAO:

It is compiled to an DE, code stripped out. So it's doubtful you can do anything other than use it.

Having moved it to a trusted location, opened it in C2DbProperties, set all of those properties etc, I can now open the file. It was written by That'll Do It - Custom Database Solutions By Crystal And Crew A link to their website is broken, seems to be down. When I tried to open their code...

OTOH C2DbProperties can open it and see all of the properties I have been discussing. Let me ask ChatGPT if that "file source" property can be found and reset

LOL, I can't even open it because Access displays "unsafe source crapolla" and refuses to even allow it to open. It claims only disabling the macros but only cancel is available and that shuts the whole thing back down

One can only take oneself so seriously.

With exuberance!?!?!

LOL, @jdraw were you giving a thumbs up to "old and foolish"? :ROFLMAO:

It turns out that you can intentionally "fill in the holes" in a table with an autonumbered field (caused by deleted records) by creating a query which appends a single record into that hole. Once you do so autonumber picks up, takes over and starts autonumbering from that number you appended...

Ages ago I wrote a little tool - C2DbProperties - to allow me to modify database properties. C2DbProperties The objective was the ability to open any "remote" non password protected database from my C2DbProperties tool, and set and reset the database properties most often troublesome to...

Sorry George, I just thought I'd drum up attendance. Not my Bailiwick of course.

I will be presenting at the Pacific Access User's Group Thursday 6/5/2025 at 9:30 PM EST. It will likely be short though with this group you never know. My presentation will be demonstrating C2DbProperties. Access User's group Pacific presentation re C2DbProperties Access User's Group main...

In fact this is somewhat true. Indexes on the field, speed of queries, Joins etc. Although I was under the impression that booleans were bitmapped behind the scenes. Not sure about that.

That is the most code I have ever seen for a pseudo example. Good Job! :ROFLMAO: