Search options (Page 99 of 104)

Hello Wildo, Thierry,

I'm not sure I'm understanding what you mean by adjusting the grid size and spacing - do you mean the amount that objects move when you drag them across the form using the mouse?  If so, then you can 'fine tune' it using the LEFT and TOP object properties which moves the object by pixel.

I agree with the comment about copying a form which can't be done within MVD.   However, you can always copy and paste en masse all of the objects from one form onto a new 'blank' form using ALT+SHIFT+click which is pretty quick and easy.
Alternatively, if you want an EXACT copy of a form, I just edit the forms.xml file. 
1.  Open forms.xml using something like Notepad.
2.  Find the block of text where the form you want to copy starts and ends, copy and paste it and then just change the form name. 
3.  Save the forms.xml file, go back into MVD and there your copied form is. 

It takes about 30 seconds.  It doesn't really matter where you actually place it in forms.xml because you can always move it when you go back into MVD by dragging on the form tab.

For new projects, I use a projects template (which has all my standard tables, scripts and forms such as 'sign-on' forms, authorised user forms, help forms - all the stuff I use in every project).  And any forms specific to the new project that I need, I will then copy by editing forms.xml as outlined above.  It's amazing how RAD you can make MVD (great if you're lazy like me!!).

Maybe this can save you some time.

Derek.

Hi Robb,
The relationship specified between your vendor and order tables already filters the orders raised against different vendors.
The filter on the auto-query would be if you wanted to additionally filter certain orders within the selected vendor (ie all orders over £100 or all orders older than 30 days etc).
Attached is a small project which is relevant to your example which might clarify things.
Derek.

Hi Michael, Hi Thierry,
It's as tcoton says - groupbox is basically a cosmetic thing but it does enable you to put things inside a groupbox and move them all together (otherwise you have to use ALT+SHIFT+CLICK to move multiple objects at once).
But it's useful if you want to make certain parts of your form visible / invisible - you only have to set the visible property of the groupbox and everything inside that group box also becomes visible/invisible rather than doing it for each object.  And if you're writing a script to make something visible depending on a certain condition, you only need to script it for the groupbox which can save even more time.
Bringing to the front/sending to the back works WITHIN the groupbox (ie put one object on top of another and you can send to the back / bring to the front).  This is also true on the basic form - it's just not applicable to two objects, one of which is placed inside the groupbox and the other outside of the groupbox.
However, if there is an object that originally was outside the groupbox that you now want to place inside the groupbox, you don't need to delete it and create a new one;  you can just use cut and paste.
A 'panel' object also works in exactly the same way as a groupbox.
Hope that helps,
Derek.

Hello Dmitry,
There seems to be a lot of new tablegrid object properties within "Options" that don't seem to do anything or maybe I am misunderstanding what they should be used for.
But there are 2 tablegrid properties that I am particularly interested in.  These are:
1.  Options/goInput
2.  Options/goInPlaceEditEvents
If I understand their meanings, both of these object properties should move MVD significantly towards in-grid editing.  Any news on when they might be available?
Thanks,
Derek.

Hello Montenegr0, Dmitry,
Attached is a little project that shows how to search with a filter using DateTime Picker (Kind=MonthYear) but it is the much the same with any field type.  The script is not necessary for the search - I just use it so the User does not have to press the mouse so much!  (that is why the search buttons are invisible).
I hope this helps.
Derek.

Hi David,
As I understand it (which could be wrong), the problem with OnAfterClick is as control passes from your previous form to the Contact form.
It should work if you attached your code to the contact_OnShow event for the Contact form instead. 
However, I'm not sure if that would be okay with how you want your form to work (although you could make it conditional on the action (ie if a new record, don't show the message, otherwise show the message etc).
Derek.

Hi Montenegr0,
Have a look at the attached screenshot.
After you 'tick' the checkbox, you then need to click into each segment of the time (hours, minutes, seconds) and either type the values you want or use the 'up' and 'down' arrows on the right hand side of the datetimepicker field.  If you don't do this, it will always default to the current time.
Derek.

Hi Montenegr0,

If I understand your question, if you are only interested in 'time' and not 'date', all you need to do is change the KIND property of the datetimepicker field to 'time' (the default is 'date') (see screenshot).

If you want to use both DATE and TIME, I find it easiest to use 2 fields, one to store the date (with KIND property defaulting to 'date') and one to store the time (with KIND property set to 'time).

If you want the date and time showing in the same field, I still use 2 fields and link them using the CALENDAR property of the datetimepicker field.  It would be much easier if you could do this all in the same field but if it is possible, I don't know of a way to do it.

Derek.

David,
Just noticed that in my example, the code for the two calculated fields is incorrect (bad copy and paste!!).
The code for the 'from' description should be (select location from locations where id = jobs.id_locations) - the 1st link between jobs and locations.
The code for  the 'to' description should be (select location from locations where id = jobs.id_locations1) - the 2nd link between jobs & locations.
Previously, they both pointed to jobs.id_locations1.
Sorry about that.
The ability to set multiple relationships between the same 2 tables is pretty useful.  In your example, you could dispatch from Point 1, going via Point 2 and Point 3 arriving at Point 4 simply by creating 4 relationships, 4 calculated fields and then use the same combo-box lookup.
A different use is that you can create multiple relationships between the same two tables but store completely different entities in the one table and then restrict what the combo-box displays with a filter (think about it as creating lots of 'sub-tables' all within one 'holding' table);  the advantage is that you don't need to create additional tables, additional forms etc etc - it's a huge time-saver.
Derek.

Hello Identity,
If you don't want to change your forms, you can delete sqlite.db and let MVD recreate it when the project next runs.  This cleared the error when I tried it.
A bigger problem is that in Form 4, you are adding "formtwo" records without relating them to a parent "formone" record - but in your database schema you have specified such a relationship.  Maybe this is just in the example project you uploaded and in your real project the records are related correctly?

Hi Timlitw,
I've done something similar before - I've attached a copy of it for you to have a look at.
There's none of your original code but it's just a case of copy and pasting it in.
I've just added a calculated field to get the maximum next due date so that can display in tablegrid 1 and I guess the colour coding would run off that.
Hope this helps.
Derek.