Search results

Do you have 32 bit Access installed or 64 bit Access?

That's exactly what I want the user to see. It starts with an AutoExec macro that runs InitVars. The last line of code in InitVars opens the menu form. DoCmd.OpenForm FormName:="frm_Main_Menu" And it also works correctly for me on my 64 bit installation! Now, I'm totally puzzled, unless...

Thank you.

Thank you.

One other note. Midway through setting up the original version I changed "genre" to "category" and "creator" to "author", but I did not revise the underlying tables to match the interface. Too much work.

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.