I need to make a custom message in my access database when someone tries to make a duplicate record.
My table detects duplicates based on a phone number field called "fldPrimPhone"
I would like to have a message other than the long winded default MS Access one appear when someone tries to enter...
Hey all, I have a customer with a database that will not open no matter what we do. It gives us an error that I cannot find a solution to.
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time "
It is an...
Ok, I have a strange problem with subforms...
Table = tblWork
Main Form = frmNewSearch
Subform = sbfrmNewSearch
Subform Object in Main Form = sbfrmNewSearch
In frmNewSearch I have 3 text boxes and a command button.
The command button has some VB code attached to it that creates a query called...
Hi all, I have brought some work home with me and ran into a problem...
My database is secured so it asks for username/password upon entry. It uses a Secured.mdw that was created when I secured the database.
I brought the MDB and the MDW home with me, and made the new shortcut:
"C:\Program...
Hi all, I've been looking through the forums and cant seem to find what I want.
I have a database that includes fields such as Firstname, Lastname, Phonenumber, Ordernumber, Serialnumber and Casenumber.
I have forms that allow data entry and data edit. I need a form that allows the users to...
Tip of the day popup???
I have an access database that I would like to add a function like "Tip of the Day" that will popup any new admin messages, tips on database use etc.
I want this to popup when the user opens the database. I would like to be able to have it show a new "tip" every time...
Ive been searching through these forums and see some people asking similar questions, but I cant find one that really tells me how to do my specific question.
I have a form called "frmMain" that has 4 tabs. Each of the 4 tabs has a SubForm that contains one of 4 other forms I created.
Right...