Recent content by sh3498

This is probably an Excel question, but I have not found an Excel site as good as this one. I am trying to run an Excel macro every morning that will run some code and then open an Access database that runs some more code and then closes. I know how to go form Access to Excel, but cannot figure...

You guys are great! This is my first time to post to this forum and I am getting a lot of good information, although ya'll are getting above my head. The one thing I cannot figure out how to do in the Access database is to actually "run" depreciation on the assets monthly. We have about 50,000...

This looks like a great software package, but it still does not calculate depreciation; this is more of an Asset Tracking system where I need the depreciaiton and Net Book Value fileds. I've thought about building one in Excel and using Pivot Tables to sort and report the information.....what do...

Our company is needing a new Fixed Asset system to track assets and run the deprecation for the company. I noticed there is a sample database for Asset Tracking, but I am having to tweek it so much to get the depreciation part of it working. I was just wondering if anyone used Access for their...

I use the TransferSpreadsheet command to export tables of information to Excel and it always works very successfully. But, when I tried it today I hit a hang up. The information transfers to the Excel file, but it corrupts the file. When I open the file it says "Excel.exe has generated an error...

The form is a good idea and I have suggested that to them, but they are being stubborn about it and do not even want to have Access on their computer. I will have to build it first and then present it to them so they can see how easy it is. I'm pretty sure I've seen some VBA code that opened an...

Is there a way to start a Macro in Excel and then "jump" to Access and run a Macro there and then "jump" back to the Excel file? I'm building a report that needs massaged in Access, but the end-user does not want to learn Access, they want everything to run at the push of a button in Excel. (?)

I have about 100 queries set up that are using the same table, but pulling different data. As I roll into next year, I want to use the same database with the same queries but I want to rename the table 2003 (from 2002). When I rename the table, some of the queries recognize the new table and...