Replies

Let’s define the constants:
Total Volume = 500
Max Gross = 100
Let’s Define the Known Variables:
Avarage price
Volume Sold

Your Formula would then be:

(Max Gross-(Vol Sold x Avarage Price))/(Total Volume – Volume Sold)

or: (100-(Vol Sold x Avarage Price))/(500 – Volume Sold)

Thank you for pointing me in a direction, I will investigate further.

Run a first query to Determine the totals:

SELECT Table1.Hora, Sum(Table1.Volume) AS SumOfVolume, Table1.Unidad
FROM Table1
GROUP BY Table1.Hora, Table1.Unidad;

Then run a second query on the first query to return the max:

SELECT Max(Query1.SumOfVolume) AS MaxOfSumOfVolume, Query1.Unidad
FROM Query1
GROUP BY Query1.Unidad;

Where/what does it link to? what happens if you follow the link?

Does it occur in random cells or only in a certain range?

The fields updating from does not all reside on the subform, though some do. I fixxed the code by adding Parent. in front of all field references.

Duh – Icecream to my forehead!

Well the decision was basically made for me; I have to make do with what is currently available to me; so in my opinion the best option is SharePoint back end with Access front end. Due to the licensing cost, I have to make do with SharePoint Foundation so I have to manually create the SharePoint lists (which I suppose is not really that big an issue).

So with the baseline set, I will be starting to ask more specific questions on separate threads

Thank you for your input, in my opinion the best compromise between cost, scalability and ease of access would be an independent domain with a MySQL back end and PHP front end. Thus it would even be viable to have the claims compiled authorised and approved online, but this is not in line with the company IT policies. Unfortunately what is in line with policies costs money and getting that approved is a nightmare. To have all employees compile their claims online we are looking at around 25 000 licenses…..

Thank you, it is possibly the best way for me to go. The main reason I want to go with help files is to provide the users with graphical step by step instructions.

I sometimes feel that Users=1D10t5! For example there is one cell asking a yes/no question. the answer cell has a comment “Please select Yes or No.” It has a drop down selection of blank, Yes and No. If anything else is entered a error message pops up stating “Please select ‘Yes’ or ‘No'” with a “Rety” button. Then I get a phone call “Your form will not allow me to fill in this field”. When I ask what she want to enter there I get “X”

In the past I have tried data validation, Cell comments, displaying warnings by using a combination of conditional formatting and if statements. to no avail, the project is a claim form that must be completed, printed and signed. At the top is a messega in bold red that states “If any field remeans YELLOW, the claim will not be approved.”

If the form is not fully completed, the signiture and Authorisation blocks is blacked out with a message in yellow stating ” Some required details missing from form, please complete any fields stil yellow in” and then the first section of the form that is not correctly completed. I still receive forms printed with the error messege and the calimant and authoriser just signed elsewere on the form.

At this stage I am seriously contemplating disabling printing untill the form is correctly completed. (I am willing to bet that somebody would make a screen dump and print that).

I found this, it does not use ActiveX at all and fits in with what I need, my only problem is that using it as is, the funcionality is available in the whole sheet, I want it restricted to the range A15:E34.

http://www.ozgrid.com/forum/showthread/?t=142603

Thank You, I still need to find a way to bundle the help files with (preferably in) my workbook, as (99 + 1)% of the people using the workbook will not save the help files even if I beg them to!

Since I already have to force them to allow the use of macros before they can use the relevant sheets in the workbook I am thinking that I should build in some form of check to see if the help files is available on the pc and install them if the are not.

Any Ideas?

PS: Should you want to use other mail fields than those listed above, you have to use MS Access and not Excel.

Ensemble

Exporting would be slightly different depending on what version of outlook you use:

Using Outlook 2010:

go , , ,

Follow the wizzard steps, selecting your folder.

This will export all the mails in the folder to excell. The following fields are exported:

Subject
Body
FromName
FromAddress
FromType
ToName
ToAddress
ToType
CCName
CCAddress
CCType
BCCName
BCCAddress
BCCType
BillingInformation
Categories
Importance
Mileage
Sensitivity

In excel you can incert a column to the right of the “Subject” column and enter a formula

=LEFT(A2,2)

into cell B2, copy this cell and past it in all the lines in B column (inserted column).

Now you can filter the worksheet to exclude “RE” and “FW” in the B column and include only the required sender in the “FromName” column and your required date range as well.

This is the long way to do, I am sure there is a shorter way, hope somebody can enlighten us.

Ensemble

WHY?

With Excel 2010 this does not work. A similar Active X controll is available in the professional version only. The problem is that there are noe forward, backward or sideways compatability. So even though I can create a workbook with this function, when I mail this workbook to any person who does not have Excell 2010 professional it will not work. I have found VB code that can be embedded in the workbook as a work-around, but my problem is that with this module, I can not select a cell and set the property to display the date picker for that cell only.

Any ideas or alternative method to accomplish this:

1. Create a workbook in Excel 2010 that includes specific cells that the data can only be entered into by datepicker.
2. The datepicker has to be a workbook module.
3. The datepicker has to offer compatibility with the full range of excell version.

Thanks.

Ensemble

WHY?