Search results for query: *

Well, I'm embarrassed to admit that the problem was totally my fault. In order to determine what worksheet the user would like to update, the user is presented with a form containing a combo box that lists the worksheets in the target workbook. When creating this form, I failed to properly close...

No, I don't get the warning upon opening the spreadsheet during the update process inside VBA. I do get the warning when trying to manually open the sheet after trying to update it with VBA.

I'm trying to update an Excel spreadsheet using VBA in an Access database. I'm opening the spreadsheet like this: Set ExcelApp = CreateObject("Excel.Application") Set ExcelWkb = ExcelApp.Workbooks.Open(Addr) Set ExcelSht = ExcelWkb.Worksheets(WkSheet) Where Addr is the path to the spreadsheet...

I have a VBA routine that I run from MS Access 2003 that will open IE6 and go to a selected web page and print it using ExecWB 6, 2, 0, 0 Is there any way to specify that only page one should print in case there's more material than will fit on a single sheet of paper? That is: Print one...

Try ie.Application.Quit

When my group switched to IE7, certain web page graphics that were available in IE6 (and Firefox) are only showing up as placeholders now. I have searched and searched and can't find a way to turn these graphics on. Some graphics are still there, so graphics are not blocked. I'm accessing IE...

That's it. Does exactly what I want. Thanks.

I have an Access 97 database that stores the contents of specified directories in an Access table. The database contains a form on which I can search for a specific file to see where it is on the drive. I would like to know how to open the file (say, a ".doc" file) from this form. I know how to...

It's apples to the DB that is linked only to the table but has its own back end.

The employee table is in the back end of database 1. Database 2 has its own back end but also links to the employee table. Different users in my workgroup can be working with one front end or the other front and there's no problem (some users can have one open and other users have the other open...

I have a couple databases that at times need to share the employee table. The problem is that both databases can't be open at the same time on the same PC. Both databases can be open and working properly as long as they are on separate PCs The error I get is: "Couldn't use ...(path); file...

That does it. Thanks!

Supplying a negative value for horizontal position causes an "invalid value" error. But thanks for your effort anyway.

I'm using Access 97 and I have a simple database that I use to help me keep track of tasks I need to check on from time to time during the workday. To that end, the database opens three forms at once, each of which has a different use. It's really helpful to have all three open at once rather...

Thanks, This works beautifully. I have a couple projects That will benefit from this.

I have a module that successfully opens IE and brings up the desired web page. What I need to do now is print the page to the default printer and close IE from within the module. The user never even needs to see the page on the screen. The pertinent lines: Set IE =...