Recent content by GBalcom

Thank you CJ_London, Is there any real difference (speed or otherwise) between 64 bit and 32 bit? My programs run fairly well as is, not sure it would be advantageous to switch them unless we're eventually forced to.

Hello, We've been stable on Access 2013 for a long, long time. We are a small business but have many business critical access apps (32 bit), that I've made, heavy in VBA, and compiled .accde front ends. We use these on our front office machines with MS office, as well as shop machines...

Hello, First off, I'm posting here because this seems to be the most active place on the site for COM knowledge. Please move if needed. In 2019, I had a developer create a .NET dll and .tlb for me that, through COM, allowed me to interact with our google calendar in Access VBA. This has...

Hello, I have a 32bit access application that ties to an external db on our server. Been using this for years on several computers. We just got a new computer, and it has 64bit office. I run it as a .accde, with access 2013 runtime. I'm still getting an ODBC call fail error. Which...

Trying to find and download Bob Larsons Access Front-end Auto-Updating Utility. I can't seem to find the actual link anywhere. Including BTAB's website. Is it still available? Thanks.

I'm creating a new database. To be honest, I've never worked through the best approach to create a great user interface before. I'm looking for ideas on how to best approach it. What you've come to value for end-users when they first open the app, etc. For sake of brevity, let's say I will...

Gentlemen, After being off this project for a while, I was able to get back to it today and with your help, fix this task. Thanks again for your expertise.

DB Guy, Thanks a bunch for taking a look at this. Can you explain step 3 above? How are you grabbing all of those selected, to remove, if after the first one in that group is removed, it is resetting? I also tried this code to remove them, but It runs from front to back of the loop, and...

I have two unbound list boxes. The first one is populated with File names from a given folder. I want to be able to push them to the other list box, using the multi-select, selected property. Then, remove the selected items from the first listbox. The .selected only seems to work on the last...

Haha! I wrote that?!? Seems like a lifetime ago. LOL The funny thing with VBA in the past few years is I always seem to be re-learning it. I'll have to dig in real deep for a few months, then not touch it again for a year or more. Glad it helped you out!!

NauticalGent, Thank you for your feedback. So, I'm guessing that your table for this is in the BE, and you have a record for each user? (So it can hold user-specific settings as well?) This seems like a good option.

What is your preferred method of storing application settings for access? Things like Back end location (so an updated FE knows where to look), User Preferences, and other "global" settings. I'd prefer not to hard code them in VBA, because they may need to change at some point. But that is...

If allowed, please let me take a theoretical spin-off of this. We've already admitted that the proposed idea was a poor one, and other solutions have been given. I use an off the shelf estimating software. Within it, it allows the user to create their own formulas that derive values for the...

Pat, Thank you for your response. I've played around with this some more over the past few days, and I really like the concept you showed in the example. I also see now that adding the ParentRecordID in the Entity table is unnecessary and wasteful. I believe this will be my path forward...

Pat, Thank you again for your efforts. I'm getting closer, but I'm still wrapping my head around it. Right off the bat, you taught me of a new VBA event I've had plenty of opportunities to use, but never knew it existed. The Form_BeforeInsert event. To expand on your idea, would it be...