Search results

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

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

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

Hi All, Having a bit of a nightmare with this bit of code which is intended to ensure that users have selected certain dates before allowing them to proceed and run a section of the app. The problem is it's just not working- it's assigned to a click button on a form which allows users to...

Sorry about the duplication- have had some weird Network issues, and I thought it hadn't posted.

Hello Everyone, I'm having a slight problem with file renaming at the moment- Basically I have an application that has a form ([frmSplitter]) that users enter a start and end date into. The application then goes away does a series of calculations and outputs the results into an Excel...

Hi All, I'm in the process of creating a database that allows users to enter details into a form which includes a date range as start and end dates. I have used the inbuilt Calendar Control 10.0 control to allow users to select the date. It is linked to two combo boxes [cmbStartDate] and...