Search results

Thanks . I tried and it works fine. The output is what I need. But I tried calling the query from VB 2010.But it doesnt seem to work. It says that the query name cannot be found. Can you please help me with this. Thanks

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 Plog, If I have all the records in one table. Each time I renew the subscriptions, then the primary key will be duplicated. How do I handle this? How do I show only the current records in the form? Please help

Hi namliam, The current record is like this Archive_ID ArchiveCustomerDetails.Customer_ID Invoice.Customer_ID Invoice.CustomerName Invoice.SubPeriod Invoice.Substartdate Invoice.Subenddate Invoice.Copiesperweek ArchiveCustomerDetails.Substartdate ArchiveCustomerDetails.Subenddate...

Hi namliam, SELECT ArchiveCustomerDetails.Archive_ID, Invoice.Customer_ID, Invoice.Customer_Name, Invoice.Subscription_Period, Invoice.Subscription_startdate, Invoice.Subscription_enddate, Invoice.Copies_perweek, ArchiveCustomerDetails.Subscription_startdate...

Sorry, the table is quite big and hope it makes sense. Thanks for the help

Hi Plog, I moved the record to a new table as the customer would like to see only the active existing customers and there could be many renewal within a year . Table Name:Invoice ID Name Address Add2 Add3 City Country Phone Email Category SA SubType Substartdate Subenddate Copies_perweek...

Hi namliam I used a joined query on the table. And my criteria was Between #01-01-2013# And #31-12-2013# for sub start date and or citeria is <=#01-01-2013# for sub start date and Between #01-01-2013# And #31-12-2013# Or >=#31-12-2013#for sub end date. But there are customers who subscribed for...

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

Can you please explain in detail.Do I need to create a separate table or a new database.I have never tried macros. Please elaborate. Thanks

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

Tried commenting the line but still throws the same error...

Hi, It doesn't do so in this case. Its just a information msg box with OK button in it. Thanks

"The transport failed to connect to the server" is the error exception caught in button click event.

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

Thank you. It works.

Front end and back end is both access. I have a form to input all basic user information. The first time the customer is added the status of the customer is Active. There is a Invoice button in the form.Which on click generates invoice, and the day the invoice is created is the invoice sent date...

I have a date when invoice is generated. Once the invoice is generated the status changes to due. If not paid within 21 days the status changes to overdue. If not paid within the 3 weeks of overdue then the status changes to stop.If the customer is new then the status is Active. And I also have...

I have a date when invoice is generated. Once the invoice is generated the status changes to due. If not paid within 21 days the status changes to overdue. If not paid within the 3 weeks of overdue then the status changes to stop.If the customer is new then the status is Active. And I have a...

Mr Simn , U r right. Is there an event to update table every 4 or 5 hrs?