Search results for query: *

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 & "'"...

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#"...

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...

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?

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.

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...

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...

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

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...

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...

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...

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...

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

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...

Thank you very much both of you. But that's all weren't really helpful for me. Maybe, i havent explained my problem very good, i don't speek well english but i will try one more time. First of all, i don't want to use Rs.Fields(i).Name because i don't want the name of the fields of tables. I...

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...

hello everybody, i have a private sub in my program displays data of a table in an mshflexgrid calling it flxResults. Well, in many forms the flxResults displays data of different tables for example in frmOrdDtlsAllRcs in the flxResults i display the OrderDetails table's records, in...

Thank you :)

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

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