Search results

In the database / info tab, off to the right is a link labeled View and edit database properties. A neat little tool for what it is. Click it and then click Custom In the db I am working in a ton of custom properties are displayed, none of which are populated. But you can click one of them...

We need the table name optional so that if it isn't there we just use the db properties. But with a little work we should be able to pass in something that says what kind of option it is. Or set up a new function to do things other than db properties. A function just for tables, another just...

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