Search results

thanks worked well. question no 2 and 3 solved by your suggestion for question no 2

Hi, iam using the below code to send Monthly salary slips to employees, and it working fine but having 2 issues 1. if the employee email in null, its stopping every thing ( need to edit to ignore if email not avaliable or at least if i closed the outlook email it will continues) 2. added a...

i tried the below as first step but not working Dim StartDate As Date Dim EndDate As Date Dim Visitnumber As Integer Dim i As Integer StartDate = Me.Text119.Value EndDate = Me.Text123.Value Visitnumber = Me.Visitnumber.Value For i = 0 To Visitnumber - 1 Me.PPMlatestdate_subform.Form![PPM...

Hi, I have a form called New Project having 3 fields - StartDate - EndDate - Visitno And Subform called dbo_Job_new projects_Add having 3 fields - PPM # - PPM Date - Visit Type I require a code to add to a button once clicked the system will chck the startdate and enddate and visitno and add...

Hi, i run access system for our invoicing. i have 2 tables 1. invoices 2. Collection for each row (invoice) in table 1 there might be multiple rows (collection) in table 2. to show the pending collection i have to create 1 query for table 2 (Collection) with sum of the amount column, then...