Search options (Page 77 of 104)

Hi,
I think the easiest way is either
1.  change the object properties of the edit field to 'currency' and an 'accuracy' of 2 or 3 decimal places, depending on how accurate you want it (please see the attached example and screenshot); 
2.  initially define 'liters' in your data structure as currency to 2 or 3 decimal places.
Which way you choose depends on what best suits your application.
In both instances, it's important to remember that 'currency' is not actually a data type;  it is simply a 'real' data type with some formatting applied to it - the underlying data type ('real') doesn't get changed.
Derek.

Привет, Олег,
Возможно, прилагаемая программа поможет вам изменить фильтр на tablegrid2.
Я также добавил фильтр на combobox1 в качестве альтернативы поиску в tablegrid2.
Есть еще несколько способов.
Надеюсь, это поможет.
Regards,
Derek.

Hello Rob,
Please have a look at the attached.
Typically 'translate' is used to display messages in other languages but you can also simply use it to change the message in the same language (as in my example) to something more relevant to your application.
Here's a link to all the other 'default' messages in MVD that can be changed -
http://myvisualdatabase.com/forum/viewt … 387#p22387
Regards,
Derek

Hello Hmlamprecht,
Welcome to MVD - good choice!
The problem you have encountered is probably because you are trying to divide by 0, but it's easy enough to trap it.
Please have a look at the attached to achieve what you want.
Depending on what you want to do, you could also use a calculated field and not need a script at all.
Any questions, just post a message and someone will get back to you.
Regards,
Derek.

Hi EHW, JB,
Many thanks for both your responses.
As a work-around, your approach of using an sqlexecute to get the hex value by passing the color constant through from the combobox works well enough for what I need to do, so I'll run with that (although I'll put it into a variable and then just use the variable value as I've got about 20 labels that I need to change color on, so it will be quicker that way). 
I had just wondered if there wasn't a way of doing it DIRECTLY from the color constant (a 'tcolortoint'  command - or something of that sort  LOL!), but I guess not.
Jean - interesting bit of code which I'm trying to understand, but it's always helpful to see new things as they are always useful at some stage.
Regards,
Derek.

Hello Chrisyoco,
Can you attach your project so we can better understand what the problem might be.
Thanks,
Derek.

Hi Again Frank,
I should have mentioned in my previous post that you don't actually need to use a script at all if you prefer not to. 
You could just use a search(filter) button to select a row from tablegrid1 and then place the associated image into tablegrid2 (see attached).
Regards,
Derek.

Hello Yuri,
На самом деле это не ошибка, просто сортировка набора символов.
Простое решение (без скрипта) - это создание вычисленного поля, которое делает все значения заглавными и сортирует ваше поле со списком в вычисленном поле. Это не влияет на то, как данные фактически хранятся или отображаются в другом месте.
Возможно, вы можете сделать это так?
Regards,
Derek.

Hello Karim,
Прикреплены еще два способа достижения желаемого (или комбинации).
Это зависит от того, на что вы считаете, уделяет наибольшее внимание.
Regards,
Derek.

Hello Karim,
Вы можете изменить цвет флажка в WindowsXP - после этого он больше не поддерживается.
Вы можете использовать отдельную метку и поместить ее поверх надписи флажка, а затем сделать ее видимой / невидимой и красной / зеленой.
Возможно, проще изменить form1.label.color вместо этого (см. Приложение)
С Уважением,
Derek.
(с переводчиком google)

Hello Jean,
How are you?
I'm not sure what methods you have already tried but I think I would try it like this (sorry but my data is for aircraft, not insects (but the principle is identical)).
https://app.box.com/s/tjyz7448peqh3za0r5tn7gaxh0xniyah
Maybe this helps you?
Regards,
Derek.

Just occurred to me that a much easier and more efficient way to achieve the same effect is simply on 'mouse down' to get the script to move the image a small amount and then on 'mouse up' to move it back again - so no need for overlaying a second image - much cleaner!
Also, if on 'mouse down' you script it to move relative to it's starting position, if you subsequently redesign your form and place the image elsewhere, there is no code to change.
I'm a bit embarrassed I didn't think to do it that way ages ago
Derek