Search results

Gentlemen - I've posted the reduced database to a previous posting on this issue, since it captures the troubleshooting of the vba code. https://www.access-programmers.co.uk/forums/threads/troubleshooting-vba-code.311011/#post-1689065 @MajP I haven't made the adjustments to the FATY observation...

I guess it's somewhere between 3.5 megs and 5.7 megs uncompressed and something less than 2.7 megs zipped up. A technique that I just figured out to reduce the size was deleting the images in the image library. That cut 3 megs out fairly quickly.

Tell the user not just that file is too large to upload but what they need to reduce it to. Maybe even provide some recommendations. And if there is an answer, could someone please tell me???

File Uploaded I realize I'm asking for a lot and some potentially deep researching.... Because of how inter-related my forms are with other elements of the database, I've left in all queries and modules. I've reduced the tables and forms to Navigation and the Contacts form that for some...

There was likely nothing wrong with the starting code. I've removed a subform and the code isn't erroring. I'm likely going to need help troubleshooting this form / subform combo. Working to build a demo database now.

Hold on. F8 is showing the error is happening after the end sub for the field. Need to troubleshoot further. @bob fitz thanks for the reminder to relook at where it breaks.

@Micron Private Sub JobTitle_Exit(Cancel As Integer) Call SpellChecker(Me.JobTitle) End Sub @MajP Code compiles but still provides the 2467 error. Public Function SpellChecker(txt As TextBox) As Boolean On Error GoTo Err_SpellChecker If Trim(txt.value & " ") <> "" Then...

@MajP I get an invalid or unqualified reference on the .SelStart line with your recommended code.

No change. Still errors if there is no text in the field.

I'm trying to find the right combination to get the code to not error when I hit a record that doesn't have text within it. Error 2427, You entered an expression that has no value. I've commented out all of my failures below the with txt. Public Function SpellChecker(txt As TextBox) As...

Big observation..... When I converted the linked SharePoint lists to a local file, closed and reopened the database, the problem stopped. This is with the original vba code. This database started on SharePoint and the issue started a couple of months ago. Unfortunately I don't remember what...

I'm down to only 2 forms. The Splash Screen and Navigation form. I just removed all of the code from the Navigation form and even then after it opened, it immediately hid behind the Access program window. I've noticed that I can't get this behavior to happen once the database is opened up...

Trying to narrow what needs to be in the demo.

Is there a code that can pull a form into the foreground? For some reason, I'm getting the following behavior. To my knowledge as the person that programmed this beast, I didn't intentionally do this. Maybe my sequencing is off. The issue: When my Navigation form opens initially, it...

Acknowledge. Going to save a new copy of the database and start the elimination process.

Still troubleshooting. Some of my notes. 1st part is about the IsBlank. 2nd issue is why an extra object is opening (haven't started to narrow down this one) 1st: Issue (Why is isblank occurring?) Subforms open before the main form. Also looks like they open in the sequence of the tabs on...

But the subform that gets opened up first does have less.

I use the fosusername to find the user's pictures folder, where I dump a pictures library for their local computer. Only one of the subforms appears to fire, apparently on the FAYT code. All of the other subforms, which also have different FAYT code, dont appear to fire. Will continue...

There are multiple subform on the main form. Not sure why the first one only gets opened, in the flow. If there was code causing it, wouldn't the F8 step have caught it? I tried earlier today to reduce the Db to its essentials to try and narrow down the issues. I'll work on it tmrw.

The form's query has over 700 people in it. I am using fosusername in the query though. There aren't any filters or criteria though opening it up.