Search results for query: *

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

My asp pages crash the server that they are on when run. At first I thought the problem was with my code, then I moved the pages to another server and they worked fine. Has anyone experienced things like this before? How do I fix the problem?

I have several ASP pages that connect to an Access 97 database. I've found that if, for whatever reason, my database crashes, the .ldb file will still show me as being logged on, even though I'm not. I've tried to delete the .ldb file, and I couldn't. I've gone into the server resources...

My .asp webpages were working fine on Friday, but I checked them yesterday, and every one of them produces this error: Server object error 'ASP 0177 : 8002801d' Server.CreateObject Failed /www/piehomeASP.asp, line 2 Library not registered. anyone know how to fix it? Thanks

I'm thinking about splitting my database into a front end and a back end. Before I do this, I'd like to know as much about front end/back end databases as possible. Can someone provide me with some information or links to information about this? Thanks, Dana

I'm trying to make a form that has a function that runs on its own at a given time each day. The form is described here: http://support.microsoft.com/support/kb/articles/q158/9/37.asp The problem I'm having is that when I create the form, I need to set the OnTimer function to something, but...

I need to be able to use my database forms on the web. I realize that there is a "Save as HTML" option that will save my files as .asp pages, but I haven't been able to get this to work after several attempts. Does anyone have a tutorial that I can follow for this, or know of a...

I'm trying to move towards automation of a few things on my current database. One of the things I'd like to do is run macros in my database from an outside source. I have a macro called UpdateWeb that I want to run every night. I figure if I make a new database and send commands to my...

I need to make a diagram of all forms in my database and what subforms/tables/queries/macros are being used by them so I can develop a hierarchy of relationships throughout my database. The goal here is to have a document ready to be referred to if something needs to change or be deleted in...

I'm testing a front end/back end system for my database. I used the database splitter to do this. Out of curiosity, I made a make table query. The table that was generated ended up in the front end database, not the back end. How do I send the data to the back end while still keeping the...

I'm making a form, and the user needs to be able to push a button and be able to see the start (Sunday) and end (Saturday) dates of the upcoming week. How do I get these values? Thanks, Dana