Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pingpang

    Showing a product in a formatted textbox(contents)

    Hi there! I've tried the code already. It works... thanks! I just want to ask you if you don't mind what's the difference when you use val or cint/clng/cdbl? thanks again!
  2. pingpang

    Showing a product in a formatted textbox(contents)

    hello! I've tried your code already. It works but when you press the tab key until it reaches back to the txtqty(textbox) the amount will change. Did you get me? I don't know why, I hope you could check it. Thanks!
  3. pingpang

    Showing a product in a formatted textbox(contents)

    ok thanks for all your help! :)
  4. pingpang

    Showing a product in a formatted textbox(contents)

    Thanks a lot! I also notice (what ADoozer noticed) last night that 1,000 will be treated as 1. Again, Thanks to you guys! I'll try the code tonight. :) By the way, why do you use the validate event? why not the change event? And why do we need to assign 1 to qty in the form_load event? :)
  5. pingpang

    Showing a product in a formatted textbox(contents)

    thanks! But my form is not bound. In my form I have ok and cancel button. In the ok button codes for saving what the user inputs in every textbox. And I believe that you can't use the dataformat property when your control is not bound. Hope for your response soon.... Thanks again!
  6. pingpang

    Showing a product in a formatted textbox(contents)

    Good day to you! I have this problem with calculation. I have Quantity(txtQty) and Unit Price(txtUprice) field and output the product in the Amount(txtAmount) field. If works just fine if I remove the code to format the contents of the textbox. But my code below doesn't work, it gives a wrong...
  7. pingpang

    displaying commas and period in a textbox(currency) while typing

    thanks for the response....YOur (DrJavaJoe) code is just what I need..:) Maybe I have other follow up questions similar to what i ask, I just post it in this thread. Hope you guys can check it. thanks!
  8. pingpang

    displaying commas and period in a textbox(currency) while typing

    Good day to you! I can't figure how to format a 1000 into 1,000.00/1,000 in a textbox. If you do, please help me. thanks!
  9. pingpang

    text from a form to display it on the report

    I've tried it already.... it works~ thanks a lot!
  10. pingpang

    text from a form to display it on the report

    Hi! good day to you! I would like to get a text1.text from a form to display it on the report when I click the show report button. Do you know how to do it? by the way, i'm using data report. Hope for a response. thanks!
  11. pingpang

    Disallow pressing spacebar in a textbox

    Good day to you! I have a question, how can you disallow the user form pressing spacebar in a textbox? and another thing how can you limit a textbox input only for letters? hoping for a reply soon. thanks!
  12. pingpang

    data report using landscape orientation

    Thanks! I haven't downloaded sp5 yet. I would just like to ask if this would work if your os is windows xp? And I'm just confused in microsoft website. I don't know for sure if this is the sp5 your referring to. How would I locate the download. One more thing where will I get mdac2.5? And...
  13. pingpang

    data report using landscape orientation

    Hi there! I'using vb 6 and I get this error in my data report. The "report width is larger than the page width". and I solved this problem by making the report width smaller. But by doing so, I can't make my report in a landscape orientation. I would like to know how to do it. And...
  14. pingpang

    format the text in the texbox

    How would you format the text(numeric) in a textbox? Private Sub txtUprice_Change() txtUprice.Text = Format(txtUprice.Text, "Php ###,###") End sub what i want is when the user starts typing the comma and would appear while the user inputs the amount. thanks!
  15. pingpang

    sum the column from a datagrid

    Hi! How can you sum a column from a datagrid and show the result in a textbox? Thanks in advance....
  16. pingpang

    One form accessing three tables

    Oh, I forgot to say thanks! Thank YOU.
  17. pingpang

    One form accessing three tables

    Oh, I forgot to say thanks!
  18. pingpang

    One form accessing three tables

    I almost solve the problem already... I have another question to ask. How can you get the sum of a column from a datagrid? I have an idea though, it goes something like this Dim i As Integer For i = 1 To Adodc2.Recordset.RecordCount txtjo_total.Text = Val(txtjo_total.Text) +...
  19. pingpang

    One form accessing three tables

    yeah, that works... thanks! My idea is that I would set the datagid visible=false when you are going to add a record in the jod order form. and when I click save the datagrd visible-true. My problem is when I click the save button, there is an error. I know what the error is, but I can't find...
  20. pingpang

    One form accessing three tables

    Hi again! thanks again for replying. I've tried that already. But an error occured. (Run time error '-2147467259 (80004005)': You cannot add or change a record because a related record is required in table Job Order (main). I think you can't save a jo_no from the job order grid form since it...

Part and Inventory Search

Back
Top