Search results

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

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

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

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

Having a senior momen here! I've done re-linking tables in the past but this is slightly different. Can anyone point me to code to link an Access FE to an Access Back End WHERE I don't know how many tables there are or what they are called? Any links gratefully followed! Thanks

Access 2010 vba - I'm trying to pass a start date and end date to a date field in a make table query, and use the 'between' operator on that date field. So I have a criteria on the date field like this "Between [dtStart] and [dtEnd]" and if I run the query manually it asks for 2 values and then...

I have a line like this: strSQL = INSERT INTO tbl1 SELECT * FROM tbl2 followed by db.execute strsql, dbFailOnError This works fine but I'd like use a couple of variables for the table names so I can loop through lots of tables. I can't get the syntax right - can someone help please? Thanks...

Just upsized from Access FE/BE to Access FE and SQL Server 2014 BE. Never done this before but all seemed to go smoothly after some weeks of planning. And help from this forum. Went live yesterday. Today about 100 Terminal Services users logged on this morning and all are moaning about...

If I add a table to the BE then obviously I need to re-link the FE. But what about if I add a field to an existing table - do I need to re-link the Access front end to the SQL Server back end? Something I saw recently suggested that I did, but it doesn't make sense to me Any thoughts Dave

On Sunday I'm converting a large client from Access front and back end to Access FE and SQL server back end. In the Access days I would regularly take a copy of their data file by copying it remotely into Dropbox. I could then run it here in my office and use it for development or bug-fixing...

I've found and tried code for cataloging all my linked tables and relinking them all to an SQL server, BUT what I need is something simpler, and I can't find how to do it. Starting with a FE with no linked tables, all I want to do is link to every table in an SQL database where the table name...

Using the SSMA and much help from this forum I have successfully upsized a large customer application from an Access 2010 split database to Access 2010 front end and SQLServer 2014 back end. I use ODBC to connect FE to BE and it all seems to work, and user's won't even know it's happened. So...

I'm working on upsizing my all Access 2010 front end/back end system to be Access front end and SQL Server 2014 back end. I've immediately encountered the well documented error 3622 having upsized and I have 2 questions I'd like to ask:- 1. Adding the 'dbSeeChanges' parameter is going to be...

Apologies if this has been covered before, but I can't find the answer, so here goes:- I have a large A2010 multiuser application with a standard front end/back end split. I need to upsize the data to SQL Server, mainly due to database size. I've run the MS Server Migration tool and it works...

I can't find the defintive answer to this - is there a smart way to disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field? Thanks Dave

I have used Automation a lot to programmatically create documents from word templates. This worked fine in Office 2003. It was still fine using A2010 plus Word 2003. Now I'm trying to upgrade to Word 2010 and I'm getting an issue I don't understand. Here's a simplified code fragment: Dim...

I recently upgraded a largish A2003 system to A2010. The conversion to .accdb has gone very well. Now I want to tackle word templates and documents. Part of the system creates Word documents based on templates and using Automation. In A2003 this has worked perfectly for years and still works now...

I know it's a long shot, but, in A2010 I'm trying to convert a series of Word doc files into pdf, BUT then assemble them into one large PDF. It's for a sort of archiving system. Can anyone think of a way I can do this, preferably just using the PDF capabilities within Access and without...