Search results for query: *

Being a OCD Access developer, I would give C5 a descriptive range name and then use the name in the VBA.

OzFoxy’s reply is probably spot on unless the last field is numeric. The code would be: AND [Inv_Pman_Lan_ID_WorkAt_Link] = " & Me.cbo_Landlord_Select

DoCmd.OpenForm always opens a new form, not a subform on a main form. I’m not familiar with “navigation tab subform”. Is there actually a tab control on your form?

If I understand, you want to set the SourceObject of the subform control.

Could you share your table structures? Do you have a table with multiple true/false fields for checks? If so, this would be “committing spreadsheet”. We need more clarifications. Typically records aren’t deleted, they are simply filtered out of forms and reports.

TN94z, Do you mind sharing this screen shot from your Preferences?

The image I posted was a hierarchical breadcrumb

Bread crumb

Try this article.

Office 2000 is about 25 years old. Have you considered upgrading? If you (or someone else) opens the file in a later version does the problem still exist? I’m not sure what you mean by “sheet numbers”. Are these the names on the tabs? Can you paste a screen shot in a reply?

There is an advisory forum of long-time Tek-Tips users who are expressing concerns and suggestions to those who administer the site. Several of the members in the advisory forum are in this thread. You can probably figure out who these members are by hovering over their login/image to see the...

I like the new format and getting notified regarding new posts in forums I’m interested in. Almost everything can be changed in your preferences. One great new feature is the email notifications provide the text of the reply so I don’t have to open the thread to read the post. This is a big...

Many of your filenames in your table have trailing spaces.

Have you attempted to troubleshoot by writing similar code that sets the picture of a single command button with hard coded values? Isolating bit by bit is a great troubleshooting method. Don't add any complexity until you have success with the previous step.

Can you give us some information regarding your table(s)? Are you updating a single long text field in a single record or adding a record with each note? Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

My WAG is a network issue but that’s a common excuse for us Access developers. Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

Sometimes a field value (typically long text) might contain junk. This could have caused by a bad network connection. I would create a query to return the first thousand records and scroll through them. Do the same for the next group and repeat. The bad record(s) are easily seen. It might be...

I got nothing. When I have had corruption in tables, about the only way to find the issue is to browse through datasheet views. Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

Any other databases with the same errors? There could be a corruption in the Access database possibly within a table. Duane Minnesota Hook'D on Access MS Access MVP 2001-2016

Your settings match mine so I doubt that is the issue. It may be the Windows update. I would try to find a PC without the update to test. The other possible solution is to roll back the update. One of the best sources for finding bugs with updates is [link...