Search results

Any custom formatting is lost when a pivot chart is refreshed and although it's possibe to write a macro to reformat it, it has to be triggered with a button or key stroke. Unlike Access there don't seem to be any event properties for a pivot chart field button so is there another way to have...

I have an Excel workbook that is linked to an Access query and I want to be able to refresh the workbook an Access module. If I open the Excel spreadsheet and run a macro that uses ActiveWorkbook.Refreshall the data is refreshed OK without error. In my Access module I have set up a reference...

I have a table with a date field and a price field that contains daily records from 1/1/96 to present. I want to create a line chart that shows the prices for 1999, 2000 and 2001 summarised by month but with a separate line for each year for comparative purposes. Any ideas? Thanks

I have a form with several option buttons and a text box formatted as a date. I want the validation rule for the date box to vary depending on which option box has been checked. I have tried: =iif([Option1],True,>=#01/07/2000#,>#01/01/2000#) I haved tried enclosing the Truepart and Falsepart...

Thanks everyone. I do mean custom public functions. I was hoping it may be possible to store the functions in a public folder and then use them in any open database. Anyone know anything about Add Ins?

How can I use some custom functions I have created in other databases? I have tried saving as .mda file and then installing as an Add In but this is only partially successful because although the functions can be used they do not appear in the Expression Builder so the user has to know they...

I have created three simple functions AveNumber(), MaxNumber() and MinNumber(). They are all contained in a module named My Functions The module is saved as MBC_Functions.mda A. It's possbile to install MBC_Functions as an Add In in the Module tab by Tools, Reference and searching for the mda...

By trial and error I am now able to use the custom functions I have created which are stored as an mda file on the network server - I don't think it's necessary to have the Add In stored on the c: drive. However, the mda is not listed in the Expression Builder i.e. although I can use the...

I have created several functions that are contained within a module called My Functions saved in an Add-In database called MBC_Functions.mda I want to make the Add In available to other users - how can I do this? I have tried making entries in the USysRegInfo table of MBC_Functions.mda by...

I am using Office 95. I have several graphs embedded in individual forms each with some code linked to the OnOpen event that sets the MinimumValue of the Y axis. The forms are then embedded in a report. I have to do it this way because the code to set the MinimumValue will not work on the...

I realise MSGraph can only be used with another application but why do I get a runtime error 429 ActiveX component can't create object when I use CreateObject("Graph")?

I have trie instantiating Excel an Graph by using CreateObject but I'm clealry not using the corect syntax. Can someone send me the code - all of it including the Dim statements to open Excel, insert a column, and then release Excel. Hopefully I can then amend the code as necessary. Thanks

I need some code to set the Y values in Graph. I have already had some advice but the code doen't work for me. I am a novice at VBA and my attempts to modify the code have been unsuccessful. My latest attempt is: Dim myGraph As Object, myChart As Chart Set myGraph =...