Search results

"Namespace" is reserved in VB.NET but is not documented as such in VBA, as far as I can tell. VBA bucks a bit when I attempt a "Public Property Get Namespace()" but seems to take the bit after compiling, saving, and cycling the app a few times. Lest I court disaster and before I go too far...

I departed A2007 at long last and now, on A2019, find that my apps' record selector backgrounds, scroll bar backgrounds, and scroll bar thumbs all are solid black. I've been rooting around fiddling with Windows, Office, and document themes and sundry registry settings, with no effect and Google...

In the realm of stupid questions, but I've not had to do this before and my Google-Fu has failed me: Which, if any, event occurs when one double-clicks on a TabControl object's tab, perhaps otherwise referred to a Page object's tab? More specifically, on the active tab / tab for the active...

I've been aware for some time that ACE hid a number of objects and members (i.e., properties and methods) that previously had been exposed in JET / DAO 3.6, in the 2003-2007 transition. The Group, Groups, User, and Users objects are hidden altogether, as are properties such as Owner, UserName...

Perhaps this is new, or just new to me, but I just learned that a string that concatenates a Null Variant variable between octothorpes using Null propagation (by use of the + operator) does not return Null but rather the string "Null" (without the quotation marks). This can be handy but I just...

The thread title. Is there a way to maximize a form, meaning a PopUp form in my case but perhaps also a form if in overlapping forms mode, vertically? Put otherwise, is there a way to get or set this window state for such a form? By "vertically," I mean vertically-only, retaining the form's...

This is a new one. I'm encountering the error "You cannot add or change a record because a related record is required in table [X]". The first question is why would this be? In my experience, FK field values are optional, so this comes as a bit of a surprise. The second question is what can...

I've been refactoring a number of projects and migrating generalized code to a library ACCDB over time. It's gone practically without a hitch and many ACCDB projects reference it and instance its classes like a charm. As this refactoring has progressed, I have encountered one difficulty...

This is well and extensively discussed elsewhere but nevertheless all of the posted "solutions" fail and I am unable to programmatically minimize the ribbon but not the menu bar, as one can do by selecting the Menu Bar context menu's "Minimize the Ribbon" item (or pressing Ctrl + F1). To be...

I'm noodling on extending or tweaking the mechanism behind scrolling text in text boxes, to address a form's Detail section, especially while it is in Continuous Forms view. Apparently, Windows regards a TextBox to be a window. As such, it has an hWnd. Dev Ashish's widely circulated code...

This question is either dumb with an obvious answer, or arcane and deeply into the weeds, I'm not certain which, about event progression among forms, subforms, and controls. Of course, I already have made extensive reference to the Access object model and the MS article Order of Events for...

I'm Eric and have been developing in Access for ten years or so internally, and am debating going pro. I'm based just outside San Francisco and balance interests in running, mountaineering, fine cuisine, and shenanigans.