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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: angelpr23
  • Order by date
  1. angelpr23

    help ado sql query syntax probleme with dates in cretiria

    Thank you Swi i tried my query sql = _ "select Orders.ReceiptDate, Orders.OrderID," & _ "OrderDetails.OrderID, OrderDetails.ProdSumPrice " & _ "where Orders.OrderID=OrderDetails.OrderID and " & _ "Orders.ReceiptDate between '" & 1/1/2007 & "' " & _ "and '" & 31/12/2007 & "'"...
  2. angelpr23

    help ado sql query syntax probleme with dates in cretiria

    hello everybody, i have a sql query sql = _ "select Orders.ReceiptDate, Orders.OrderID," & _ "OrderDetails.OrderID, OrderDetails.ProdSumPrice " & _ "where Orders.OrderID=OrderDetails.OrderID and " & _ "Orders.ReceiptDate between #1/1/2007# " & _ "and #31/12/2007#"...
  3. angelpr23

    text boxes validation

    Thank you Swi, does it have the same functionallity with textbox? Do you have a tutorial link about maskedit, or a link in the website or whatever? I didn't found really helpful msdn help maskedit control in vb6. Any help for PriceTxt i mentioned before? Does anybody knows? I haven't found yet a...
  4. angelpr23

    text boxes validation

    SkipVought i have saw some posts i havent responded because i had problem with my internet connection and i had then i had forgotten this. I found 2 or 3 posts i dont remember something else? Could you tell me the post you re mentioned to have a look at it?
  5. angelpr23

    help with condition in a public sub i want to create

    Thank all of you so much, i finally followed MakeItSo instructions and it now works fine. I think that was the best solution for me than the others.
  6. angelpr23

    text boxes validation

    Thank you much error, really i don't need cnt variable. I have a question to do. For Pricetxt i refered before i tryied: Private Sub Pricetxt_KeyPress(keyascii As Integer) dim dotCnt as integer 'dotCnt represents the number of how many times the user 'has the possibility to type '.' which...
  7. angelpr23

    text boxes validation

    Thank all of you so much, for postcode for example i tried this: Private Sub postcode_KeyPress(keyascii As Integer) Dim cnt As Integer cnt = 0 Select Case keyascii Case 48 To 57, 8 ' 0 to 9, plus 8 - Backspace Case Else keyascii = 0 Exit Sub End Select If...
  8. angelpr23

    text boxes validation

    Thank you very much, that was great for all my requirements.
  9. angelpr23

    text boxes validation

    hello everybody. I want to create a kind of validation in some textboxes i use in form. For TxtPhone i want the user allowed to type only 10 numeric characters for example 2105839489 or 6939583952 no alphabetical characters and no panctuation marks for TxtPostCode i want the user allowed to...
  10. angelpr23

    help with query please

    hello all, i am trying to create a complecated query with ado shape sql statement, i am gonna use it in a routine for the desired for me results on a data report in visual basic 6 in my application. Well i want this query: SELECT Categories.CategoryName, Products.ProdName...
  11. angelpr23

    help with default property

    Thank you very much BobRodes. I finally found my mistake somewhere else. I was saving the changes of the record with rs.update statement, i had an information message for the user that the changes saved and under rs.update and it was really strange, that when i was hitting enter the message was...
  12. angelpr23

    help with default property

    Hello all. I have created a from with 3 textboxes and 3 command buttons. I display a record in text boxes and the user modify its values, so my command buttons is saveCmd, CancelCmd and HelpCmd. I set saveCmd default property to true. Well, if the user modify a value of a field in the record, if...
  13. angelpr23

    help with condition in a public sub i want to create

    Also, i dont know how to use alias in my program..
  14. angelpr23

    help with condition in a public sub i want to create

    Thank you very much all of you, i liked the solution of Makeitso i think is the best way to do this. I will try it and i will tell you my impressions. About where statement i am thinking to check the tbl name with if statement and hold it in a string variable too, named WhereClause so i think...
  15. angelpr23

    help with condition in a public sub i want to create

    ...differnt sub rootines one for every table to do this. I want to do it in one. I have thought to break the sql query. For example if sql="Select * from customers;" I am thinking to declare a string variable tbl. So i will say something like tbl="customers" sql="Select * from " & tbl Well...
  16. angelpr23

    help with condition in a public sub i want to create

    Thank you much PeterWallace for your help, but this is not what exactly i want to do. Well, to explain it better, i have a db created in msaccess, the db includes tables and the tables include fields. As a conclusion, the fields differentiate from table to table. So, in my program i have many...
  17. angelpr23

    help with condition in a public sub i want to create

    ...data in the flxResults grid concretely the orderDetails records for the order displayed. Public Sub displayData() sum = 0 sql = "select * from orderDetails " & _ "where (orderID='" & AdoOrd.Recordset!OrderID & "');" Set rsOrdDet = New ADODB.Recordset...
  18. angelpr23

    information about c3

    Thank you :)
  19. angelpr23

    information about c3

    Thank you again, A last question, Does Visual studio .net works right with Windows XP SP2?
  20. angelpr23

    information about c3

    Thank you chrissie1. Is it included in visual studio .net with other program languages or not?

Part and Inventory Search

Back
Top