Search results

this code copied from the Microsoft support page itself since I am not a coder. your solution may work but difficult for me to implement and maintain. any other thoughts?

this works. however, ignoring all other errors and also need to be inserted in all other forms - don't know any user leaving which form before inactivity. Almost near to the solution, little more to reach.

Cancelling Update may undo the change done even though if all fields are filled. If all mandatory fields are completed it should not be undone, only if something left blank. Please help. Thank you.

Inactive timer trying to quit the access app. However, the bound form has some fields left incomplete are set to "required". This prompts the message "You can't save this record at this time" which requires user input to click yes or not; until then the app is not closed which goes against...

"Option Explicit" solved this problem.

Thanks for everyone for the reply. Option Explicit solved the problem. Initially it was not resolved but when I tried today with "Option Explicit" working fine as excepted in both accdb and accde file in different machines as well.

Thanks for your response. It successfully compiled. Below is the function and what I am trying to get. Public Function GetUserName() GetUserName = Environ("UserName") End Function and below two items are in two unbound text boxes in the form. tried below argument in default value and...

Yes, I did without encountering any error.

Have two unbound text boxes in a form. Pull the data from a table and filter (using dlookup) based on GetUserName function which I created. The result displayed properly in the accdb file but while in accde file it displays #Name? error. Have to distribute exe file since multiuser environment...

Thanks Doc, the blank date was the problem. managed to fill it up with dummy date.

thanks for the response. Yes, there are blank fields since it will be until someone edits the record via the form. You are right, I tried deleting the blank records and date filter works. However, is there any other way than deleting to make this work? blank fields are required to be there.

Having a field set as Date/Time and data recorded via Form using Now(); all works fine. When I open the table for some purpose and apply the date filter (yesterday, today last month alike), get the error message "Data Type Mismatch in criteria expression". However, when I run a query for the...

I am glad that I got to know about the existence of MS Access program and AWF as well. Learning VBA from basics since I love to see the wonders it does. No prior coding experience or education but keep trying. Here to learn and do more.