Recent content by cpremo

Actually, I just retested my code and it is now working. Go figure! So first copy and rename your database "Make MDE Version.mdb". Then, make your changes as required. And click the MS symbol in the top left corner of access, go to access options, find "disable special keys", and uncheck the...

I have a database that some one created. I'll try to post it or send it tonight or tomorrow.

If you look at my original code, I included a strpath statement to the code ObjExcel.Run "GetFromAccess", strPath Your code doesn't include a path. Try adding "C:\Documents and Settings\ifa1kor\Desktop" to your code ObjExcel.Run "Macros_Open", "C:\Documents and Settings\ifa1kor\Desktop"

It seems that after I converted my Database to Access 2007, I discovered that you can no longer export your reports to Excel. Am I wrong? If so, how do you do it. The Analyze with Excel button is grayed out!!! :mad::mad:

I'm getting this error message on an Access 2007 run database that was coded originally in Access 2003. If I run the report on an Office 2003 PC no problem. If I do it on an Office 2007 PC I get the error. Mirosoft had this Information http://support.microsoft.com/kb/927678/en-us...

Question Opening Excel Spreadsheets What does your code look like?

Actually the import command is extremely simple: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "AccessTableName", "Path:\Directory\Filename.xls", True Now as to the data. Again if the type of data in each of the columns always be the same (i.e., Column1 will alway be Names...

How did you turn off the Ribbons? In my Access 2003, I was able to create my own menu bar and present that instead of the Access menu bars. I want to do the same for 2007.

You're a little confusing with regards to your initial statement. First, will the column names always be the same? Will the type of data in each of the columns always be the same (i.e., Column1 will alway be Names, Column2 will always be dates, etc)? If the data type will constantly be...

Question Opening Excel Spreadsheets You can run the data through a two step process. First import the raw data into a table X (rows) by x (columns). Then, extract all the columns of data into another table (you name them as desired). Then run you comparison against the second table. Finally...

I've created several Macros in 2003 that use a search function to replace double Paragraph marks with a single paragraph mark. However, in 2007 the function gets stuck and I have to press the ESC key to halt the process. Even when I do this process manually within the document it gets "stuck"...

I use to have code that would disable the holding down the "Shift" key to access the database struction and the F11 key function. Now that I've purchased Office 2007, this function doesn't seem to work anymore. Does anyone have code that will do this for Access 2007?

That was it. Thanks for the help!!

After a little more tweeking, I've been able to get the code to run for multiple loops with out the error showing. However, when I look at the Task Manager, the Excel.EXE is still active even though I've told it to close. Or at least I thought.

I use the following code to open excel, run a macro and then close excel from an access database. Unfortunately, I get the following error when I try re-runing the code (from a loop statement): Method 'Run' of object '_Application' failed! It seems that the second time through it isn't...