Recent content by MobiusDick

Hi RuralGuy, Thank you very much- does exactly what I wanted now- such a simple change too!! :)

Hi All, I have a form with a listbox. Underneath this listbox I have a command button that selects and deselects all of the values in that list box, however, I can't seem to make it a continuos loop. i.e. I can select the data and then deselect the data- but only once. Does anyone have any...

Hi All, If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it. Specifically I'm trying to change the menu bar's /database window's property to match my forms (and...

Not sure what's going on then as it didn't work prior to setting the references and now it seems to. Prior to setting the references I was getting a User defined variable error. It all seems weird. Thank you for your help though- wouldn't have been able to solve it without.

Hi Bob, Thanks very much for that it seems to have solved the problem- I didn't help myself by not setting references to recognise Excel too. Mark

Hi, Try using the shell function as follows: If Shell("C:\Program Files\Microsoft Office\Office\WORD.EXE", vbMaximizedFocus) = 0 Then MsgBox "Failed to open MS Word" End If If you replace the C:\.... string with the location of your file this should work.

Hi Bob, Thanks for the reply; however, I was already using the late binding method you have described please see code below: myTableName = "tblHHForecast" myFullExcelSourcePathName = "M:\Forecast Calculation Data\HH Forecast\HH Forecast.xls" '''Full path of your source Excel data file xlApp =...

This forecasting tool is turning out to be quite a lot of hassle. Have written a sub within a module which makes the user answer a specific set of questions before the sub transfers an excel sheet to a table- I have used this sub before with no problems (albeit in form modules rather than...

Thanks Neil, I'll experiment with the structure. John_W- you're absolutely right the queries are somewhat more complicated than I expected. The trouble i've found with trying to sum 48 half hourly periods is that Access will only allow a certain number of characters in any calculated field...

Hi Neil, My apologies- its not that often people are familiar with HH data. Could you explain what you mean by one additional table- I am interested to understand. Cheers, Mark

Hi Neil, Unfortunately the nature of the calculations I have to perform and the amount of data required to calculate anything where electricity is concerned make it almost impossible to seperate into separate tables as you suggest. To explain- if you have 8 profile classes all requiring a...

Hi DrSnuggles, Thanks for the reply- Yes that is what I am trying to do. Hope you can help.

Hi Everyone, I'm having a slight problem summing (almost) an entire recordset: I have an application that when given a table of customers and their estimated annual electricity consumption will generate a matrix of coefficients that gives a typical consumption profile (i.e. how much...

I have come across this problem and the only way I found to get round it is to write the data to a table and use the DoCmd.TransferSpreadsheet method which will allow you to output up to the Excel limit of records. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblqry2009QA"...

Thanks very much DJKarl that has done the job nicely.