Search results

The file is still too large to attach. I'll make it available as a download link instead. https://www.gpcdata.com/downloads/SVHSLTFLibrary_Local_AWFTest.zip What you need to know. I originally designed this to work with a cloud-based SQL Server back end, using the Google Books API to retrieve...

For me, it flashes just long enough to see the outline. And does so repeatedly while the cursor is over the control. I thought for a while the control had to have focus also, but further testing proved me wrong.

I'm only removing data, nothing else. It'll be messy, but the data is really not that confidential anyway.

No, but I could try to create a repro with sample data. Gimme a minute.

That didn't help. I completely disabled the image control with no impact. I'm beginning to suspect a corrupt form.

Not really. I replace the subform in the subform control for each menu item and the default subform on open has an image in it, but it is replaced by this subform. However, there may be something in the idea of images. I display an image of the book cover in an image control in the form, if...

I’m modifying an existing Access database for deployment to a non-profit. I decided to add control tip text to text boxes and combo boxes on one form since I don’t know what volunteers might end up using it. I figure it’ll help new volunteers add/update new books. This form displays as a...

One more concurring opinion regarding active execution of any accdb FE or BE from OneDrive, DropBox or similar cloud drives. They are fine for static backups or storage -- as long as that's the only reason an accdb ends up there, and it's not done during use as The_Doc_Man explained. The worst...

No, it was the first one I found in Google, rather than relying on memory. I was wrong anyway. :(

Good point. I should not have copied the reference without double-checking that.

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.