Recent content by Mark Wild

It's how I thought i should be shutting down the rpt that has no data (from examples on the forum). The RptZeroTransactions is not the report that has no data, but is printed for audit purpose

Rich, Because the error is a run time, I don't seem to be able to trap it via the way you suggest (the err.number is 0), and subsequently still get the problem Jenn had. Any other thoughts on how to get rid of this? Cheers, On Error GoTo RptErr DoCmd.OpenReport "RptZeroTransactions"...

THanks for your help Nero. When I removed the With .attachment it allowed for more than one attachment. All sorted!

No luck unfortunately. This was the solution that I had thought would work, but with both attachment references, the lines immediately go red. If I tab one or the other out, it allows it, so it looks like .attachment can only be used once... Any other thoughts? Cheers, M

Cheers Nero, THis is giving the message that the object doesn't support this method. I was using a slightly different method (.Attachments.Add(strAttachment, olByReference), so when I use your example, its not working. I don;t mind in the slightest which method I use, but I'm afraid I don't...

Adding multiple attachments Does anyone know how to amend this code Hayley used to attach more than one file?

To put a slightly differrent spin on this, I do a similar update from a large number of people accross the business, but rather than use Excel, I have an Outlook form that users complete and then sent to a specific mail box. Admin then from time to time run a process in Access that imports all...

Does your o/n process output a file for the import into Access? If so, this is what i use Sub FileLastModified(filespec) 'finds the last modified date of a file Dim fs, f, s Dim strMsg As String Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFile(filespec) If...

THanks Chris. The solution I did was For iCounter = 0 To 11 ' for the incremental months If iCounter > 0 Then ' icounter 0 adds the first record, all others must edit that record .FindFirst "Date=#" & DATE & "#" ' find the date...

Hi, I'm trying to slim down some of the code I've got and have a process that is massivly repetative (the update line would drop from 20 lines *6 currencies =120 lines to just 2 lines..) What I'd like to do is replace the month number and the currency (GBP is this example) with a variable...

Cheers. Such a simple solution...

I have a report that picks up a date from a textbox and uses this date as its filter. However, it will only bring through the data is I turn the date into the American format of mm/dd/yy Everything in the system to the best of my knowledge is in the UK style of date. Can anyone advise on why...

Have you got the term as # yrs or yrs*periods in year?

Hi CJ, sorry for lack of info - I'm being called away... One thought from my initial scratchings. A location will have many dates, but will a date not have more than one location? Think this might need to be a many to many relationship. will try and carry on later...

In the cell on the form where you want to show the result, set the data control source to = then your formula, refering to the names of the fields that contain the data. Eg =[tbInterestRate]*[tbTerm]