76

(6 replies, posted in General)

Hi
is it possible that after clicking on the reset button, a message box is shown that says "Are you Sure?"
thanks

77

(5 replies, posted in General)

Hi
Is your script supported in Version 1.45?
could you possibly make an example for this version?
thanks

78

(5 replies, posted in General)

Hi
in the phone book sample when you want to show a record in a tablegrid, for example first name, last name and phone number
if a person has two phone numbers, 2 records are shown in the tablegrid with the same first name and last name
is there any way that the first column of the tablegrid has only one row (First name) and the second column also has one row (Last name) but the third column has two or three rows (2 or 3 different phone numbers)???
thanks

79

(1 replies, posted in General)

Hi
In my project there is a TableGrid with 5 to 10 rows.
when I want to show the rows in Report Designer, only the first row is shown.
is there any script that shows each row in a separate line in the Report Designer ?
thanks

80

(1 replies, posted in General)

Hi
In my project there are two checkboxes. one is "junior" and the other is "senior" and when one of them is clicked, the other becomes disabled.
in the report designer when I click on one of them, it writes only 1 when it is enabled and 0 when it is disabled
the question is:
is there any way that whichever I click, in the report designer instead of 1 and 0, it writes junior or senior?
I know that using ComboBox is easier but in my project I need to use checkboxes.
can you fix this problem in the attached project?
thanks

81

(5 replies, posted in General)

Thanks
It works fine except the Excel part
the whole idea is that when I filter the search for example when the Tablegrid only shows "First name" and "Last name" , a button exports only these rows to Excel.
but in your script no matter what checkboxes you click, Excel Button export all the Tablegrid rows to excel form
can this be fixed?
thank you

82

(5 replies, posted in General)

Hi
thanks for your reply
I know that but when you leave a textbox empty, and search another textbox, the tablegrid  shows all the textboxes .
for example suppose that There are 4 textboxes: First name, Last name, Date of birth, Father's name
what I want to do is that when I search textbox " first name" and "last name" and click on the search button, the tablegrid only shows first name and last name and accordingly I can export only first name and last name fileds to Excel.
but in the case that you said when a textbox is empty, tablegrid shows all the textboxes.
is there a script for the search button that when you press it, the tablegrid only shows textboxes based on the textboxes that I choose?
for example sometimes I like the tablegrid to show only first name and last name not date of birth and father's name
and sometimes I like the tablegrid to show last name and father's name and not first name and date of birth
is this kind of filtering possible at all?
thanks

83

(5 replies, posted in General)

Hi
In my project there are 20 textboxes. is there any way that for each textbox, I place a checkbox related to that textbox in order to filter the search.
for example when I click on the checkbox1 in the search form, the search button only searches the textbox1 and  tablegrid shows only the results of the textbox1
and when I click on the checkbox1 and checkbox2, the search button only searches the textbox1 and textbox2 and The tablegrid only shows the result of textbox2 and textbox3
could you please correct the attached project?
is it possible using version 1.45?
thanks

84

(2 replies, posted in Script)

Hi
I have two separate script for one button. both of them should be OnClick. Is it possible? If not, what is the solution?
For example: The main button which saves the project has two scripts:
One Script is CopyTo command  and it save the DBFile in a directory
and the other script is "CheckDublicate"

85

(6 replies, posted in General)

Thank you
your script works fine but the DBFiles still saves the file in a folder named Record1 and Record2 and so on.
is it possible at all that instead of saving files base on records, DBFiles save the files in a folder with the names based on the textboxes "edFistName + edLastName" ???
for example the DBFile1 of the first record are saved in this directory: "files\john+smith\a"

86

(6 replies, posted in General)

Hi
I have solved the 3 DBFile problem myself.
but I don't know the script for the other problem. please help me to correct the attached project
what I need to do is that the address in which these 3 DBfiles are saved, should be like:
DBFile 1:  files\first name+last name\a
DBFile 2:  files\first name+last name\b
DBFile 3:  files\first name+last name\c
as you can see all of them are save in one directory but separate folders . for example:
DBfile1 of the first record goes to "files\john+smith\a"
DBfile2 of the first record goes to "files\john+smith\b"
DBfile3 of the first record goes to "files\john+smith\c"
thanks

87

(6 replies, posted in General)

thank you so much
can this script be used for 3 DBFiles?
I have decided to use 3 DBfiles in my project with your awesome script.
and also is there a way that instead of the name "Record1" each file is saved in a folder with the name "First name + Last name" ?
thanks

88

(6 replies, posted in General)

Hi.
in my project there is a DBFile which is set on LinkFile and has a CopyTo command.
is there any way that the DBFile save each record in a separate folder?
What I mean is that when I save a the first record, the DBFile save the related file in the Folder "Record1"
and  when I save the second record, the DBFile save the related file in the Folder "Record2" and so on
thanks

89

(5 replies, posted in General)

thank you
I did as you said and it worked
but there is another problem: in Form 2 the action of the button2 (Add button) is set on "New Record"
what I like to do is that I need to specify many details about the staff of an office. all of these details are defined in textboxes which are about 20 textboxes and there is also a TableGrid which I can't place it in the Form2 so I have no choice but to place this TableGrid in another Form which is Form3.
the problem is in that TableGrid there should be the data related to only one staff but when I click on the button2 (Add button) to add a new record, all the data related to every staff can also be seen in the TableGrid
By the way in the properties section of the TableGrid I did not check the "Auto Execution of the query" so why all of the new records that I save is in that TableGrid???
Do you get what I mean?
thanks

90

(5 replies, posted in General)

Thanks Derek for your fast reply
You said :  in Form 4, I added "formtwo" records without relating them to a parent "formone" record.
How can I do that?
thanks

91

(5 replies, posted in General)

Hi
In My project I have encountered a problem so I make another project which is like mine but simpler.
the problem is when I want to save the textboxes in form4 it displays an error: ( Not Null Constraint Failed: formtwo.id_formone )
I know there are other ways to save the textboxes but believe me my real project is bigger than the attached project and it has about 20 Forms and I can not delete any forms.
So please do not change the Forms in this project, just tell me what I'm doing wrong?
by the way I'm useing version 1.45
thanks

no that did not do what I wanted
Please download "DOTTracker.zip 28.52 kb" above
go to the "InspectionForm", there you can see a combobox and in front of it says : Vehicle
when you run the project, as soon as you choose something from that combobox, other information are shown in the textboxes below that combobox.
what I like to do is: instead of the combobox, I use a textbox that does the same.
it should not be incremental search because  incremental search only shows the records on a TableGrid and I don't want the records to be shown in TableGrid. I like that records are shown in textboxes
thanks

Please help me with this
in the "InspectionForm" of this project , there is an script on the combobox "Vehicle"  (OnChange).
Is it possible that instead of the combobox, we use a textbox???
For example upon filling this textbox,  based on the data in the textbox, an script shows the data in other textboxes in that form.
Do you get what I mean?
thanks

94

(13 replies, posted in General)

hi
I have the same problem
is this script can be used for version 1.45?
I used this script and it said undeclared identifier "ChangeKeyboardLayout":(
what can I do?
thanks

95

(1 replies, posted in FAQ)

Hi
Is this possible that the GridTable only show one row; and after trying to insert the second row, an script show an error message saying "This table is full"???
also I'm using version 1.45
thank you for your help as always

Hi
in the "InspectionForm" of your project you defined an script on the combobox "Vehicle" OnChange.
I need something similar to your script.
Is it possible that instead of the combobox, we define a textbox and a button. when inserting numbers on the textbox and then press the button, the script is triggered based on the data in the textbox and then shows the data of other textboxes in that form???
thanks
By the way I'm using version 1.45 sad

97

(11 replies, posted in General)

thanks for your reply
but I can't run your project. I'm using version 1.45
is your script available in this version?

98

(11 replies, posted in General)

Hi
I want to make a project that shows the records on a map.
suppose that I have a map of a city. what I want the project to do is that first I define some codes for several areas in this city on the map using script or report designer and then for each record I also define a code.
and when I search the record, that record is shown on the map based on the code.
this is a real estate Project and the objective is that each code on the map is for a house. and also each record is for the person who lives in that house. I need to know where each person lives on the map.
Is it possible at all?
thanks

99

(25 replies, posted in Script)

Hi jean.brezhonek
Yes Very Strange
mine does not work correctly. I have downloaded your attachment and it also has the same problem. I'm working with 1.45 and 2.3 portable.
both of them are the same. In the form "frmstudent" when I press add the message"you have to fill the blanks" is shown and when I click on "OK" then the other form comes

100

(25 replies, posted in Script)

thanks for your reply
Could you please elaborate on you another way of checking empty fields?
are there any other ways to do it?