Search results

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

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

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

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

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

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

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

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

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

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

I have two forms and I would like to pass data from one form to another form. Can you please help. Attached is the sample DB

I need help I want to email all attachnments saved in the database as well as the PDF report. The below script works fine BUT When there is no attachment it does not send the report. How can I amend my script to add an IF and ELSE clause into my script. --If No attachment (attachment...

Hello Everyone I have a search form where I enter a date range and get a list of all files within a give date. I have created a cmd button to open form1 or form2 based on the information / data in the above row (results) I would like the system to do the following: Private Sub...

Can you please give me the exact VB script for this. I have a popup memo field and when I hit the enter key it closes the popup form and returns to the main form. I would like the following: - when I hit the enter key it should go to the next row and not close the form. Currently on load...

Hi Can someone please show me how to pass multiple values from the search result form to another form. I have attached a sample access Database. I would like to pass multiple values from one form to another form. Attached is the sample EmpSearch_Frm hold the search results - I want to pass...

I have created a multiple field search screen. The script is attached. I would like to add a MSG Box "No records found" when the user types in information in any field where no records are available. Just cannot get this working. Can you please check my VB script and let me know what is...

I am trying to send an email with the atttachment in the database as well as the Report as PDF. This works fine. The problem is when there is no attachment, it will not email the report. Where can I add (and / or) to the script. 1. The email button should email the attachment and the report...

Hi I am trying to build a Multi Search Screen and just do not know how to achieve this. what I want the application to do is: 1) I Created a main form for data entry called 'Orderfrm' 2) The Orderfrm Field EmpNo - I created a Search Button. 3) Users to enter the Employee No or Surname or...

I have searched all over and am in need of some assistance. I have a database that has the table [tblAttachments] to store various attachments. In this table I have a primary key [ItemNumber] and an attachment data type field. This table holds all attachments for a Customer/Record. What i am...

I am looking for help. I want to email a report as well as the all attachments that is attached in the database to be sent via an email. I have created a cmd button but I do not know how to script this/ The report is a PDF format. and the Attachment is the Attachment Data field type.