hello freands can i connect to existing mdf file in the server and how to do that ?
2 2018-01-18 10:31:51
Re: Final version 4.0 (20 replies, posted in General)
i need the free version where i can find it
3 2017-03-06 09:51:14
Re: Update records in database from different forms (7 replies, posted in Script)
Thank you gonpublic2k i'll post mine when it finiched too its rich with examples thank'x too fto this forum and his admin and members.
4 2017-03-05 21:19:07
Re: Update records in database from different forms (7 replies, posted in Script)
can i see u'r emplyee project for taking an idea me too i am working on that project and it is verry complicate
5 2017-03-03 16:17:48
Re: can i maximize form slidly (2 replies, posted in General)
ok thank'x for reply brother
6 2017-03-02 15:48:52
Topic: can i maximize form slidly (2 replies, posted in General)
can i maximize form slidly with script and add some effects to closing fomrs
7 2017-03-01 18:00:25
Topic: need to know (1 replies, posted in General)
hello admin
i need to know if i finish my project with trial version 3.2 can i run it in auther computer or mvd ask me to activate if trial version finish
its must instal mvd in the auther machin or just run the exe file
9 2017-02-28 13:54:14
Re: sloved (7 replies, posted in Script)
we have evry 2 year 1 grade but the Time period from date enter to 14/04/2010 is calculated 1/2 + Time period from 15/04/2010 to 31/12/2016
10 2017-02-28 13:45:17
Re: sloved (7 replies, posted in Script)
i mean if date_enter with is Grade.DateTimePicker1 > 14/04/2010 (Grade.DateTimePicker2) or 15/04/2010 (Grade.DateTimePicker3)
get the result just from Grade.DateTimePicker1 to 31/12/2016 or Grade.DateTimePicker4
i try to get the solution with false and true
11 2017-02-27 17:16:33
Re: sloved (7 replies, posted in Script)
is attached my project thank you señor
12 2017-02-27 07:43:36
Re: Adding Editing Saving on Same Form (9 replies, posted in General)
just add function new record to the add button and slect form1 and the buttons will enabled
then add event
procedure Form1_Button5_OnClick (Sender: string; var Cancel: boolean);
begin
Form1.edLastName.SetFocus ;
end;
13 2017-02-26 18:10:41
Topic: HELP (1 replies, posted in General)
how can i write conditon
if frm1.datetimepiker1.date < = frm1.datetimepiker2.date then or do
or
if frm1.datetimepiker1.date < = frm1.edit1.date
if isen't null don't calculate
15 2017-02-25 09:37:31
Topic: sloved (7 replies, posted in Script)
hello admin and all members of MVD
here is my script if someone want help me and he want the project i send it
function CalculateDateBetween(StartDate, EndDate: TDateTime): string;
var
YY, MM, DD: Word;
dv, ad, ac: integer;
begin
YY := YearsBetween(EndDate, StartDate);
MM := MonthsBetween(EndDate, StartDate) - (YY*12);
DD := DaysBetween(EndDate, StartDate) - (YY*365) - (MM*30);
//Result := 'سنة,' + IntToStr(YY) + 'شهر,'+IntToStr(MM) + 'يوم,'+IntToStr(DD);
Result := (IntToStr(YY)+' سنة ') + (IntToStr(MM)+' شهر ') + (IntToStr(DD)+' يوم ');
end;
//*********************************************************************************************************
procedure frmEmployee_Button2_OnClick (Sender: string; var Cancel: boolean);
var
s,: string;
begin
Grade.Edit2.Text := frmEmployee.EditCounter1.Text;
Grade.Edit1.Text := SQLExecute('SELECT Name FROM Employees WHERE id ='+inttostr(frmEmployee.TableGrid1.dbitemid));
s := SQLExecute('SELECT Date_denter FROM Employees WHERE id='+frmEmployee.TableGrid1.sqlValue);
if s <> '' then Grade.DateTimePicker1.Date := SQLDateTimeToDateTime (s)
else Grade.DateTimePicker1.Checked := true;
// fixing date in Grade.DateTimePicker2/Grade.DateTimePicker3/Grade.DateTimePicker4
Grade.DateTimePicker2.Date := EncodeDate(2010, 4, 14);
Grade.DateTimePicker4.Date := EncodeDate(2016, 12, 31);
if Grade.DateTimePicker1.Checked and Grade.DateTimePicker2.Checked then
Grade.DateTimePicker3.DateTime := Grade.DateTimePicker2.DateTime + 1;
if Grade.DateTimePicker1.Checked and Grade.DateTimePicker2.Checked then
Grade.Edit3.Text := CalculateDateBetween(Grade.DateTimePicker2.Date, Grade.DateTimePicker1.Date);
Grade.Edit5.Text := CalculateDateBetween(Grade.DateTimePicker3.Date, Grade.DateTimePicker4.Date);
Grade.Edit12.Value := DaysBetween(Grade.DateTimePicker3.DateTime, Grade.DateTimePicker4.DateTime);
Grade.Edit10.Value := DaysBetween(Grade.DateTimePicker1.DateTime, Grade.DateTimePicker2.DateTime);
Grade.Edit11.Value := Grade.Edit10.Value/2;
Grade.DateTimePicker5.DateTime := Grade.DateTimePicker1.DateTime + Grade.Edit11.Value ;
Grade.Edit4.Text := CalculateDateBetween(Grade.DateTimePicker2.Date, Grade.DateTimePicker5.Date);
Grade.Edit13.Value := Grade.Edit11.Value + Grade.Edit12.Value ;
Grade.Edit7.Value := trunc((Grade.Edit13.Value / 365*30*12)/730) ;
frmEmployee.Edit17.Value := Grade.Edit7.Value;
frmEmployee.panel1.Visible := true;
17 2017-02-24 17:56:27
Topic: PROBLEM SHOWIN DATA (1 replies, posted in Reports)
hello
i cant show data to the second report in the same form
any idea
18 2017-02-23 15:39:17
Re: sort combobox HELP PLEASE!! (6 replies, posted in General)
i used this example
http://myvisualdatabase.com/forum/viewt … 159#p19159
19 2017-02-23 12:38:21
Re: Example Combobox script Easy (2 replies, posted in Script)
nice work i'ts help me alot
20 2017-02-22 16:54:51
Re: automatically show dbedit (3 replies, posted in General)
what the reverse off this script
frmEmployee.Edit12.Text := SQLExecute('SELECT TotalD FROM conge WHERE id='+inttostr(frmEmployee.TableGrid1.dbitemid));
i want save record from table to table or bdedit.value
21 2017-02-22 12:48:49
Topic: automatically show dbedit (3 replies, posted in General)
hello evryone
how to show automatically sub (records) in dbedit i mean with relation look at the photos
and my project
user&password admin/admin
22 2017-02-22 08:04:07
Topic: is this a bug ? (1 replies, posted in General)
hello admin is this a bug or becaouse i'ts trial version
using v 3.2
1- can't rename components like edit text, datetimepiker....
2- can't show the fields in tblgrid if i chose (show child recods if present)
23 2017-02-20 20:53:46
Topic: one more question (1 replies, posted in General)
how to change text in the Tgrid header (righit to left) and disable onclick sorting asecending descending in the header
25 2017-02-20 12:37:45
Re: Grid color (5 replies, posted in General)
waw good this is what i want thank you verry happy jajajajajajaja