Search results

I have 2 tables. One for customer details. With customer ID,Company Name, Customer Name and Address. The other for sales details with Order ID, Customer ID, salesprice and sales date. I would like to have a list of customer ID, Company name,total sales last year(sum of salesprice for 2013)...

Hi, I have 2 tables. In one table(Invoice table) have records of customer , the product they subscribed and the amount they paid and period they subscribed and the number of products they subscribed. The second table is---Each time a existing customer renews the subscription the previous...

Hai, I would like to send an email from Gmail server automatically at the end of every month. I'm currently sending email on button click. But is it possible to do this without user intervention. Please advice. Thanks

Hi, I need to send email with attachment on click of a button. We use emails like name@basepost.biz which is assigned to gmail. I tried the following code but it throws transport to server error. Dim cdoConfig Dim msgOne Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields...

There are around 100 customers.And on application open, need to check if customer has paid invoice. If the customer has paid/not paid need to change the status accordingly. Form on open event changes status of only the first customer.Form on current changes status only if we move to the specific...

I'm creating a appointment calendar for the sales team. Each user enters the appointment in the calendar. When the appointment is due a popup window reminds the respective user of his appointment.Each user can add,edit and delete only his appointment. Please can some one guide me in developing...

Hi, I'm creating a database for a sales team. They need a calendar where they can enter the reminder like "call peter at 10:30 on 11th july" and reminder like " call frederik on july12 at 12:30am,etc. And they need a popup when the reminder is due. Is this possible in access. Please let me know...

hi, I need help with access query. Only one table : Customer ID,Customer name , subscription period, subscription start date and subscription end date. I need values where subscription start date is between date1 and date2 and subscription end date is between date 1 and date2. Detail...