Recent content by virencm

  1. V

    VBA to run a BAT file in ms access 2016

    Hi guys, I am trying to run a bat file from a 2016 access database and i get an error "INVALID PROCEDURE CALL OR ARGUMENT". The VBA code i am using is attached to a button shell ("path\import_1.bat) Am i missing something? is there a specific reference that is required for running bat...
  2. V

    Preserve formatting when exporting from MS Access to MS Word

    Hi, Is there a way of preserving the formatting when exporting a report from MS ACCESS to MS WORD? Cheers V
  3. V

    Email all attachments in a record using vba

    Thank you ArnelGP. this is awesome...
  4. V

    Hi Arnelgp, you helped me with the email attachment post about 2 weeks ago at link below: It...

    Hi Arnelgp, you helped me with the email attachment post about 2 weeks ago at link below: It works really well! Can you please help include the vba code to set the default signature when a new email is created in outlook? thanks for you help! Regards Viren
  5. V

    Email all attachments in a record using vba

    Thanks you Arnelgp.This is exactly what i needed. Really appreciate it!
  6. V

    Email all attachments in a record using vba

    Hi Arnelgp, I am having trouble with the parameters in your code. for the below parameters sTable (string) the name of table where the attachment field can be found ' pkName (string) PK or fieldname that uniquely identifies a record ' pkValue...
  7. V

    Email all attachments in a record using vba

    Thank you for your prompt reply arnelgp. Let me try incorporate this in my database and i;ll get back to you soon. Cheers Viren
  8. V

    Email all attachments in a record using vba

    Hello, I am using ms access 2016 and have a table that has attachments as one of my data field s. Each record in the table has approx 6-7 attachments. What I am trying to do is add All attachments to an email in outlook when I open the form to a particular record and click a button. Can...
  9. V

    Unmatched query issue

    Awesome!! Thanks JHB
  10. V

    Unmatched query issue

    hi JHB, i am having another issue with the unmatched query and i cannot figure this out. i have attached a sample database. i am comparing the config with the inventory and this should bring up values that are not in the inventory but it doesnt. what am i doing wrong? Can you help please?
  11. V

    Unmatched query issue

    The query works!!!! Thanks JHB
  12. V

    Unmatched query issue

    Thanks for pointing that out JHB. I didnt realise that. Let me revaluate and see if it works after amending the records. Thanks again Viren
  13. V

    Unmatched query issue

    Hello All, The attached database has 2 tables, Master and MXI. there are 3974 records in Master and 3950 records in MXi. I need an unmatched query that looks at both these tables and lists the 24 unmatched records . I need to find the record for field "CONFIG_POS_SDESC" in table Master that...
  14. V

    Condition format a date field

    CDate(Q_Induction_Date) < DATE() works.. excellent. thanks CJ _london.. Thanks for your reply Arnelgp & Galaxiom. regards V
  15. V

    Condition format a date field

    Hello, I am after some help with condition formatting a date field in access. The query used for this field produces a date or "NA" based on the formula below. so when the date shows up as "NA" then i have set the condition formatting of the cell to grey and this works works well. but when it...
Top Bottom