JohnnyBQue
Registered User.
- Local time
- Today, 16:06
- Joined
- Oct 31, 2014
- Messages
- 25
New to writing code, and I'm having difficulty figuring out attachments (seems others are too). What I'm looking to do is bring up a set of attachments when performing a search on an employees name or ID. I'm having issues because VB doesn't seem to want to work with attachment controls or fields too well and my ignorance isn't helping. Where I've used (example)
CurrentDb.Execute "UPDATE recEmpJD " & _
" Set EmpID=" & Me.txtID & _
"' HireDate='" & ME,txtHireDate & "'" & _
"' Depart='" & Me.cboDepart & "'" & _
I can't seem to figure out what identifier works for attachment control "att" ?? or am I totally wet and need to address attachments in a different manner? Seems like the attachment control (type) isn't compatible when used in a string with other field/data types.
any suggestion would be take most welcome
CurrentDb.Execute "UPDATE recEmpJD " & _
" Set EmpID=" & Me.txtID & _
"' HireDate='" & ME,txtHireDate & "'" & _
"' Depart='" & Me.cboDepart & "'" & _
I can't seem to figure out what identifier works for attachment control "att" ?? or am I totally wet and need to address attachments in a different manner? Seems like the attachment control (type) isn't compatible when used in a string with other field/data types.
any suggestion would be take most welcome