Search options (Page 78 of 104)

Hi Dmitry,
Thanks for information about <font color=?> - reports look much better now with combinations of color and highlighting.
Derek.

Здравствуйте zc13569,
Надеюсь, я понял ваш вопрос.
Возможно, вы можете сделать это так (пожалуйста, посмотрите на приложение - извините, но это на английском).
это смесь фильтров и небольшой скрипт.
Надеюсь, это поможет.
Derek.
(с переводчиком google)

Hi Dmitry,
Perfect - much more straightforward now for the user.
Thanks.
Derek.
.
(for general info' - depending on your set-up,  it might not always be form1.tablegrid1.dbpopupmenu.items[5].click.  For example, on my version, it's  form1.tablegrid1.dbpopupmenu.items[4].click)

Hi Chrisyoco,
You have a couple of options - one without a script and one with a script.
1.  Without a script.
Use a calculated field - have a look in the 'datatables'section at the 'cfexipirydate' field to see the syntax.  There is no possibility for the user to edit the expiry date because it is calculated rather than input and stored.
2.  With a script.
The script is triggered whenever the inspection date is changed.  In this example, I have placed the expiry date on Form2 (so you can see how it changes as the inspection date is changed) but I have set the 'enabled' property of the expiry date to 'false' so that the user can't amend it.
Hope either of these two approaches helps and if something isn't clear, just leave a message in the Forum and someone will get back to you.
Regards,
Derek.

Hi,
There are a couple of ways to disable the close(x) buttons involving the form object properties so it's worth trying combinations till you find the one that suits you best.
For me, I would select 'bsdialogue'  from the 'borderstyle' property and remove the ticks from all the 'bordericons' property (see attached screen shot and project).
Regards,
Derek.

Hello,
Попробуй это.
Теперь вы можете очистить все 4 поля с помощью кнопки 1 или каждого поля отдельно.
form1.edit1.setfocus помещает курсор обратно в edit1 (вы можете сделать это, щелкнув мышью, но это лучше для пользователя, я думаю).
Но вы можете удалить form1.edit1.setfocus из сценария, если вы этого не хотите
С уважением,
Derek.
Извините TroNaDor - я не видел, что вы уже ответили

Hi,
The problem with the 'companyprice' and 'sellingprice' columns is that the fields (I'm guessing) are defined as 'real';  I would change these to 'currency' and make sure that 2 decimal places (the default) is checked.
Please have a look at the script in the attachment which may help. 
In the script, I've added lines to right justify the headings for numeric columns (I just think it looks neater), which may be something you're also interested in doing.
Also, I've added a currency symbol (in this example just to the footer formatting).  Again, it may be something you might want to use.
Regards,
Derek.

Hi There,
Sorry about that - I was trying a couple of things (adding an '=' sign or changing colour when the score is the same - but it may be overkill for what you want) and forgot to reset the data types (see attached).
Regards,
Derek.

Hi,
It works okay for me (I tried it with the Phone Book and the Equipment Inventory applications).
Derek.

Hi Lejoso,
Yes, you can use comboboxes instead of fields - the logic is the same.
But when you use comboboxes, you need a second table (I have called it 'types') where you enter the type of 'proc'.
Because you have 3 Procs, you have to define the relationship between the 2 tables 3 times.  And then you also need to create two extra calculated fields to hold the description of Proc2 and Proc3 so that you can see it in the tablegrid.
Please have a look at the attachment and I'm sure you'll be able to follow what I've done.
Regards,
Derek.

Hi,
Welcome to MVD!
Here's a link to a good reference:
http://myvisualdatabase.com/download/Bo … tabase.pdf
When you are ready to write your application and you have any specific questions, just ask in this forum and I'm sure somebody will be able to help you out.
Derek.