Search results

Isladogs, Saw your post this morning. Cannot say I fully understand why, but your corrections work perfectly! Appreciate all your help and suggestions. Many Thanks, Dave S

ISLADOGS, I, too, began to see other errors like you describe after adding the "Option Explicit" to each module. They were not consistant, rather hit and miss. Dave S. P.S. HAVE KEPT A COPY OF THE DATABASE BEFORE MAKING ANY COMPILE CORRECTIONS OR ADDING THE EXPLICIT OPTION. WILL TRY TO SEE...

Isladogs, Attached is a screenshot of the error. Thanks in advance, Dave S.

Isladogs, Almost forgot . . . Database opens to a main menu. Select the Daily Staff Update Button Use any date older then 3/21/19.

Isladogs, 1) Set the Require Variable Declaration Option 2) Added Option Explicit to each module No Change . . . Have attached a Zip'd copy of the database. Set a breakpoint where the code fails in Windows 7. After all recommended changes, code still runs perfectly on W10 but fails on W7...

Hi Isladogs, Corrected all the Compile Errors. Primarily all were instances of where I had copied a form and modified it for another purpose. There were apx. 5-6 instances where an On_Click command was trying to set an undefined control field. Cleared all errors, however, the original...

I'm coming across some Compile Errors. Will be addressing them. Had to take a break and go to work, sadly. Will get back with results ASAP. Thanks :)

No MISSING References ]

I'm not sure of what you mean by "Missing References". I took a copy of the database from my Windows 10 machine and placed it on my Windows 7 machine via a USB drive.

In all cases, we are using copies of the same database. All single user and single machines.

On my Windows 10 machine is where I do development work. The database works perfectly there. I emailed a copy to the end user running Windows 7, single machine, single user. There is where the error first became apparent. Moved the database to my Windows 7 machine via USB drive. Getting the...

Make that the "rst.Edit" command.

JHB, Ran into a problem. Your code runs fine on Windows 10. The rend user runs Windows 7. On their and my Windows 7 machines I get an error 3197 (multiple users trying to updated record) at the "rat.Edit" command. Any thoughts"

JHB, I'd say good morning but I believe it's afternoon where you are. Your solution looks great. It is going to take a while for me to digest and fully understand how you did it but I'm looking forward to every minute of it. From a BRIEF review I can see you built a Table, assigning a...

Thank you, Dave :)

Again, thanks for your help JHB. Have attached a ZIP'd copy of the database. Auto-opens to a Main Menu Form Select "Daily Staff Update" button Set date for 2/1/2019 The report that will be launched is: MDOut subreportA-NU Thanks in advance :)

Hi JHB & Isladogs, and thank you for your replies. I sort of came to the same conclusion yesterday but was unsuccessful in getting the desired result. Attempted to use Me.Detail.Height = 5000. Seems to adjust the individual record height instead of the Detail Section height. Any suggestions?

I have created a report that has 50+/- entries in the DETAIL Section and some count statistics in the Report Footer. It is a 3 column report. My issue is when I use the "across-then-down" method of distribution the report looks fine. (see Capture1) When I use the "down-then-across"...

Hi All, I am a moderately experienced Access Programmer, living in Delray Beach, Florida. Dave