Search results

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

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

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

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

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

Hi, I’ve searched and searched for a solution to this but have been unable to find one and I am not competent enough in VBA to write the code myself . I have a query which lists the hyperlink of a pdf we have help on our server. What I want to do is to run some VBA to take this list and save...

Hi All, I'm trying to create a calculated query (nothing fancy) but I'm having an issue with null values. When I run the query if omits results as it is trying to calculate against a null field. I have tried to add nz() to the calculations but I must be getting this wrong. Could you please...

Hi, Hoping for a helping hand please. I have this bit of VBA that basically removes unwanted characters from a Text field: Public Function StripOutVoidCharacters(varstring As String) As String Dim varchar As String, i As Long, finalstring As String For i = 1 To Len(varstring) varchar =...

Hi All, I imagine this is a relatively simple question but I have been stuck on this problem for a couple of hours now and seem to be going round in circles. I have a table with a [Follow up] date and a form which references this. What I’m trying to achieve is on the form load, filter out...

Hi, Sorry if this has been answer before, i've had a trawl through the forums but have found no solution. I have a table in Access 2003 where i would like to extract a varable length string. Sample data: 555555_OP/C011526.pdf 100411_75163627X.pdf 104735_9200.pdf So in theory I would...