Search results for query: *

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

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

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

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

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

I have two linked combo boxes in a subform. I've set the SQL correctly and put the appropriate AfterUpdate code in the first box. This all works fine when I open the subform on its own. However, when I run the parent and try and use this functionality, it brings up the "Enter Parameter Value"...