I have issue with updating table data from form. Form is with list box. I want to update the table from below code:
Current db.execute "UPDATE POSITIONAPPLIED SET POSITIONAPPLIED.PEVALID = " & Me.EVALID _
& " WHERE (((POSITIONAPPLIED.POSITIONAPPLIEDID)= " & Me.lsthosp.Column(0, i) & ") And...
Hi,
I have a code in form, when i click command button, it should update 2 fields in the table. But it is not updating. I think there is something wrong in code. If it is only one field update, it works fine. It is not updating if there are 2 fields to update.
CurrentDb.Execute "UPDATE...
I am developing db. In one of the form which is with contact details in the list box. When i click send email commond button, it should create a report and send it to the email address in the list box with the attchement(Hyperlink) available in source data from a query. How i can send the...