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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Duplicate Entries in Report
distinctrow did not work but I do have multiple entrioes in teh table. After looking at the report I have decided to hide multiples but not all fields. thank you for all the help- jstoto
- Post #4
- Forum: Microsoft: Access Reports
-
Type Mismatch in Password form
I fixed this by moving DAO 3.6 up the chain under tools->preferences. Thank you all- jstoto
- Post #2
- Forum: Microsoft: Access Forms
-
Type Mismatch in Password form
Below is the code for my cmdOK box in a form called Password. I have a tbl called Security that Password reads the username and password from to validate. In the form I have two text fields called Username and Password and 2 cmd buttons called cmdOK and cmdCancel. In the table there are 3...- jstoto
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Duplicate Entries in Report
Below is my SQL statement for a report I have. I added the DISTINCT so that when it finds a duplicate entrie but it still does not work. Can someone help with this PLEASE. SELECT DISTINCT [tblEnduser].[EU_EID], [tblEnduser].[EU_NAME], [tblEnduser].[EU_Phone], [tblEnduser].[tblroom]...- jstoto
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
