Hi,
After a crash i lost my licens number. Is there any way to retrive it again.
Regards
Hedan
1 2023-06-29 08:30:17
Topic: Lost licence number (1 replies, posted in General)
2 2021-06-20 13:06:05
Re: Show records by date (2 replies, posted in General)
Thank you Derek...
Worked fine, but i changed my mind and i think it became even clearer by showing upcoming records in a different color in the TableGrid
ToD := DateTimeToStr(Date);
c := Fakturor.TableGrid1.RowCount - 1;
for i := 0 to c do
begin
If Fakturor.TableGrid1.Cells[3,i] >= Tod Then
Begin
Fakturor.TableGrid1.Cell[0,i].TextColor := clYellow;
Fakturor.TableGrid1.Cell[1,i].TextColor := clYellow;
Fakturor.TableGrid1.Cell[2,i].TextColor := clYellow;
Fakturor.TableGrid1.Cell[3,i].TextColor := clYellow;
End;
Hedan
3 2021-06-19 11:14:07
Topic: Show records by date (2 replies, posted in General)
Hi,
Trying to find a way to view records from today's date onward.
Like [invoiceDate >= Today] in the Query forms Filter field.
Anyone have a solution for this
Regards
Hedan
4 2021-05-17 09:43:58
Re: A need help.... (6 replies, posted in General)
Hi again,
I am ashamed.
I use the program myself in my own computer, so it´s difficult to run on another. Some of the code are hardcoded.God forbid
-
I KNOW, not so good ... Working to get rid of it.
I have spent hours of troubleshooting and one thing is clear... Something is wrong with "Order by" in the TableGrid settings. See "Sort.jpg" or something is wrong with the database file (index) itself. I THINK.
Hedan
5 2021-05-15 11:32:25
Re: A need help.... (6 replies, posted in General)
Hi,
Its very strange. What´s wrong with the year 2020??
If I set the sorting of the TableGrid to "No", everything looks good
If I set the sorting to "Main_Table.Adr" (Customer address), everything looks good
If I set the sorting to "Order by" and sorting field same as above it works for 2019, 2021, 2022 but not for 2020.
What i really want is a sort like Customer Adress and the Date as second sort field.
If I set the sorting to "Order by" and sorting formula to "Main_Table.Adr, Main_Table.Date" it works for 2019, 2021, 2022 but not for 2020.
Is there another way to specify a second sort field?
Regards
Hedan
6 2021-05-14 07:57:26
Re: A need help.... (6 replies, posted in General)
Hi,
It's more complicated than that. Yesterday i found another view in the database showing every year. Here every record has "0,00" in the tablegrid.
As I mentioned earlier, when i open the record in my form, everything is OK.
Summer greetings
Hedan
7 2021-05-13 07:31:51
Topic: A need help.... (6 replies, posted in General)
Hi;
Something very strange have happend to my application.
I keep track of my income and expenses.
The tablegrid that i use to display my records contains a column displaying the amount of money. Suddenly that column displays "0,00" as the amount
when i click on the year 2020. The year 2019 and 2021 displays correct. See image,
Another tablegrid i have displayis all record in the database. In the column for the amount every record is "00,00"
If i open the record the amount is as i should.
What can i do??
8 2021-05-04 09:24:43
Re: Creating a log file (2 replies, posted in Script)
Hi,
Thank you very much! I think that will work
Regards
Hedan
9 2021-04-28 06:51:07
Topic: Creating a log file (2 replies, posted in Script)
Hi,
I want to log new records of a special kind i a log file.
The file exists, so new log entry's is to be added to the end of the file.
Is there a way to do this,
Regards
Hedan
10 2020-08-17 16:23:36
Topic: Script Editor Hangs (1 replies, posted in General)
Hi,
Something strange happens when i¨m typing in the script editor.
Sometimes when i type, the system seems to hang for a few seconds. My typing is in the cache so i don´t lose anything, but... I have tried it on another computer, with the samer result. Have never had this problem before.
-
Has anyone else had this problem?
Hedan
12 2020-01-31 08:50:17
Topic: Dark mode 2 (2 replies, posted in General)
Hi,
I´m struggling with a function to change the interface to "Dark Mode".
I have reached 90% but have problem with ComboBox and DateTimePicker. See pic... "MVD.JPG"
Is there a solution for this it would be great otherwise could it be put on the Wishlist..
Regards
Hedan
13 2019-12-22 20:12:13
Re: Application in Dark mode (5 replies, posted in Script)
Hello Derek...
Sorry to interupt your shopping.I promise to post my questions on a better time. :-)
<>
Hopefully you can take your grandchildren on monday, so turn of your PC/mobile and take good care of them.
<>
Thank you very much for the year 2019 and your outstanding service.
<>
I wish you a merry Christmas and a happy new year
Hedan
14 2019-12-22 10:39:16
Topic: Application in Dark mode (5 replies, posted in Script)
Hi,
i am trying to implement a dark mode function for an application. I think i have reached 90 percent, but
some elements is impossible (I think) to convert to a dark mode.
<>
Elements i have problems with at the moment is ComboBox and DateTimePicker. Is there a solution for this?
<>
To change the Button elements color on backgrund and font would be nice. It works to make own buttons, but it would be so much easyer to be able to change this on the Button properties.
Regards
Hedan
15 2019-12-17 20:36:33
Re: Combobox Index Number (9 replies, posted in Script)
Thank you very much,
That did the trick, very happy you to get this solution.
Hedan
16 2019-12-17 13:32:28
Re: Combobox Index Number (9 replies, posted in Script)
Hi again,
And thanks for your patience...
Don´t really know what you mean with "Check database records". Rebuild index?? How?
A Display of ID for the 25 records i have. See picture.
As i sayed earlier, to get the right value in the comboBox i have to input the number of the item in the combobox.
If i have:
Germany
England
France
Italy
Sweden
Norway
I have to put in the integer 3 to get "France" and not the database ID. Very strange....
17 2019-12-16 15:21:54
Re: Combobox Index Number (9 replies, posted in Script)
Thank you...
One step to a sulotion. It works OK, but i get the wrong index number.
If, i make it the hard way and create the INI-file myself i would put in the integer 3 for item number 3 in the combobx list.
dbItemID returns a integer not even close to 3.
What am i doing wrong??
Hedan
18 2019-12-16 12:59:03
Re: Combobox Index Number (9 replies, posted in Script)
Thanks, but mayby i was unclear what i ment.
When a user selects a country from the ComboBox in the CreateINI_Form, for example "Germany". I really want to write the index number of "Germany" to the INI-file instead of the word "Germany".
So the problem is to get the index number for, in this case "Germany".
Hedan
19 2019-12-15 11:21:14
Topic: Combobox Index Number (9 replies, posted in Script)
Hi,
A "new" ComboBox Index Question.
I have been struggled with this for while now. What i want to do is something like this.
When a user creates a new record i have a combobox in the form with different countries too choose from.
When someone fills in a Company name i check if there is an INI-file in that companys name.
If there is, a number of fields in the form if filled in automatically from the INI-file.
"
Adr := Form1.Edit3.Text;
If FileExists(IFile) Then
begin
ini := TIniFile.Create(ExtractFilePath(Application.ExeName)+ '\ini\'+ Adr + '.ini');
try
Form1.Edit8.Text := ini.ReadString('Settings', 'Typ', '');
-- A --> Str := ini.ReadString('Settings', 'Index', '');
-- B --> Form1.ComboBox1.ItemIndex := StrToInt(Str);
Form1.Edit7.Text := ini.ReadString('Settings', 'PG', '');
Form1.Edit6.Text := ini.ReadString('Settings', 'OCR', '');
"
In the form i got a function, that helps users to create the INI-file.
The user can choose a country from a ComboBox in the form, but i really want to store the index number in the INI-file so that the row
markt A and B above works.
Does anyone have a solution to how to easy find the Index of a value in a ComboBox.
Regards
Hedan
20 2019-09-28 06:50:55
Re: Categorized view/tablegrid (2 replies, posted in General)
Hi again Derek.
Thanks for your quick reply
I will try to implement Example 3
Hedan.
21 2019-09-27 07:32:02
Topic: Categorized view/tablegrid (2 replies, posted in General)
Hi,
Is it possible to create a categorized view in MVD?
In the example below we have boxes containing more boxes. Mbox1 contains 9 and Mbox2 contains 4 smaller boxes.
Without a categorized view and a LOT of boxes there is a lot of scrolling to find the right box
See attached JPG.
Regards
Hedan
22 2019-07-15 16:08:39
Re: Index number from a list of values. (4 replies, posted in Script)
Sorry forgot the ZIP-file
23 2019-07-15 16:01:12
Re: Index number from a list of values. (4 replies, posted in Script)
Hi derek,
I have enclosed an example to show what i´m Trying to achieve.
When you open a record there is a button "Show - Show all from the above country" who will display all records from the field 'Country" in the form.
Maybe there is a better way to do this, but....
Hope you understand me...
24 2019-07-15 07:46:25
Topic: Index number from a list of values. (4 replies, posted in Script)
Hello,
Have struggled with this for a while now, so i really need some help.
I have a Field/Combox in a form with some data:
Sweden
Canada
Germany
France
Norway
Denmark
The number of values in the list increases when a i add a new country.
What i need is a way to find the Item Index for a Value.
InForm.Combobox3.ItemIndex := 4; would fill in the ComboBox3 with the value *France'
But if i want to go the other way and find the Itemindex for 'Norway'. Is that possible?
Thanks in advance
25 2019-06-19 14:28:43
Re: Language for boolean values (5 replies, posted in Script)
Hello Derek
Thank you very much for your fast answer and for getting my problem solved.
Hedan.