Search results

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

Hi Rx. To cut a long story short, I currently maintain 2 identical systems, both of which use both an Access BE and an SQL Server BE. Every so often I need to make identical schema changes to all 4 back ends, so I'm trying trying to streamline that process. And those 4 backends could rise to 6...

Thanks Minty, but the problem is that it won't even run doing an EXEC directly on the sql server. The error is "Cannot find the object "table name" because it does not exist or you do not have permissions. If it's a permission problem then I don't get it as I'm logged into the Management...

I can do this but I am trying to automate the process to make my life easier

Minty - thanks. I thought I'd try Stored Procedures as I'd used them before. I assumed I could create one to add a field to a table and call it from Access. So I created one like this:- USE [LCSArchive] GO /****** Object: StoredProcedure [dbo].[spAddField] Script Date: 01/12/2014 16:36:14...

I'm sure this is easy but I just can't get it - would appreciate some help. I need to add fields to tables on an SQL Server but from an Access front end. I presume I need to send an "ALTER TABLE........." command, but how? Thanks very much