Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Random selection working but...
Greetings, I have a user that I created a random selection query. It is working the way it supposed to but now she wants one of the other fields within the query to be 1/2 of those selected. I.E., a person can be selected as a chairman or panelist. The user needs half of those selected to be...- 19thJIS
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
find duplicate record before posting
RoyVidar, Thanks for the help. The set focus works fine. As for the save, I moved the code to the Private Sub save area and expanded the If_Then_Else and was able to eliminate the error message. Chuck- 19thJIS
- Post #11
- Forum: Microsoft: Access Forms
-
find duplicate record before posting
Greetings all, This thread was a time saver for me. It helped solve a problem that I was having. Thanks for the great info. I am still having just a small problem once the msgbox reports a duplicate entry, how do I regain focus so I can enter a different name? Currently, the user has to click...- 19thJIS
- Post #9
- Forum: Microsoft: Access Forms
-
Saving data to a table.
Greetings all, I am trying to setup a command button that allows a user to use a combo box to populate four unbound text boxes. The code for this is: Private Sub cboNameList_AfterUpdate() Me!cboNameList.Enabled = True Me!txtAttorney_Number = Me!cboNameList.Column(0)...- 19thJIS
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
