Search options (Page 79 of 104)

Hi There,

In a script, you could use something like this:

procedure Form1_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
  openfile('C:\Documents and Settings\user\Desktop\blackpearl\red\red.exe');       //*** calls another MVD program (called red.exe)
end;

procedure Form1_Button2_OnClick (Sender: TObject; var Cancel: boolean);   
begin
  openfile('notepad.exe');                                                                                    //*** calls notepad.exe (no file specified)
end;

procedure Form1_Button3_OnClick (Sender: TObject; var Cancel: boolean);   
begin
  openurl('www.myvisualdatabase.com');                                                        //*** calls the specified website using your default browser
end;

begin
end.

Regards,
Derek.

Hi Alex,
Have a look at the attached which does most of the things you mentioned (well, it should but I've not really tested it!).
There are 2 basic ways of approaching it - using a single table (which I've done because it was quicker) or using a second, related table which would hold details for each cycle of depreciation for each asset - it's probably the way to go if I were doing it 'for real'.
Each asset is set up with a purchase date, purchase price, depreciation rate and number of days between depreciation cycles.  After that, the main grid shows in red assets that are due to be depreciated and, when you select one, the 'depreciate' button is visible.  Click it and it automatically calculates the depreciation and deducts it from the asset book value.  It also calculates when the following depreciation date is due.
Once depreciation starts, I 'lock' some of the asset details (ie price, rate, date etc) otherwise it would invalidate depreciation that has already occurred.
Anyway, I'm sure you'll get the picture and hope you can use some of it in whatever project you have in mind.
Regards,
Derek.

Hi,
Please see attached (using your example, there are some assets and when they are more than 365 days old, the option to enter disposal details becomes available).  I've hard coded it for 365 days but it's just as easy to make that dependent on the record itself (in your example, some assets might be disposed of after 1 years, some after 3 etc etc).
Obviously, it doesn't have to be a button that's enabled - it can be ANY object that can be placed on a form or, indeed, ANY property of that object (the one that is probably used more than any other is setting a cell's colour in a tablegrid depending on elapsed date, value threshold etc). 
Regards,
Derek.

Привет, Михаил,
Возможно, попробуйте это так.
Надеюсь это поможет,
Derek.

Hello Mikhail,
Посмотрите пример и на скриншот (mikhail panel.jpg).
Если вы поместите все свои поля на панель, вам нужно только включить / отключить панель.
Я использовал другой цвет для панели, чтобы вы могли ее легко увидеть, но обычно это тот же цвет, что и фон формы (чтобы сделать его невидимым).
Надеюсь, это имеет смысл (с помощью Google Translator).
Regards,
Derek.

You're welcome.
Just a thought, but if you want to colour code the text rather than the background, you might want to switch bold on as well, otherwise it can look a bit washed-out!
If you do, add to the script  -  form1.tablegrid1.cell[1,vi].fontstyle := fsbold;
Regards,
Derek.

Hello Mikhail,
Я не считаю, что это важно, где находится идентификатор.
См. Прилагаемый пример.
С Уважением,
Derek.

Hello,
Вы можете использовать тот же tablegrid.
Чтобы сбросить таблицу после поиска, просто снимите критерии поиска.
Посмотрите прилагаемый пример.
Regards,
Derek.

Hello
Возможно, вы можете сделать это так?
Derek.

Здравствуй,
Возможно, вы могли бы попробовать это так.
С уважением,
Derek.

Hi There,
I'm not sure I understand the requirement properly.
For each respondent, you need to know
1.  respondent identifier (presumably anonymous - (counter?)
2.  Question 1 - what state they reside in (combobox with a list of states)
3.  Question 2 - what sex they are (combobox with a choice of genders)
But Queston 3 is where I start to get confused;
If marijuana, alcohol, crack and ecstasy are checkboxes, they can only contain responses of 'yes' or 'no'.  So where does your combobox with values of 'yes', 'no' and 'maybe' fit in?  Perhaps you could explain Question 3 in a bit more detail?
Thanks,
Derek.

Hi Kees,
Attached is the way that I've always formatted columns (and footers and headers).  I'm sure it's not the only way but it's always worked for me (so it's what I stick with!).
A couple of things to mention;
1.  in the tablegrid,  columns start at 0 rather than 1 so vergoeding is actually column3 in your example.
2.  you hadn't actually associated the tablegrid1 'onchange' event with the code in the script.
And apologies but I don't have a 'euro' symbol on my keyboard so you'll have to make do with £ - LOL! (just replace £ in the tablegrid properties( footer settings) and in the script).
Anything not clear, then just drop a message.
Regards,
Derek.