• Registered: 2016-07-28
  • Posts: 1,038

Topic: Details without SQL

I wanted to apply Derek's method of getting details without SQL.
It works fine with People tab on Form2 but I couldn't get it working with Suppliers tab on  form2?


Please see the attached sample project below:

Post's attachments

Attachment icon Details without SQL.zip 11.54 kb, 346 downloads since 2017-10-23 

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Details without SQL

You forgot change TableGrid in the settings of button "btnSuppFakeEdit", change it to TableGrid3

Dmitry.

3 Reply by AD1408 (edited by AD1408 2017-10-23 12:14:49)

  • Registered: 2016-07-28
  • Posts: 1,038

Re: Details without SQL

DriveSoft wrote:

You forgot change TableGrid in the settings of button "btnSuppFakeEdit", change it to TableGrid3


Thanks a lot Dmitry.....
Done. Now, browsing suppliers records works.


It seems, I'm missing something else.
After clicking on "Manage Suppliers" button on Form1, I get an error message:
"Cannot focus a disabled or invisible window."

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2015-11-13
  • Posts: 652

Re: Details without SQL

Adam,
Attached is the fixed project. I put in code to do the appropriate show procedure depending on the page index that is active from the Form1 buttons. I also put in your scroll code when changing between people/suppliers tabs on Form2.

Post's attachments

Attachment icon Details without SQL Fixed.zip 590.06 kb, 461 downloads since 2017-10-24 

  • Registered: 2016-07-28
  • Posts: 1,038

Re: Details without SQL

Hi EHW,


Thank you VERY MUCH..................................
TRULY appreciated.........................................
Your kindness goes long way for me as always.......

Adam
God... please help me become the person my dog thinks I am.