Search results

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

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

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

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

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

When a sub or function is called is it possible to record where it was called from? Access 97 btw. Thanks

I have two databases running that both use a copy of the same form to control an external serial printer. On the form is MSComm which sets up the printer, sends the data to it and what not. I'm running into the problem that if a user has them both apps open then only one app can use MSComm...

Im trying to get my code to open a second DB instance, copy a form and paste it into the currentdb but I can't get it to work :o So far I have this.. (currentdb = update.mdb) Set wsp = CreateWorkspace("", "admin", "", dbUseJet) Set db = wsp.OpenDatabase("C:\Application\StockDB.mdb")...

Seems like a silly question but I can't work it out ! How can I set a SELECT criteria to be LIKE "A*" I can put "A*" inside a string and its fine but I don't want to be needlessly using strings to hold data if I dont need to.

Im guessing this is a long shot but im currenty adding the ability to change the currency into an existing application. Rather than the user manually entering the current exchange rate I thought it would be pretty clever if I could download the latest rates on a daily basis.. Are there any...

I've written a module to write data generated in Access (97) to excel. I want to be able delete a Column if a value in a field is 0 e.g. If xlApp.Cells(1,1).Value = 0 then xlapp.Column("B").Delete End if I cannot find any examples though, only for VB.Net or for deleting Rows.. Anyone able...

Got a bit of a funny one here, got a table with a load of Company names in and it contains a number of duplicates, i've written this little sub to open the table, find duplicates, if it does then delete them until the record count = 1. Its not doing what I want though, when I run my SELECT...

Im trying to check on the current status of a table / recordset in Access 97. I've currently got it so the following happens; User 1 runs the procedure and table and recordset are opened. If at the same time User 2 attempts to run the procedure then it errors with code 3262 and I capture it...

I've recently been experimenting with SQL 2005 Express for when we come to move our main db out of access and onto a SQL backend.. I've created a few of our main tables in access and transferred some data into it, im now trying to re-create one of our main queries utilising the SQL tables, im...

Im trying to write an expression in expression builder that sets the visibility of an image depending on a true/false value in a table. Im getting no where with it and I can't find any relevent guides :( Can anyone shed any light on how I would do this?

I've written a File Scanner in Access 97 that records File name, path, size etc and put all the information in a database. I've been trying to find the Date Last Modified but im not having anyluck. Does anyone have a decent example of how it is written as I am aware that there are a few API's...

Hi, Im currently writing a db app that does a filesearch and then places the results in table for file compares. Its using multiple API's and im on the final two steps now but I can't seem to get it working.. My WIN32_FIND_DATA statement currently looks like this... Private Type...