Search results for query: *

Thanks PH - yes I think that would be the best way forward

Thanks bubba - nope still getting same message

It is Outlook VBA - it was originally written in Outlook2000 References selected: Visual Basic for Applications Microsoft Outlook 12.0 Object Library OLE Automation Microsoft Office 12.0 Object Library

There isn't one - that line given is the first (non-comment) line in the sub. This has worked in both Outlook2000 and Outlook2003 I can say I have tried Dim myOlApp As New Outlook.Application But this gives exactly the same outcome

I have been using Outlook VBA on a new PC which was already set-up with Office 2007. Initially, these would would run successfully. I have also used them in the past on Outlook 2000 and 2003. However, I have subsequently installed Excel2000 to run in parallel with Office2007, as our existing...

Thanks Skip. Anotherhiggins - the exchange rate isn't relevant in this case - it's a spreadsheet for completion by the user not a report. Cheers anyhows

I have a spreadsheet with many cells formatted as either currency or custom with pounds sterling as the currency. I have to re-design this for use by a site in Germany. Is there any way to change the currency easily to Euros via a setting/options change or am I going to have to re-format...

Thanks again Still no joy I'm afraid "Is there a sheet, Tick List Dealer containing PivotTable named PivotTable1?" Yes It has three page fields "Dealer", "Franchise Group" and "Year";column field "Period" and multiple data fields

Thanks Skip - see what you mean and I've applied it but I'm still getting the error. Dealer1 does contain a value that is one if the PivotItems in PivotField Dealer.

Thanks Steve I'm afraid that doesn't change the result - it still falls over when it reaches line 3

Hi There, I have a problem with some code which causes a pivot table to change. I have a page with drop-down boxes. After these are selected, I hit a button and want it to update three pivot tables which are in the workbook I get "Run-time error 1004: Unable to set the _Default property of the...

Help! I'm having exactly this problem as well - can anyone help please Cheers!

Yep - job done Much appreciated :-)

I have a pivot table which has 7 data fields, 1 row field and no column fields Now Excel puts the seven datafields as rows in the piot table e.g. Dealer Data Wilmslow Opportunities 10 Contacted 20 Missed etc etc 10 I would like to have the datafields as columns...

That's the one! Thank you very much :)

I'm trying to apply a filter to a subform based on the entry given in an inpout box when you click a button. The subform says that it is filtered but all records are still visible! This is the code on the button - can anyone advise please? Many thanks :) Criteria = InputBox("Enter Dealership")...

I have a subform which contains a field from which the users would like to use to search. However, the search only works for the current record! Is there a way round this?

I want my databse to back up to a separate server using the menu's Backup Database option. I'm using Access 2003. Whenever I use the "DoCmd.RunCommand acCmdBackup" command, it says it is not available. If anyone can advise me how to get around this i would be very grateful!

I have a ~25 sheet workbook, each of which consists of a table and two graphs. There is a redundant link in there somewhere. I have tried a search on the name of the linked file but it returns nothing. Can someone please suggest if there is a quick way find where this linked cell/object is?

I have a form set up as follows: The main form contains header information There is a subform which contains line information. I create a new job in the main form and then add separate lines using the subform. The subform only shows one line at a time and clears when I click a button "Add a new...