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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
.csv link, field format
I have a link table created that links to a .csv file. I can't get the SS#'s in one of the fields of the link table to show the first number of the SS#'s if the first number is 0. It is important that the 0's are there, as I have several update queries that depend on this format. any ideas?- lndsy
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
-
Incorporate criteria into event procedure
I have the following event procedure: Private Sub Form_AfterUpdate() DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 DoCmd.SetWarnings False If [TYPE] <> "CHEST X-RAY" Then DoCmd.OpenQuery "UPDATE - TB DUE DATE" DoCmd.SetWarnings True End Sub For the life of me, I cannot figure...- lndsy
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
-
re-write code more efficiently
Can anyone please help me re-write this code more efficiently? Private Sub RESULTS_AfterUpdate() DoCmd.RunSQL "UPDATE [EMPLOYEE HEALTH] SET [EMPLOYEE HEALTH].[TB DUE DATE] = " & _ "IIf([TB DUE DATE] > DMax(""[DATE]"", ""EH - TB"", ""[ID]=" & Me![id] & """) Or [TB DUE DATE] Is Null, " & _...- lndsy
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
