Search results for query: *

TomThumbKP- That sounds interesting, but these 'spreadsheets' are added to the site and the last 10 days worth of reports are available for the users. So setting up a link won't do what I need. Thanks for the input.

Hi I've tried to do a search on this subject but the search engine is down. Is there a way to use VBA in Access 2002 to upload a table/query to a sharepoint site. A database I'm running daily produces results from 2 queries that are exported to Excel then uploaded to sharepoint sites. This is...

Howard, Both machines are ATX. So they both shutdown through software power management. I can't seem to get it to work for me. Thanks for input.

Poltergeist, I've tried your code on my home network. (My daughter is always leaving her PC on.) It works great when executing the code from the PC I want to shutdown. But I can't get it to shut a PC from another PC. I've hard coded the name of the PC I want to shutdown, but no shutdown occurs...

Steve, Thanks for your input. I didn't think there was an easy way to accomplish the task.

Hello, I have inherited a large database to maintain. There are literally hundreds of queries and reports in the database. Every time a user has a problem with a report, my first step is to find the report in the database (there is no naming convention). What I've decided to do is insert a...

r937, Thanks for the quick response. It works great!!

I have a table that contains task information to be worked. There are 2 task ID's that are similar. I'm trying to create a report that will give any account number that has both of these task ID's. I'm would like to have the code all in the report. So it doesn't "junk up" the database...

MarkSweetland This is works great. Thanks for your help.

BigBrother I have a function to calc the works days. But what I need is a generic sub to update the work days once calculated. How can I pass the field names to the Sub?

I have a table that contains dates of completion for a process. There are five different dates for each record. Each date represents the completeion of a step in the process. I am trying to calculate the workings days between each of these 5 dates. I use a function to calc the working days...

Tony, Thanks for the quick response. This seems to work if there are no hidden windows on a spreadsheet. I tried your last suggestion because I would like to keep this in my Personal.xls file. It seems because some of the spreadsheets have hidden windows, it's not saving all the spreadsheet I...

Hello, I have several excel workbooks i am trying to save with sequencial file names i.e. file1, file2, file3... All the workbooks are open and I using the Saveas method to save them, then closing the workbook before moving on to the next. How can I write my macro to stop once it has closed...