Recent content by Nancythomas

  1. N

    send email

    I get the below error Run time error 3078 Microsoft aaccess database engine cannot find the input table or query. I need to click the send email and the email should go to all UserIDs
  2. N

    send email

    Hi I need help again. I am trying to get the VB script to work but it does not. Please check and let me known where I am going wrong. I need to send email to all users from the userID field. The list is in the form. Attached is the sample db Appreciate your help
  3. N

    Passing Values from continuous form to another continuous form

    Thanks all for helping me Here the sample. It does not list all the data into the second form.
  4. N

    Passing Values from continuous form to another continuous form

    I have two forms (FORM_B) AND a sub-form (FORM_A) FORM_B - is a search form that provides the results as a continuous form (Example) EmpNo Surname FirstName Department 123 Smith John Sales 423 Harry Jim Sales 563 Tom...
  5. N

    Command Button to Close table and Open Form

    Thank you very much it works. :)
  6. N

    Command Button to Close table and Open Form

    Hi I have a VB Script by a command button (1) It imports data from a spread sheet into a Temp Table (2) Closes the Temp Table after import and (3) Opens a form to review the data before uploading it into the master table. On Clicking the command Button the form opens in a flash and...
  7. N

    send email -taking the email address from subform

    I need to send email from 'Form" by a click of a button command (1) In FrmEmail - I select the Department (2) Subform displays the list of people from the selected Department (3) Email to be sent to all the selected people from sub form "frmEmpMobileNos" (4) email address is on the subform...
  8. N

    help with ms access send email vba code

    Please help I just cannot get this right I need to send email to a group of people with the same exchange/domain address (such as "@Gmail.com"), the email address name will be taken from the table and added to @Gmail.com. My Database, I need to send email messages to all the selected employees...
  9. N

    Help with Combo Box Value and results

    Hi I need help with MS access (1) I have a Combo Box field to select Department. (2) When the Department is selected - the results of all employees in that department should be displayed in the subform. (3) I also have a check box where I can select employees (subfrmEmployees). (4) I need a...
  10. N

    Select Items from Multivalue list and autofill value into new table commo seperated

    Hi I need help I have two tables and two forms Form 1 - is the master data entry form Form 2 is a lookup list In form1 - I have a memo field called category and a search button. The search button opens form2 that allows me to select multiple rows and load the selected items into Form1. I...
  11. N

    How to email report & all documents from the (attachment table) for a given record

    How to email report & all documents from the (attachment table) for a given record Hi I have a VB Script. I can email a report for selected record to the email distribution list. I would need some help to also email all relevant attachments linked to the record. I cannot get both to happen...
  12. N

    How to set up approval process with ACCESS form

    I am looking for a sample access database that can do the following: I wonder if there is a way in Access to set up an approval process where the employee requests for permission and presses a button and a link of the form goes to the approver via email (similar to infopath form) workflow. The...
  13. N

    Pass value from popup form to subform via the main form

    JHB Yeppy Yahoo.....:D Thank you very very much. I was trying to get this work for the last three days. Appreciate all your help. Thanks again
  14. N

    Pass value from popup form to subform via the main form

    I have designed a database with a main form and multiple subforms linked to the main form. The main form is [Mainformstock_frml] and the [Subformstaff_frm] The value gets passed from a popup form correctly but the problem is it directly open the subform [Subformstaff_frm] and passes the...
  15. N

    SendObject Method in Microsoft

    Thanks James but this is not what I want. I have attachments that is (Data type) and I have a access Report as well that get emailed. Currently only when there are attachment (Data Type) and access report the email works. I would like the cmd to work when there is not attachment (data...
Top Bottom