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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combobox autonumber
I used Format([User].[A_UserID],"@") to change my autonumber type to text format type, but adding it within the JOIN gave me no records. My SQL View SELECT tblAudit.Audit_ID, tblAudit.User, tblAudit.Field, tblAudit.Prev_Value, tblAudit.New_Value, User.A_UserID, User.Name FROM [User] INNER JOIN...- hongsaru
- Post #7
- Forum: Microsoft: Access Forms
-
Combobox autonumber
Sorry for late reply, got sidetracked with work. I have tried creating a query that joins in my table but the audit table field (NewValue and PrevValue) is a text type of value and my lookup table primary key (UserID) is an autonumber type. My Audit table AuditID UniqID Field NewValue (Text)...- hongsaru
- Post #5
- Forum: Microsoft: Access Forms
-
Combobox autonumber
The audit trail tracks all changes on the form and makes a record in tblaudit table. My textbox fields are recorded just fine, but my comboboxes are recording the autonumber from my lookup table instead of the actual value. I have read your link and if lookup fields are bad then what do you...- hongsaru
- Post #3
- Forum: Microsoft: Access Forms
-
Combobox autonumber
Hi all I made an audit trail based off the example from http://www.techrepublic.com/article/a-simple-solution-for-tracking-changes-to-access-data/6166807 My comboboxes in my tblaudit table is storing autonumbers instead of the actual value. Is there way to change it so it stores the actual...- hongsaru
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
