Search results

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

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?

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

I have a form with a list box, set to "Simple" Multi-Selection. I want to be able to filter reports based on the "Items Selected". I can create a VB Function to "gather" the selections but can't seem to "pass" this to the query. Does anyone have an example of how the did this? This is the...

I've created a report that fits on a Legal sheet of paper. I use the code below to "stuff" the data into the report. Unfortunately, I'm limited to 20 columns. Is there a way to print another set of 20 and then a nother set of 20, etc. until I reach the EOF for my record set. I have may users...

Does anyone have code that will convert a DEC number to and IP Address?

I have a form with an unbound ListBox that has a "Record Source" select query. The list box displays as needed. What I'm trying to do is move the selected record to the next record via code. How can I do this? The form-listbox is describe as shown: Forms!MainMenu!ServerList I can use code...

I have many databases with Front-End (Forms, reports, modules) and Back-End (Tables) design. All tables in the Front-End are linked to the Back-End. What I've tried to do is use this code to "Compact and Repair" the Back-End database, but receive the following error message: "You attempted to...