Search results

Thank you Pat/DHookom, Given my OP sample, can you please guide me how to accomplish your suggestions? TIA Regards,

Thanks everyone for your feedback. I'll try your suggestions. Can you please share the syntax for both on ‘enter’ & on ‘exit’ and/or before update event? June7 TIA Regards,

Greetings, I've a field called Status with dropdown items (below). I was tasked to hide dropdown items that are no longer in use. Row source: SELECT [tblSTATUS].[STATUSID], [tblSTATUS].[STATDESC] FROM tblSTATUS ORDER BY [STATDESC]; In order to hide the unused dropdown items, I used STATUSID...

Thank you everyone for your input. Yes, frmFinancial is the name of the subform. As per CJ_London’s suggestion, I made the necessary adjustment, and the error seems to go away. Thank you! Regards,

Greetings, On my payment entry form, I've the following buttons: Add to input a new payment, and Edit, to make changes to existing payments. Lately, when users click Add, they receive run-time error '94' and clicking End will exit the database and create a _backup file, when they click Debug...

Greetings, Attachments We have a button on a form when clicked it will take users to the attachments they saved for a particular case. The attachment folder is stored in the agency’s shared drive. Just recently, users reported that when they click on attachment button, they no longer see the...

Thanks everyone for your feedback. I'll follow the suggestions given here and post back the outcome. TIA Regards,

Thanks, I added the trusted location, copy the FE to users desktops, but I get the following error: TIA Regards,

Greetings, I’m using access 365 in be/fe environment. The be is stored in the shared folder and each user has a copy of the fe on the desktop. Following are some issues I recently start experiencing: 1. Everyone can access the copy of the fe on their desktop, but some people experience issues...

isladogs Unfortunately, I tried this in the past and it's a no go. At this point, I think it's best not to delete the Name AutoCorrect Failure table form the dev & production environments to avoid circular reference and/or other errors. I'll keep researching this issue and post back if I find...

Thank you, Yes, I noticed the error after deleting the NameAutocorrect table I brought the idea of uploading a copy of the db to my supervisor and it's a no go. TIA Regards,

Sorry about the confusion. I have three environments: sandbox, dev and production. 1. I deleted this table only in my sandbox environment. And, only in the sandbox environment is where I get 'circular reference error. As per your request here is a sample SQL view: SELECT tblPICTSDATA.PICTSID...

Yes, but not sure how to go about fixing these issues. In my sandbox environment I can not open/edit all queries after I deleted the the name auto correct save failure table due to circular reference caused by 'tblMytableName' TIA Regards,

I didn't make a a backup of the database prior to deleted the table as I did this sandbox environment. I get name auto correct save failure in both development & production, but not yet deleted the table. TIA Regards,

Thanks, ' yes, (screenshot) 2. I'm not familiar with the two forms listed. I even searched in the front end & they do not exist in the DB. 3. After I deleted the Name AutoCorrect Save failure, I attempted to open existing queries and I get "Circular reference caused by 'my table name' TIA...

1. Where exactly can I locate 'links' so I can post a screenshot and answer your question. Is it in the front end? The info in the name autocorrect save failures given were Object Name frmKickOutDB frmMaxCallID Object Type: Form I'm not sure what exactly this means. I assume this is the...

isladogs, thanks. when I click links, what I see is my table names (screenshot) Before I delete, below is the content of the Name AutoCorrect Save

Noted, thanks for the suggestion!

Hi theDBguy, Thanks for the reply, also for the useful resources. So, whenever creating a query and adding tables, is the screenshot in my OP what I expect to see moving forward? TIA Regards,

Greetings, When creating query and attempted to add table, I noticed few changes: 1. One of the tables has a yellow border in the relationship window. I researched online and learned office 365 has a new feature to allow selection of multiple tables 2. . When I right clicked and selected...