Search results

Hi all, I'm having problem generating an unique customer number. It should always have 7 digits and the 'SSE' prefix (for example 'SSE1234567') Can you see what's wrong? 'Generate customer number for SSE customers. Dim Result Dim strCustNr As String strCustNr = "SSE" & Int((9999999 -...

Thanks, but I am actually looking for a solution where you can use an Word template, fill in the bookmarks and merge it to e-mail. I understand the htmlbody property, but I think this is mainly for font option. I also want to use pictures, header, footer and background color... Should all of...

Hello all, I currently use an Access database to store my customer details. In this database I created forms to search, select and view the customer details. On the form, I created the option to generate and e-mail message, to this particular customer. This is working fine, except for the fact...

Thanks for the help Plog. I think I actually found a very simple solution. I created a second query, based on the first one. Query 1: Day: Format([fldSubscriptionStart];"mm-dd") (formatted by month-day to filter correctly) Year: Format([fldSubscriptionStart];"yyyy") with Criteria...

Thanks for the quick reponse Ranman, but I need it to calculate it based on the past 45 days. So when I run this query next month, it should calculate it with 45 days from then...

Hello all, I have a customers table, that includes a "Contract begin date". I want to calculate how many contracts have been renewed within the last 45 days. So today is the 27th of July. I want to return all customers that have a contract begin date between 12-06 and 27-07 regardless of the...