Search results

Hi, What I'm puzzled by is that the form main menu has few other forms that open via an option buttons. Except for the case entry form, all other forms open without any problems. I can try importing the frmMenu from another FE to see if that resolves the issue. TIA Regards,

Hi Thank you everyone for your inputs. After IT department installed what was reporting missing msjtes40.dll, I’m now able to run existing queries and generate a new one. I no longer receive Record is deleted. (Error 3176) error. I can also access the BE tables without any error as well...

Thanks for your feedback and confirmation. I'll share my plans to the management and proceed with the feedbacks I got from the forum. Regards,

Thank you for the detailed best practice. I use this as a very good resource. possibly save it on external HD incase the data is requested for auditing purposes (very unlikely) and/or to see the historical data etc. To identify what to archive, we have a Case#, Assign date, status with...

Hi, attached... The_Doc_Man, glad you brought the topic of archiving as I was recently tasked to archive old data (2019 and older cases). Since I didn't do any archiving in the past, I was looking for some guidance: how to go about implementing archiving, best practice etc. Copy/paste both...

Thanks everybody for your feedbacks. I’m not using it and I’m not sure how it appears in the list to begin with. Now you mentioned it, I might have missed the last step: Debug > Compile from the VBE menu to check if the project now compiles without error. I’ll do so when I get back to work in a...

Hi I’m currently running office 365 a split access db. Few users to including myself recently received the following error: Your database or project contains a missing or broken reference to the file ‘msjtes40.dll’ version 4.0. To ensure that your database or project works properly, you must...

Gasman thanks. The name of my table/form actually is Financial. I think DHookom used Northwind Employees as an example. But, to answer your question yes, I see the data in qryFinancial Users input the data via form financial. I also entered the data in the backend. No, I did not. I'm not...

Ken, Thanks, I sure will check and post back the result. Regards,

Ken, Thank you very much! Regards,

Thank you for your feedbacks. The form itself is not new. I just added few fields to an existing form that was working fine. However, the record added to the new fields, are not visible. But, when I run queries, I can see the newly added data on the result. I’ll check what you suggested when I...

Hi, Thank you all for your feedback. If I understand it correctly, I have to start from scratch and create the "outcome' table, correct? Also, if I had to use options button or check box for Outcome, do I still need to create the Outcome table? how do I go about accomplishing this? TIA Regards

Hi, I created few new fields and change the labels for some of the existing fields. When I access the back end, I can see records users already inputted. When I create a query, I can see the data that was entered. But, for some reason it is invisible on the form ie. the form shows blank...

Hi, I created a new dropdown field called outcome which includes two choice items. When attempting to select one of them, I received “The value you entered isn’t valid for this field” error. Attached is my design screenshot. Do I need to define my field outcome as a text data type? TIA Regards,

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...