Search results

The conditional compiler directives are there to ensure the code works correctly on different versions of Windows and Access. The #If Win64 compiler directive is used to conditionally compile code that should only be included when the target platform is 64-bit Windows. Inasmuch as 32 bit...

My sister-in-law loves to tell a story about some of her 20-something students. She was running a lab of some sort at a community college, where they had to use a PC to log in and complete an assignment. Several of the students begged her to let them use their phones to do the assignment...

At the risk of offending some of my fellow developers, th While I agree with 99% of what you say, Pat, I tend to disagree about using a tablet. It's sort of like getting used to using a smart phone to send texts. Sooner or later, one can become proficient using the on-screen keyboard to type...

I keep telling myself, Edison claimed to have failed dozens of times before he got the light bulb right.

A potential problem in that scenario would be unhandled errors crashing the database. So, it needs to be rock-solid, but otherwise it's a good plan.

Yes, ChatGPT5 is a dud, in comparison to its predecessors. Yet, there is an interesting aspect of this flop that I find encouraging. To wit: Using an AI LLM is a multi-step process, not a single-step task. Like many of my acquaintences, I early on made the mistake of judging the potential of...

What does the newly acquired company have in place? Is it reasonable to evaluate adopting it? Let's not rule out anything at this stage. I don't think you would end up doing that, but it's probably wise to at least look at it to see what ideas you could leverage if you have to integrate systems...

Not having looked at the attached accdb, but basing this comment on what others have said, you can start to correct the problem by learning about the process of normalization. Here is one excellent starting point: Roger's Access Blog on correcting repeating columns Here's a link to a YouTube...

Ah, a non-profit animal shelter? That does influence things. My basic cost for a full SQL Azure database at the lowest cost tier is ~$6.00 (US) a month, so there's that option if they can afford $75.00 (US) a year.

It's almost like there is a correlation between people not willing to have their own kids also not being willing to foster other kids.

I gave up on that free tier after the first day, for exactly this reason. The only value it has, IMO, would be as a testing environment for non-production applications. "The function doesn't exit until it gets a connection or the number of tries is exhausted (say up to 75 secs)." Making users...

Also, it might make a difference to know which version and build of Word you have installed.

What symptoms are exhibited? Obviously incorrect spelling not identified? Correct spelling flagged? Nothing at all?

That looks to me like it might be related to monitor size and resolution, then. Check out Colin's Form Resizer.

My goodness. We've been begging for better ODBC connection handling for 10 years now.

https://en.wikipedia.org/wiki/Vibe_coding

Technically correct, but beside the point. As noted, "The differences are the behavior and nature of the objects being referenced. " The point is to provide sufficient context to the prompt so that answers will should be pertinent to the task at hand. In this case, the context is an Access...

Another prompt I've heard about, but not yet had a chance to try is along the lines of. "You've been hired as the senior developer on an Access VBA project. Use your most advanced VBA skills to solve the following problems/address the following requirements/create the following solution."

I agree. The obsession of running in a browser is, in my opinion, somewhat of a side issue. That focus remains on an either/or choice and that is a false choice. Back in 2008 or 2009, I was part of a development team. We were a couple of Access developers and a web developer. I created the...

Please clarify. Is it the case that you actually have two different "Codes"? That is what this paragraph suggests. "...the item code is a hardcode[d] id from the factory itself..." "...the serial unique id case comes up only when stock is added to the shelve.." Please confirm: Is there a...