Recent content by pondside

Dalain, Your words to the original problem described here months ago, prompted me then to take evasive action along the lines you suggested, and I eventually found a dodge changing one of the footers to get around the difficulty without ever figuring out the cause. In the last week it...

Yes, thanks for your reply. I am in fact running the database on Pondside computer, and I have no other databases. Your question helped, by prompting me to look at other possibilities, and as I looked, I noticed an inconsistency within my code that seems to have triggered the error. I was...

I just executed some new vba code, that somehow caused my database to freeze up. the full text of the message is: Runtime error 80004005... The database has been placed in a state by user ‘Admin’ on machine “Pondside” that prevents it from being opened or locked. The relevant...

I have a problem on tabbed forms, where some controls "bleed through" to appear on every page of the form, while others do not. It seems that unbound controls are particularly prone to this. In some instances I would like certain controls to be available on each tabbed page, but in...

MPH1: Your clue about the form corruption led me to the culprit. My main form had several subforms, so creating a new form was not a viable option. However, your suggestion of new imports was an excellent idea. Fortunately, I make copies of the database up to 5 or 6 times a day, so I...

MPH1: Thanks! I'll try what you suggest, and let you know the outcome.... Pondside

I have a tabbed form that has suddenly developed a new glitch when I use the Access-provided navigation buttons. Whether I move forwards or backwards by record using the buttons, I get a message: "The value you entered is not valid for this field." The subtext of the message box...

Dean, Thanks, I found I had to modify the first statement, dropping the "Form.", but it works great, and it's a relief to find an answer I couldn't find in any of my Access books. [smile2][smile2] Forms![frmFin18!FetchSem1.SetFocus Forms![frmFin18!FetchSem1.Form!Sem1Paid.SetFocus

I have a situation where I need to navigate upwards from one of 4 tabbed subforms to accomplish certain tasks in the parent form. This I can do via setfocus from the current subform event procedure. But when I attempt to use a setfocus method back to a specific control in the subform...

Thanks to both of you for your responses... they helped me think of some new approaches, and I have discovered that the sticking point is connected to the Report's sorting and grouping box. I use sort strings built into the SQL Select string placed in the Report's RecordSource. These work...

I have been putting together a set of reports that are driven by sql-driven logic composed within a form-based module. Some recent change in my logic has triggered the 3270 "Property Not Found Error" when the report is opened for preview with the following line: DoCmd.OpenReport...