Hey Everyone,
I needed some assistance with this database I am working on. I have attached a dummy database below that has information (Myzip - Dummy database with Disney Characters). The thing is, in the form "Client Details" I need to search for client's name and I need it to be like our Google search. It searches the "Full Name" as I type. I have searched online, but all they have are search features in queries. I require this option in the form, with a drop-down list that shows options as I type. Is that possible? The screenshot below shows the Search area that I have been working with.
Secondly, I have 3 types of Users in the database, "Admin", "User" and "User2", (Password for all is 123)
User is not allowed to make edits, but they can add a new entry everytime they enter . User 2 can make edits but can't add new information
(CODE FOR USER)
Me.AllowAdditions = True
Me.AllowEdits = False
Me.AllowDeletions = False
Me.DataEntry = True
The issue I am facing is that when we put a new entry in "Add new entry", In the call log area I can't get to "Insert Object". Only for User this option is not showing, but for User2 and admin, when I right click in the call log area, I get the option of "Insert Object". Is it possible to have the insert object show for user? I don't want to login to another ID everytime I want to insert OLE object.
Finally, In my automated switchboard, that I have is it possible when User2 logs in, to make the "Add New Entry" not visible. Cause only User needs to add new Entry, for User2 I require only Edits to be made. Is this possible?
I've been stuck on this for so many days. I can't seem to find an answer since I'm kind of new to this Access.