Search results

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

Try this formula instead of the field name: Account Sum: IIf(IsNull([sumofaccount]),0,[sumofaccount]) This accounts for Null entries. This will enable you to collect the total of each field. However, joining the two will not really be possible unless you have another field that "Links" the...

Are you using another query to enter the data into these tables? It looks like you're using a query to "stuff" the "sumofaccount" and "sumofextended" figures. (Guessed from the titles of your fields.) You may be causing your self a lot of extra work. Do you compute these "Totals" from...

Have you tried creating two separate queries to obtain the "Sum Totals" to test if your logic is working? Are the two tables linked by another table or to each other? Is Table1 the one side and Table2 the many side? Can you provide a stripped down version of your database with just the tables...

If you open the form and view the property of the field, what is the actual name of the field?

This is going to be harder than you think. You could use the instr function to find the First " " (blank character), but what about Dual Last Names? For example: Juan J. Hernandez Lopez. Then there's the J. William Smith variation. This will be a problem. Here is an example of the instr...