Recent content by PiedPiper70

Thanks to all for suggestions, but particularly to Galaxiom for coming up with the simple answer. By the way my count was 2619 !!!

Is it safe to install???

It sounds odd I know, but as part of a planned redesign of a largish system I would like to determine how many occurrences there are in my code (160K lines) of the MsgBox function. Anyone have any idea how I can do that please? Thanks Dave

As part of a larger system I currently have a standalone A2010 program which processes emails that it sees within Outlook. As my client is moving to Exchange Server I was wondering whether there was a better way of doing this by getting rid of Outlook and "talking" directly to Exchange. I'm...

CJ - many thanks. So simple, but I just didn't notice the "send to back" button Dave

Update - cut and paste works but when you do you lose all the event procedures connected to a control and you have to re-link them all. That's a nuisance if you've got lots of them, trust me! Dave

Thanks. A bit fiddly but cut and paste is the answer.

Sounds too complicated to me. The form already exists with all the controls working fine and exactly where I want thm. I just want to highlight a couple of them. What's stopping me???

A2010 - on an existing form I have a few controls that I want to hightlight. I thought I would create a rectangle covering only the desired controls and then make the back colour a light grey. But if I do then I cannot see the controls. If I change the back style to transparent then the colour...

As part of a larger multi-user system there is a time recording part with a simple table called tblTime with an autonumber field. Today at 11:45 users started reporting receiving a 3022 error. On looking at the table I noticed that if I tried to manually add a record then the ID field number...

Thanks Ilkhoutx, I'll look out for it. But I have solved my problem with some code from Microsoft and it's working fine. Here's the link: http://msdn.microsoft.com/en-us/library/office/ff845544%28v=office.15%29.aspx

Can't quite get my head around this. I have a series of 7 separate Access 2010 programs that are designed to run under the control of a scheduler, and they must always finish. Errors are trapped and logged but mustn't stop the processes completing. What I'm trying to do now is to create a...

Brilliant - it works. Thanks very much Minty. Now I can create a little widget that will do all my table updates. Cheers

Minty Thanks, but I don't understand what you're doing here. Firstly, what is AIR code? Secondly can you explain exactly what is going on - it looks like a mixture of some SQL and some VBA added together? Is this something I can run from Access without bothering with a stored procedure, or...

Minty I did. See my 2nd post at 04:44