Thanks, Brian,
I can convert my access database (.accdb) to excel worksheet (.xlsx).
Is it possible in this case to search, add, edit or delete records using MVD ?
1 2020-10-04 17:29:31
Re: Create an application that depend on an Excel file (9 replies, posted in Script)
2 2020-10-03 06:40:32
Re: Do something if the preset date has expired (9 replies, posted in Script)
Is this code (based on previous Derek's suggestion, correct?
procedure Form1_OnShow (Sender: TObject; Action: string);
begin
if formatdatetime('yyyy-mm-dd',now) >= '2020-10-05' then
begin
form1.tablegrid1.visible := false;
form1.button1.enabled := false;
form2.show;
end else
begin
form1.tablegrid1.visible := true;
form1.button1.enabled := true;
form2.Hide
end;
end;
begin
end.
3 2020-10-03 06:30:10
Re: Do something if the preset date has expired (9 replies, posted in Script)
What is wrong with this code below?
procedure Form1_OnShow (Sender: TObject; Action: string);
begin
if formatdatetime('yyyy-mm-dd',now) >= '2020-09-05' then form1.tablegrid1.visible := false;
form2.show;
end;
begin
end.
Form2 should be visible only when preset date is expired.
4 2020-10-02 16:06:48
Re: Create an application that depend on an Excel file (9 replies, posted in Script)
Hi, Brian,
I have something similar: an Access database with several columns and lot of records (rows) and nothing else.
I want to search, add, edit or delete records using MVD.
Can you (or someone else) set a simple example?
Thanks in advance.
5 2020-09-28 11:45:38
Re: Do something if the preset date has expired (9 replies, posted in Script)
Thanks, Derek.
6 2020-09-26 10:37:09
Re: Do something if the preset date has expired (9 replies, posted in Script)
I suppose the Form1.DataTimePicker1_OnChange event should be used.
procedure Form1.DataTimePicker1_OnChange (Sender: TObject; var Cancel: boolean);
begin
// Need this part of code. If date eg 30.12.2020 is expired, do something (disable Button1, make invisible the TableGrid1 or open Form2.
end
Form1.DataTimePicker1 is not visible.
Any help?
7 2020-09-24 04:39:10
Re: Do something if the preset date has expired (9 replies, posted in Script)
Thanks for the replies, but I would need something very similar to that.
The DataTimePicker1 should not be visible.
I should add to the code the preset fixed date and if it is expired, do something.
I don't know how to do it.
8 2020-09-22 15:03:40
Re: Do something if the preset date has expired (9 replies, posted in Script)
Thanks CDR,
How should look like that part of code for DataTimePicker1 ?
Probably in Form1_OnShow event?
Thanks in advance.
9 2020-09-19 06:24:38
Topic: Do something if the preset date has expired (9 replies, posted in Script)
I want to add the piece of code to my script that will do something (make invisible a TableGrid1 , dissable button1 , show message or clear the table) if the preset date has expired.
Any suggestion?
10 2020-09-10 15:11:55
Re: FORM ALWAYS TOP (6 replies, posted in General)
Useful tip, Derek,
Can it be implemented on main form (Form1) to determine form start-position on screen?
Eg, top 0, left 0 or center position or whole screen (depending on screen-size)?
11 2020-07-13 13:57:18
Re: Backup and Restore Tables (6 replies, posted in General)
Hi, Derek,
Please give a little more explanation for us beginners.
What means:
" (just edit 'backup.bat' for your own needs)."
It is not clear to me how backup is achieved.
Thanks in advance.
12 2020-07-08 04:47:27
Re: Save a file in a separate folder (8 replies, posted in General)
Hi, Derek,
Thanks for your example.
It is very useful.
Just one more thing.
If I click to X button in form1 to delete the highlighted file, this action will delete a file from the database only, not from "files".
What should be added to delete the selected file in "files" at the same time?
13 2020-06-11 12:35:21
Re: Image on Report Problem (3 replies, posted in Reports)
What to do ( in same example) if I want to change the image, ie. print the image that is currently in DBFile1?
14 2020-06-04 09:39:35
Topic: Clear and Delete from the storage file (1 replies, posted in General)
I store all the attachments using the StoreFile in a separate storage file inside the database folder.
If I click to Clear this file will be deleted from the database but still remains in the storage file.
Is there a possibility to add an option that will Clear and Delete from the storage file.
It would be nice if this option is valid only for files in the storage file.
15 2020-05-26 07:18:08
Topic: Convert Excel database to my visual database (0 replies, posted in General)
If all my data from TableGrid1 are saved in Excel file as a backup, can I use this somehow to restore data to my database in case of any data loss? How?
And one related question, is there a simple way to convert an Excel database to my visual database? It would be nice to see an example.
Thanks in advance.
16 2020-05-23 06:25:56
Re: Save a file in a separate folder (8 replies, posted in General)
Hi, Derek,
Thank you very much.
As always, your explanation is clear and very helpful.
In addition, if I want to make a link to the whole folder containing several things, I should insert it in some zip file first.
Am I correct?
Thanks again.
Regards
17 2020-05-22 12:54:30
Topic: Save a file in a separate folder (8 replies, posted in General)
Can anyone show an example of how to save a file in a separate folder instead of a database?
How to link a file to a database?
Thanks in advance.
18 2020-05-21 18:01:46
Re: Insert link in the pdf report (1 replies, posted in Reports)
I already found it.
URL at Properties.
19 2020-05-21 15:30:47
Topic: Insert link in the pdf report (1 replies, posted in Reports)
I am creating the report page that could be saved as a pdf file.
Can I somehow insert a link in the report page that will be active if the report is saved as a pdf file?
Regards.
20 2020-05-17 07:17:06
Re: How to edit saved report file? (3 replies, posted in General)
No.
After CTRL+P only my default printer is open.
It seems to me I should select the report file .fr3 and then select Open in Designer.
21 2020-05-16 17:54:11
Topic: How to edit saved report file? (3 replies, posted in General)
Can I edit the report file that is already saved?
22 2020-05-15 13:03:34
Re: Clear all the textboxes from the form (4 replies, posted in General)
Hi, sibprogsistem,
Thank you for solution.
23 2020-05-14 14:16:40
Re: An issue with print report (2 replies, posted in General)
Hi, Derek,
Thanks for the quick response.
It's resolved.
It was my negligence because the fields in the form were empty.
Regards
24 2020-05-14 08:44:03
Topic: An issue with print report (2 replies, posted in General)
Me again.
I'm trying to create a print report (using a report designer) for a specific record from the database I created.
I tried to put some text and drag a component from the table (see screen image), but after opening in preview mode only the text remains. Data from the table is missing.
Where did I go wrong?
Regards.
25 2020-05-13 06:06:38
Topic: Clear all the textboxes from the form (4 replies, posted in General)
I want to add a new " Clear" button on my Form1(Search form) that clears all the textboxes in this form before the new search.
How to do this?
Thanks in advance.