Search results for query: *

Wonder if anyone is able to help please (I have scanned through some threads but cannot find a solution). I have a simple query (using Access 2010) where I've used a vba function to use a date field in the query and return a period value (integer). When I try to enter something like >1 in the...

Does anyone know how to create heat maps in excel? The kind I'm looking at are like those shown in the following link: http://www.digitallook.com/cgi-bin/dlmedia/investing/visual_tools/market_maps?&username=&ac= I want to be able to change the size and colour of the boxes

Hi I'm having problems copying a string variable to a cell formula in excel. The string is over 300 characters long and if I type this directly into a worksheet cell it works fine (i.e., the logic is correct as far as the formula goes). The string is simply a long IF statement. However, when...

Does anyone know how to move data from a 3-dimensional array into a 2-dimensional array using VBA in Excel? I'd like to select one dimension and hold it constant and then simply transfer data relating to the other 2 dimensions across into a new 2-D array. Eg., Array1(Colour,Size,Cost) and...

If you right click on the status bar at the bottom of excel you can use the count, sum, min functions etc... Does anyone know how to customise this so that you can have other excel functions such as StDev? I have searched high and low and cannot find any information on being able to customise...

Hi. Has anyone noticed how MS Solver in Excel 2003 produces different optimised results compared to the one in Excel 2000? Does anyone know what the key changes to the Solver add-in have been between the two versions? I've tried looking on the net but struggling to find any useful...

Hi I am experiencing problems with releasing a reference to access from memory. Basically I open up access from excel using vba code (dao), do some querying and then close the access application using the .quit and set = nothing commands. However, an instance of access remains in memory (as...

Can anyone help with my problem. Basically I have a straight forward query in MS Access which makes use of a simple VBA function to performance a series of calculations. This query works perfectly fine in Access. I have been trying to pull results of this query into MS Excel using the Get...

Hi all, I am using Excel VBA to create a query in Access but am having problems with the date field which is a required input in Excel via a InputBox statement. Is there a way to set the format of the inputbox data entered by the user within an SQL statement in Excel VBA? Basically I want to...

Can anybody help? I am trying to launch an access database using the shell function in excel VBA. Unfortunately the pathname has spaces in it therefore I am experiencing problems. Can anyone suggest what I need to do to the following code in order to make it work? : Dim RetVal As Variant...

Hi all I have 2 combo boxes on a form. They are both linked to SQL statements in the row source property. They are actually two sets of dates. Basically I want to set the default value of the first combo box to be it's first date in the list....and the last date in the list for the second...

Hi folks Does anyone know how to change the name of a series contained within a chart legend in Access using VBA?? I currently have a form with a list box. The user selects 2 months. This then drives a query which drives the report (chart). I cannot change the query field headings to...

Dear all I am currently running SQL in VBA (MS Access). I am trying to pass a date field from the SQL SELECT statement to a function and to return a new date based on the function. The code is as follows: "SELECT [TRADEDATE],myfunction(TRADEDATE) FROM myTable" TRADE DATE is a field...

Hi all, I have set up some access VBA code to convert an excel file to a csv but keep getting the regular messages asking whether you want to keep the existing format etc... Does anyone know of a way to turn these messages off or to automate responses to these prompts. I am trying to minimise...

Hi all, I currently have an access97 dbase which regularly imports a spreadsheet. However, this spreadsheet has 3 undesired rows at the top of the single worksheet. Currently I have to delete them manually by going into excel directly and then use the import function I have developed in access...

From time to time I get the following error message when performing simple things in MS ACCESS 2000 (Windows ME). "MS Access has caused an error in Kernel32.dll, MS access will close now, if you continue to experience problems try restarting your computer" Can anyone suggest any...

I am currently using Access97 and up until a short while ago everything was running just fine. In query design view although I can bring tables in and perform calculations on fields, I cannot drag and drop fields from table to table in order to create a relationship between the tables. I have...