Search results

  1. W

    Hi, How I can save the documents on server from Access form. I used below code. But it...

    Hi, How I can save the documents on server from Access form. I used below code. But it gives me message error 76 Path Not found. "\\EPIC\NEWFOLDER\TEST" Can some one check any syntax error in the code? Why it is not saving the files to the folder on servcer. Wasim
  2. W

    Add Employee's Image to the Form (Outside Access DB)

    Dear arnelgp, If we need to copy the file to server /LAN what will be the destination code ?:banghead:
  3. W

    Email Attachment VB Script

    Dear Arnelgp, i here with attached sample db which is corrected by you. I want to update the table POSITIONAPPLIED, based on the form and list box data once mail is sent. But it updates all the line data. But i want to update only data related to the record available in form list box. Please...
  4. W

    udpate table data from form code

    dear Arnelgp, I want to execute below code. The form with list box. When i click the command button, it should execute the code and update only the field where Positionappliedid is egual to list box PostionappliedID. But it updates the PEVALID for all the records. How i can sort out this...
  5. W

    udpate table data from form code

    Dear Arnelgp. Pefect!! It Works. Thank you. Wasim
  6. W

    udpate table data from form code

    Hi, separate the field by coma is not working. Please check the query below and suggest the correct syntax. CurrentDb.Execute "UPDATE APPLICATION SET APPLICATION.STATUSID = 1 AND APPLICATION.STATUSREMARKSID =Me.HROFFICERRECID" _ & " WHERE (((APPLICATION.APPLICATIONID)=" & Me.APPLICATIONID...
  7. W

    updating table data from form list box

    Hi, if i remove' i' it gives me error message. Is there some otherway to update the table ?
  8. W

    updating table data from form list box

    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...
  9. W

    udpate table data from form code

    Thanks. I have one more issue. I have form with list box. I want to update the table from below CurrentDb.Execute "UPDATE POSITIONAPPLIED SET POSITIONAPPLIED.PEVALID = " & Me.EVALID _ & " WHERE (((POSITIONAPPLIED.POSITIONAPPLIEDID)= " & Me.lsthosp.Column(0, i) & ") And...
  10. W

    udpate table data from form code

    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...
  11. W

    Email Attachment VB Script

    Thanks. Perfect!!
  12. W

    Email Attachment VB Script

    Hi, Arnelgp, reffering to above attachment, if i have the path name to save the files on my form, how i can modify the code in the attached db? The file saving path field is on the form named as"Filepath", where i will enter the folder location where i want to save the file. This will help us...
  13. W

    Email Attachment VB Script

    Great!! Thank You very Much. It works perfect. Wasim
  14. W

    Email Attachment VB Script

    Thanks Arnelgp, Now i removed it from list box. I want to get the data from the query: SELECT * FROM EVALDETAILQ2 WHERE (EVALDETAILQ2.EVALID)= " & Me.EVALID. How i can do this? Wasim
  15. W

    Email Attachment VB Script

    Hi, Any Help? Wasim
  16. W

    Email Attachment VB Script

    Dear Arnelgp Thanks for your suggesttion. Reffering to below part in code : column 7 is the attachment file ' add additional attachment file If Trim(Me.lsthosp.Column(7, j) & "") <> "" Then ReDim Preserve filenames(UBound(filenames) + 1)...
  17. W

    Email Attachment VB Script

    Dear ArnelGP. I attached db sample for your review and suggestion. Please check and advise me.
  18. W

    Email Attachment VB Script

    Yes. I have a form. The form is having the record. When i click mail command button, a report should be created based on the data available in the form. This report along with the attchments realted to this data should be mailed to the email address. The following documents to be emailed to...
  19. W

    Email Attachment VB Script

    Hi, I have similar issue. I want to send the report and attched documents when i click the commond button. The attached documents are hyperlinked. How i can sue the above code for hyperlink documents to export to a folder any help? Or any sample DB? Wasim
  20. W

    Email attachment with other reports from access

    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...
Top Bottom