Recent content by ian_w

Hi, Been struggling with this for a few days so decided I need some assistance :o I have my access database and I am generating a word document based on data in my database, what I need to do is format a certain word in a table cell to be bold - I can't figure this out :/ I am trying to use...

Great, I am used to everything being a little more complicated in good old VBA :) Thanks

Hi, Looking at writing a new module that uses an API from one of our suppliers. Can an API from a 3rd party be bolted in to Access 2010 / VBA? It's going to call a webservice and uses XML. Sorry for the vagueness, not got a lot of info at the minute but don't want to spend to long looking...

Just thought I would update this, never managed to get it to work using ODBC dbo connections, tried aliasing, closing connections etc, always resulted in the same error. Just rewrote it using ADODB which actually worked a lot better, got rid of my errors and where able to enclose it all in a...

Hi, Thanks for the reply, already tried x.close and then x = nothing but makes no difference. Query is a find max based on the main index so runs instantly. Just ran it again and the actual error is 'error 3146' odbc - call failed.

Access 2010 with an SQL Server 2008 R2 backend, all tables linked to backed using DSN Less odbc connections. All working well but when I want to run two different queries on the same table in one module it hangs and say's odbc connection timeout on the second query. Example Set x =...

I have various routines that run in workspace transactions in VBA using DAO. I've just figured out that these are no longer working now I have ODBC linked SQL tables :banghead: What is the SQL alternative to an access workspace to allow rollback if an update fails? Can it be done from access...

I converted the routines where I was needing the primary key to use ADODB and this is now working fine. I just inspect the primary key value once the update has been posted. Thanks

Hi, Currently replacing our BE with SQL Server 2008 and accessing using Access 2010 FE. Tables linked via ODBC and all database opens are done using DAO (was originally an Access 97 database). Run into an annoying problem, would seem a lot of code retrieves the index of the current record...

Hi, Template_Path is just a global variable that holds the path to the templates. Putting the path directly in e.g "J:\Templates\Invoice.dot" results in the same error.

Hi, I have an Access 97 application that exports data to a MS Word template. Using Windows XP this code works fine, I have recently attempted to run this code on a Windows 7 machine and it fails with the error.. Run Time Error '5981' Could not open macro storage. I have tried making the...

Can anybody point me in the directon of an ocx file that will allow me to control a scanner through access / vba? I have seen a number of posts pointing at using Olympus TWAIN Wizard but i've googled and googled and can't find any active links :( I've got a Canon LIDE 100 scanner at the...

I managed to figure this out using pretty much what The_DOC_Man posted.. .ActiveDocument.Tables(1).Cell(1, 2).Select .Selection.Text = "Text you want inserted"

Hi, Thanks for you reply. Sadly I have looked all through Word help(97) and I can't find anything regarding VBA. Either I can't google very well or information on doing this is pretty thin on the ground :(

Hi, Sorry if this is in the wrong section, seems more VBA than Word... Scenerio I am trying to write to a preset table in a Word 97 document. I have bookmarked the table and I can open the bookmark using VBA but I can't for the life of me figure out how I can reference individual cells in...