Search options (Page 58 of 101)

Scribtx,
Perhaps I was not clear in my previous post.
My screen shot was not suggesting something you should try - quite the opposite.
The screen shot was simply highlighting that you yourself had specified the 'distinct option' in the tablegrid column footer with a 'time' format that was incorrect (the column footer 'text' attribute is not the place to do that).
With reference to your original post, I have still not been able to reproduce any errors you describe with your project. 
Perhaps other users can try and see if they encounter the problem.
Derek.

Hi,
Can you attach your project - hard to tell just from the screen shots what might be behind the error but it'd be unusual for simply quitting out of the 'update' form to cause any problem.
Derek.

Hi Agusecc,
Try it like this (see attached).
Derek.

Hi CDB,
Can you do it something like this? (I don't bother to put the date into the tablegrid initially because it gets put there after the sqlupdate anyway).
Derek.

Hi JoshuA,
Welcome on board!
As always with MVD, there are different ways to do it.
I'd suggest using a calculated field configured to use the same display format as you've defined for your phone number on your data input form, which then gives you
1.  The data input form uses the display format you defined.
2.  The tablegrid uses the calculated field.
3.  The report uses the calculated field.
4.  The database stores the phone number unformatted.
Calculated fields are set up as part of your database table definitions but don't actually get 'stored' - they exist only while your program is running.
Please have a look at the example and give a shout if anything isn't clear.
Derek.

Hi,
Perhaps you could try doing it like this (please see attached).
Regards,
Derek.

Hi,
I've not been able to see anything obvious and the error message isn't all that helpful. 
I think this is a question for Dmitry.
The only other course of action might be to use an earlier version of forms.xml, but depending on the number of changes you've made recently, I don't know how realistic this is.
Derek.

Hi,
If you can zip your project  (without the .exe) and upload it,  then someone in the Forum should be able to take a look and get back to you.
However, as an option, I'd suggest you change the processing logic slightly - instead of adding a new employee DIRECTLY from the workcard form, go via a form that shows all employees with the option to add / change / delete employees from there.  This removes the original issue (empty row) but also has 2 additional benefits;
1) you can now use the same form to not only add but also change and delete employees (not sure how you'd otherwise planned to do that)
2) it's now not possible to create a work card with a blank employee, so it is more rigorous without having to write any additional code.
Please see the attachment.
Regards,
Derek.

Hi,
Your syntax is correct.
Have you created an 'onchange' event for form1.edit1? (please see the screenshot in the attachment).
Regards,
Derek.

Hi Jean,
No - I had a choice between replying to Hedan's question or going Christmas shopping with the grandchildren - it was no contest!! 
Merry Xmas to you too.
Derek.

Hello Hedan,
I think you can change the combobox to pretty much anything you want with a combination of
form1.combobox1.color := xxxxx
and
form1.combobox1.font.color := xxxxx
For the datetimepicker, I think it's only possible to change the background color (and that needs to be done at 'form1.show' rather than being able to set it as part of the datetimepicker object properties.
Please see the attached where I was just messing with different combinations - it might give you some ideas.
I also seem to remember that not all background / foreground color options are available depending on the Operating System that you're using (but I might be wrong!).
Regards,
Derek.

Hi Scribtx, Hi JB,
If I don't want to use the pre-set colors (clred, clblue, clgreen etc), I click on the bgcolor object property (the very small box circled in the attached screenshot - it's quite easy to miss - LOL!), click on 'define custom colors' and then just choose a color from the palette.
The color value is then copied back into the object's property (in my example $00B6AA85).  You can then simply copy this value and use it elsewhere if required.
All of this holds true not just for form backgrounds but for labels, tablegrid backgrounds, panels etc etc.
Regards,
Derek.