Search results

Hello again! Nice to be back on the forum. This might be a very simple question but has anyone else noticed in the SQL view that Access is now automatically inserting some indentation and line breaks. I was curious if there's a way to disable this. I didn't see anything in the Options->Object...

Hi everyone, I just wrote some code to properly delete one of my data types from the database I'm working on. I originally came up with the need for it when I realized that when a record from this particular table (the "Links" table) gets deleted, the code should also check for records...

Hi everyone, I learned that I can use two methods to access controls on other forms from outside their respective modules. I was curious if one or the other is considered best practice so I decided to pick the brains of the community here. I should preface that with either approach, I always...

Hi everyone, I have more of a theoretical question today, I'm mostly looking for inspiration on how I might be able to take advantage of the OOP paradigm in the application I'm working on. I guess the general and very open ended question I have is this: "Can I have some examples from fellow...

Hi Everyone, I wanted to pick your brains if you don't mind on an issue I'm having with one of my forms. A key characteristic of the form I'm creating is that it will conditionally show / hide / resize / relabel columns based on data that gets passed to one of it's subroutines. Any help or...

Hi all, I was wondering if I could get some of your opinions on whether explicit memory management in VBA code is a good practice / necessary in modern day VBA. Here's my current understanding, please correct me where I'm wrong. When an object, such as a recordset, goes out of scope, that is...

I've been coding in python for awhile and discovered semi-recently that you can use python in Excel. Not to the extent of VBA, which has the ability to run code with side effects that can modify the spreadsheet, but anything formulas are capable of doing, Excel's python feature is also capable...

Hi there, I wanted to ask this question because I was curious if this is possible for both listboxes and full on continuous forms The thought of how this might be useful came up when I wrote some code to add a new row to a continuous form. Of course, by "adding a new row", I mean add a new...

Hi everyone, My name's Jonathon. Feel free to refer to me as that, Johnny, or SPARKLY SPARTAN, whichever feels the most natural ;D I've been programming solutions in VBA for the office suite for a bit, not as long as most people on here, though. I've become in charge of my company's MS Access...