Search options (Page 21 of 42)

Hi Derek,

Thank you very much for your kind help....

Unfortunately issue remains and there seems to be few others .
- Sometimes, All Refunds button doesn't work.
- Sometimes adding new refund doesn't show, on second try it does. This happens usually after start of the application.
- Sometimes adding second refund to another inv record moves "Ref" column cr / db to last refund issued inv record on inv tGrids.
I couldn't replicate all those above issues properly in order to identify the causes.

In essence there is only one tax rate that's under product field in invoice table and on invoice and refund forms.
I have tried copying tax rate combobox value under products field for all other refund form tax rates by adding link to tax rates from refund table and including cbPIRtaxRate and cbSIRtaxRate in frmRefund Save button but couldn't get it working.

Please see the updated sample project below:

Hi EHW,

Thank you very much...................................
Truly appreciated.............................................

If you and Derek weren't around, probably I'd have been forced to give up on MVD and most likely start with Java from zero.

First combo item (Print) is not associated to any button action. I wanted to display first combo item Print on combobox as a caption on Form1 show always. If I was to use buttons only then I'd have to use 2 buttons, one for print all and other for print selected. With combobox approach I'd use one button space.

However, currently I'm using disabled textbox with default value (Print) over combobox as a workaround.

Hi Guys,

Nice question Derek...

Nice solution Dmitry...

Nice alternative solution EHW...

Thank you very much to all......................................

Thank you very much EHW....................................
Your kind help is always appreciated.........................

There is one issue I could notice.
When added new record without date (DOB) it would return error saying something like '' not valid date on tGrid record browsing.

I have commented outI your date SQL line:

//Form1.DateTimePicker2.DateTime := StrToDate(Form1.GridEmployees.Cells[2,Form1.GridEmployees.SelectedRow]);

then added the following SQL to mouse click, key up and highlight grid row in each tabsheet sections to get rid of the error:

procedure Form1_GridEmployees_OnClick (Sender: string); //*** do when using mouse on employee grid
var s: string;
begin
  derekwhichsheetisactive;

  s := SQLExecute('SELECT dateofbirth FROM Employees WHERE id='+Form1.GridEmployees.sqlValue);
    if s <> '' then Form1.DateTimePicker2.Date := SQLDateTimeToDateTime (s)
    else Form1.DateTimePicker2.Checked := False;
end;

Somehow my approach looks messy. I tried to play around with your date SQL line but couldn't get it working.

Any solution?

Thanks a lot for your kind help.....
I was trying to avaoid writing code for each field in the groupbox hence in actual project groupbox contains many fields. That's the main reason for looking a solution as stated on post #1, if there is one.

Hi Derek,

Thank you very much............
Truly appreciated...................

As far as I can see, there is one issue remains:
When there is no record on tGrid/s I get info - error dialog "No record selected for editing." on app start and when last record on tGrid deleted.
I couldn't find a way to kill it.

Hi EHW,

Thank you very much.....................
Truly appreciated..............................