Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
Web Server - Ask For Help / Re: How to get value from other file and put it to Form file?
« on: November 12, 2012, 06:28:55 AM »
Hi Bruce,
Thanks for so details explaination.
I have adopted method 1, add auto ID to my Invoice Header & Details for Nettalk control, it is really the easiest way to implement.
BTW, I can't find any example on formula for a field? I need to do like :
Item Amount = (Qty * Unit) - Discount
The formula is no longer applicable, right? Where should I embed?
Thank you.
Best Regards,
Nelson
Thanks for so details explaination.
I have adopted method 1, add auto ID to my Invoice Header & Details for Nettalk control, it is really the easiest way to implement.
BTW, I can't find any example on formula for a field? I need to do like :
Item Amount = (Qty * Unit) - Discount
The formula is no longer applicable, right? Where should I embed?
Thank you.
Best Regards,
Nelson
32
Web Server - Ask For Help / Re: How to get value from other file and put it to Form file?
« on: November 08, 2012, 06:10:10 AM »
Hi Bruce,
I means few person is open same Invoice Header screen, who press the Save button, who will get the first number, then second number for second person press save.
I found the embed place to do it is CompleteForm, is this the right place?
May I know, like Rebert suggest to put a button to save the invoice header, when should I embed the Save Invoice Header command? And is the command same as Access:InvHdr.Insert?
Thank you.
Best Regards,
Nelson
I means few person is open same Invoice Header screen, who press the Save button, who will get the first number, then second number for second person press save.
I found the embed place to do it is CompleteForm, is this the right place?
May I know, like Rebert suggest to put a button to save the invoice header, when should I embed the Save Invoice Header command? And is the command same as Access:InvHdr.Insert?
Thank you.
Best Regards,
Nelson
33
Web Server - Ask For Help / Re: How to get value from other file and put it to Form file?
« on: November 07, 2012, 06:37:12 AM »
Thanks Robert & Bruce, I manage to get the value and assign to invoice number.
But, if more than one person issue invoice, where is the best embed point for me to assign invoice number instead of PreInsert or Prime?
Thank you.
But, if more than one person issue invoice, where is the best embed point for me to assign invoice number instead of PreInsert or Prime?
Thank you.
34
Web Server - Ask For Help / How to get value from other file and put it to Form file?
« on: October 23, 2012, 06:03:52 AM »
Hi,
I need to read a file to get the last running number and put it to current form invoice number, may I know how and where can I embed to read the other file value and assign to invoice number?
Another question is, from the example I know that invoice ID must be unique and auto number, in order to link to child file when inserting record. My current file structure is not cater for this and already got stable Win app running. So, can I assign the value to invoice number, then user must Save then only continue on invoice item section? How can I press Save and remain on the form and unhide invoice detail section?
Sorry, I am just new to Nettalk, and rushing program to meet deadline, so post question here.
Thank you.
I need to read a file to get the last running number and put it to current form invoice number, may I know how and where can I embed to read the other file value and assign to invoice number?
Another question is, from the example I know that invoice ID must be unique and auto number, in order to link to child file when inserting record. My current file structure is not cater for this and already got stable Win app running. So, can I assign the value to invoice number, then user must Save then only continue on invoice item section? How can I press Save and remain on the form and unhide invoice detail section?
Sorry, I am just new to Nettalk, and rushing program to meet deadline, so post question here.
Thank you.