Search results

Upon searching, I see a lot of people have problems with currency and formatting. But I didn't see this one. Maybe my friends across the pond have dealt with different currency formats? I have a currency field that is always positive, always has four decimal places to show. No commas or currency...

Okay, I've been warned to link to cross posting and here is the one I just made with Richard Rost's site: Sequential Annual Coding in Microsoft Access (599cd.com) I don't think it will get answered anytime soon, I was mostly responding to one of his videos. I won't repeat what I wrote there...

This one's been bugging me for a few weeks now, and I haven't gotten an answer on two other forums. I'm in a form on a record. I programmatically copy that record to a new record. After doing that I know the ID of the new record. How can I "move" to that new record in the same open form with VBA ?

I'm still in development and adding and modifying tables (and table names when needed) every day. The test data for geography is starting to get big. I've heard several people say that I need to split the database. I get it. My question is, is this advisable while still in heavy development...

I've got a TableA with lots of fields. Some are basic information and go into FormA. FormA has a command button that calls FormB that also uses TableA. This is more specific data that is optional for certain types of clients. I'm trying to keep my forms short/simple, so each form works with a...

Newbie (again) to Access VBA and I am working on my template for forms. Since I don't want to repeat code in each class module, I try to move as much common code to a general purpose "form module". This often causes me headaches, not knowing exactly/properly what to pass to the generalized form...

I'm working my way through an old printed M$ manual on programming. It has some good examples. However some just don't work. Like this one: (I triple checked that I typed it in exactly as the manual says) I'm guessing that things have changed since M$ wrote the manual. Can anyone give me a...

When searching for variables (or other) in a VBA project, the search box sits in the top left corner. While there, it covers up important information in the title bar. I can move it down to the bottom right, but after the next or replace it snaps back up to the top left. Does anyone know how to...

Isn't there an easy keystroke way to move to another open window when using overlapping Windows? I've searched all over, and tried everything I can think of.

The last 24 hours have been hell day with Access 2021. I had burps, crashes, and contaminated data and tables, queries and forms. In multiple dbs. It all reminds me of my first experience with Access almost thirty years ago, when I first walked away from it. Maybe I'm doing things all wrong...

Here’s my first post to this forum, and it’s going to be a doozy. I’m coming from a mini/mainframe environment, where things weren’t normalized very well. But as I go down the rabbit hole of Access, I wonder which of two approaches might be best for flexibility and usability. I’ve created these...

Hello, I'm Thomas (but here in Colombia, Tomás). Professionally I was known by T. Wade. I started programming in Assembly and Fortran in university in the 1970s and got addicted. My degree was in business and accounting. I grew up in Santa Barbara, California. I spent a lot of time trying to...