Recent content by DavidCon

Hi, I'm experiencing an issue in the code below. Basically the code connects to an inbox and saves down all pdf attachments, marks the mail as read and then archives the email. This works most of the time but it does crash out with a error 424 object required about 3 times a day (it is on a 1...

Thanks all for the replies. Got this working as intended WHERE (((TblReconciliations.RecMonthEndDate)=[forms]![MonthEnd]![CmbSelectMth]) AND ((([TblSuppliers].[SupplierName])=[Forms]![MonthEnd]![CmdSupplierSelect] Or [Forms]![MonthEnd]![CmdSupplierSelect] Is Null)<>False) AND...

Thanks for your responses (I rushed the last post as it was late in the day and I had had enough!) Do you mind if I back up slightly here and explain what I’m trying to achieve. Basically I have three combo boxes on a form which I want the query to reference Each of the combo boxes are...

Hi All, This is driving me made and I can't find the solution if you please advise? I build the following query in access 2010 SELECT TblReconciliations.RecMonthEndDate, TblSuppliers.SupplierName, TblReconciliations.RecUser, TblStatementInvoices.InvoiceNumber...

Thank you for this, very useful.

Excellent, that did the perfectly. I can't pretend to understand how it works though but thank you both for your input.

Thank you that does work now but it's not really what i was looking for as it is finding the min date in the paymentdate table and comparing it against the due date. The query i'm looking for would look at each of the due dates and then look in the paymentrun table to find the closest future...

Thanks, I tried that but no luck. I even removed the spaces in the field names and still no luck. This is what I have at the moment and I just get #Error test: DMin("paymentdates","paymentrun">[duedate]) any ideas please?

Thanks for the suggestion, i've tried it but it just returns #Error This is what I tried test: DMin("payment run","payment dates">[due date]) both fields are date/time format. any suggestions please?

Hi All, I’ve researched this but could not find anything suitable so i’m here to beg for your help! This might be a simple thing but it has got be stumped. So here’s the scenario.... I have a table with a list of dates [PaymentRun] and a query which basically calculates [due date]. What I...

Thanks all for the input.

Just in case anyone needs this: this works: NextWed: IIf(Weekday([due]<=4),([due]+4)-Weekday([due]),([due]+11-Weekday([due])))

Hi All, I'm trying to calculate the next Wednesday on the field [due] i.e. today being 21/02/17, the next Wednesday will be 27/12/2017. I have a working formula in excel which I'm trying to convert to access. The excel formula is...

Thanks Guys, I figured it out..... It was working all along and I thought it was counting the whole table and not the criteria stated

Hi All, This is driving me nuts as it should be simple to do but I must be missing the point somewhere along the way. I have a form with some textboxes and I want to put a dcount in them depending on a couple of criteria. In VBA on form load I have written the following code: Staging2 is my...