Recent content by dnstapes

Thanks for the response. I understand how relative and absolute addressing work, but how do I set up Excel so that it uses relative addressing? Currently, I'm grabbing data from Access by using Data->Get External Data->Create New Query. This asks for a data source. If I click on new data...

I need to link my Access DB to an Excel spreadsheet. The problem is that both the database and the spreadsheet reside on a network drive. It is highly possible that people may have this network drive mapped to different drive letters. For example, I have this drive mapped to H: but I know the...

I'm trying to convert some charts in Excel97 to picture format, and then display them on a web page, all through VBA. I've found that Microsoft has provided a function called convertHTML http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcel9/html/xlconvhtml.asp I'm having...

I'm still having this problem. I've looked all over the place, and haven't found any help. Anyone have any ideas? Thanks, Dana

anyone have any idea on this one?

I'm trying to save some charts to html files. When I ollow through the wizard, I get a message that says "The wizard could not export the chart. The GIF filter may not be installed correctly. Please rerun the Setup program that you used to install Microsoft Excel and install the GIF...

I have a macro that I need to run at night while I'm logged off of my machine. I've got everything set up, but one part won't work. One thing that the macro does is save a report as a .txt file. I do this with the OutputTo command. Everything works fine when I am logged into my machine, but...

I'm writing some VBA code to save my project98 file to access97. I will be running this file everyday, so the database will already exist. I'm using the project.Application.SaveAs function to save the file. Basically, I need to somehow explicitly express that I want to append to the existing...

I have a batch file that I need to run at night when I'm not using my PC. At night, I always either log out of my Windows NT machine or lock the screen so no one can get into my files. Unfortunately, my batch file calls a VB script that interacts with Microsoft Project, and the script uses...

I'm wrting a query to combine two tables, and I need a way to eliminate redundant entries. Both tables have the same primary key and the rest of the columns are also the same. The problem that I'm having is that it's possible for both tables to have the same value for the primary key, and...

Hi, I'd like to set Project up so that twice a week a file is appended to an Access database using a custom export map. Is there a way to do this within Project 98, or is a script needed? How do I do it? I'm using Project 98 and Access 97. Thanks

Hi, I'd like to set Microsoft Project up so that twice a week a file is appended to an Access database using a custom export map. Is there a way to do this within Project 98, or is a script needed? How do I do it? I'm using Project 98 and Access 97. Thanks

The way my ASP is set up right now, an error is generated if the database is missing certain pieces of data. Instead of displaying the generic error page that just states the line number where the error occured, I'd like to show a more user-friendly error page for the users of the webpages. Is...

Actually, just some of the pages are crashing. I have a front asp page that has a recordset that lists a bunch of products as links. This page loads fine, but when you click one of the links (they always point to a second page) these links are where the crash is occuring.

why would that only make the page crash on one server? it runs fine on the other server.