1,501

(9 replies, posted in Script)

Hi Gonpublic,
I don't know if there are other ways - this is the only way I know how.
It looks a bit clunky but maybe it does the job for you.
Derek.
.
Sorry K245 - didn't see you'd already replied.

1,502

(3 replies, posted in General)

Hi Teco,
Typical users - LOL!
Perhaps try it like this (see attached).
Regards,
Derek.

1,503

(17 replies, posted in General)

Hi Lejoso,
If you need to see only R63 and not R63, R635 etc, I would suggest changing the calculated field (cfcidsearch) to insert a blank space after every CID number in cfcidsearch (please see the attached amended project).
So now you can enter R (23 records), R6 (13 records), R63 (13 records),  R63 and a space (1  record) or  R635 (12 records) etc. 
This gives you a lot of flexibility to filter in different ways and might be useful as your CID numbers appear to have a structured hierarchy (A00 is for different types of Cholera, A16 for different types of Tuberculosis etc etc).
I've also added a bit of script so that when you single click on a CID number on Form1.tablegrid1, it will show you its description;  because there are so many codes, perhaps this will help your users.
Regards,
Derek.

1,504

(19 replies, posted in General)

You could do it something like this (see attached).
There are other conditions you probably need to consider as well but the syntax is the same.

1,505

(17 replies, posted in General)

Hi Lejoso, Hi Sibprogsistem,
I took a different approach and used a calculated field (cfcidsearch) for all of the 'CID' searches;  it seems to work fine.
A couple of questions
1.  why does form1.badd call 'show form' instead of 'new record'?
2.  is there a reason why you couldn't link bienal / cid_a in a one to many relationship rather than using cid_a as a lookup that you repeat 12 times?  It's not really 'relational' in the true sense.  And what if there is more than 12?
3.  You have 14,448 records in a look-up table (cid_a)?  I'm surprised users ever manage to select the correct code?
Regards,
Derek.

1,506

(19 replies, posted in General)

There's no need to use a script - just doubleclick on the edit field that contains your url.
In the example, doubleclick a row in the tablegrid to select a store, then doubleclick the web address.
Derek.

1,507

(10 replies, posted in General)

Hi Madbit71,
I've just tried and it downloaded, unzipped and ran without any problems.
Derek.

1,508

(24 replies, posted in Russian)

Привет Delphinsi,
Другой вариант - использовать вычисляемое поле, которое имеет два возможных преимущества.
1). Это быстрее ввести, чем использовать указатель даты и времени.
2). Это дает гибкость в использовании подстановочных знаков (например - кто родился между 1940 - 1949, вы просто ищете 194).
Может быть, это поможет вам.
Derek.
.
A different option is to use a calculated field which has two possible advantages.
1). This is quicker to enter rather than using a datetimepicker.
2). It gives flexibility to use wildcards (for example - who was born between 1940 - 1949, you simply search for 194).
Maybe this helps you.
Derek.

Здравствуй Metatron,
Возможно, попробуйте сделать это так.
Он работает как с помощью клавиатуры (вкладка), так и мыши.
Derek.
.
Hello Metatron,
Perhaps try to do it like this.
It works both with the keyboard (tab) and the mouse.

1,510

(3 replies, posted in Script)

Hi,
Probably a couple of ways to do it but this way (see attached) is quick and easy. 
You can also use form1.mnixxx.caption := 'Whatever' to personalise the standard menu very quickly as well as form1.mnixxx.visible := false to hide menu options.
Hope this helps,
Derek.

Привет Metatron,
Если я правильно понимаю ваш вопрос, вы можете попытаться сделать это следующим образом.
Но есть и другие способы.
С Уважением,
Derek
(с гугл переводчиком)

1,512

(2 replies, posted in General)

Hi Dmitry,
I never thought of trying it like that - works perfectly.
Thanks,
Derek.

Hi Dmitry,
I have an application (please see attached) that uses an interactive tablegrid (click on Column 4 and it does one thing, click on Column 5 and it does something else).
Because I want to click on a specific cell, I set the 'goselectfullrow' option for the tablegrid to false so only the cell that I am interested in is highlighted.
However, AFTER cell click, the highlight always goes to Column 0 and does not stay in the Column I was working in.
Is there a way to keep the highlight in the original cell I had clicked.
Thanks,
Derek.

1,514

(2 replies, posted in General)

Hi Hedan,
You've got 3 basic options if I understand your question.
1.  Simply use 2 linked grids
2.  Use parent comboboxes
Both Options 1 and 2 use the same data structure.
3.  Use Treeviews
Option 3 uses a different data structure because of how treeviews work.
I've knocked up a simple example of all 3.  Scripting is not required (although I've used a couple of lines just so you can easily expand / collapse the treeview option.
Just shout if anything's not clear.
Regards,
Derek.

1,515

(5 replies, posted in General)

Hi Manixs,
As a work-a-round, you could do something like the attached.
Derek.

1,516

(4 replies, posted in General)

Hi Humblelion,
If you want a simple attendance register, you could do it something like the attached.
Each employee selects his name from the combobox and then enters his password.  If the password is correct, he is signed-in (with the date and time).  Exactly the same happens when he signs out from work.
If he successfully signs-in or signs-out, there is a delay of 3 seconds so he can view the update to make sure his details are correct.
Sign in using user 'Admin' and a password of 'Admin' (case sensitive) and you will get access to a second form where you can maintain employee details and also view the passwords for some dummy users that I've set up for testing purposes.
Hope this gives you some ideas,
Derek.

Привет Ffpereverzeff,
Пожалуйста, найдите прикрепленную программу чата, которую я написал несколько лет назад.
Он не пытается делать ничего, кроме обмена сообщениями чата (сохраняет их, если получатель не в сети), поэтому это ОЧЕНЬ просто, но это то, что требовалось в то время.
Чтобы проверить это, просто войдите в систему несколько раз как разные пользователи (все пароли «123»). Используйте «Admin» для настройки новых пользователей.
Возможно, это дает вам некоторые идеи.
Derek
(с гугл переводчиком)

1,518

(6 replies, posted in Russian)

Привет Иван,
Вот пример с 3 вариантами.
Здесь нет 'script' - вы просто изменяете свойства 'fieldname' и 'filter' для 'combobox'.  (см. также включенный скриншот.jpg)
Вариант 1 показывает только товары, которые есть на складе, но вы не знаете, что временно отсутствует на складе.
Вариант 2 показывает все товары и сортирует их в зависимости от того, есть ли они в наличии или нет
Вариант 3 показывает все продукты, сортирует их в зависимости от того, находятся ли они «в наличии» или «нет в наличии», а также показывает текущий уровень запасов.
Это зависит от того, что вы считаете наиболее полезным.
Надеюсь это поможет,
С уважением,
Дерек
(с гугл переводчиком)

1,519

(6 replies, posted in General)

Hi Domebil,
Does doing it like this help you?  (see attached).
Derek.

Привет,
Возможно, вы можете сделать это так (см. Приложение).
Вы также должны установить представление ключа для формы (см. Скриншот).
Derek.
(с гугл переводчиком)

1,521

(3 replies, posted in General)

Hi Sonixax,
On Point 4, as Dmitry says, it's not possible to use 'tab' to move from one field to another.
However, if you tick 'goarrowkeyexitediting' (see attached screenshot), you can use the arrow keys to move from one input column to another.
This also works when you are editing cells in the grid, so you can go up, down, left and right; so it's probably more flexible than 'tab'.
Regards,
Derek.

1,522

(2 replies, posted in General)

Hi Adam,
Does this fix it for you? (see attached).
When I was doing a test, I found it was possible to create a transaction record with a null transactions.id_transtree so I stuck a line of script in to stop it happening (but you may be taking care of this elsewhere, in which case just delete it)
Derek.

1,523

(2 replies, posted in General)

Hello,
Is this the sort of thing you want? (please see attached).
In this example, you search by (partial) name to retrieve a sub-set of rows, then pick a date and update the selected rows. 
If you want to update all rows, just leave the name search field blank.
Regards,
Derek.

Hi,
Yes, it should still work.
However, you might want to force the calculated field to always show to 2 decimal places, in which case you could alter the calculated field format with the 'printf' command (please see attached).
Derek.

Hi,
If I understand your question, perhaps you could use a calculated field (please see attached example).
Regards,
Derek.