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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query to select records that dont repeat.
Hallo, I would like to achive an outcome that returns only values that do not repeat in a column. I have a database with a list of values in a column that are a conbination of driver name and destination. SmithSydney JonesSydney SmithSydney JonesMelbourne SmithSydney JonesMelbourne... -
Non US format DATE
Hi, I think I figured it out. Using just plain old CDate I converted the string into a date format Dim TheDate as Date Dim CurrentDay as String = "1/12/2007" TheDate = (CDate(CurrentDay)) MessageBox.Show(TheDate) The problem was I was looking in the code for the values, which by the way...- MichMat
- Post #6
- Forum: Visual Basic (Classic)
-
Non US format DATE
Hi Bob, I have checked the regional settings and they are all ok as I suspected that they would have been. The error must be elswhere, in my code. Its very frustrating I have lost many hours trying to figgure out this problem. Having non US settings have always presented this problem. I have...- MichMat
- Post #5
- Forum: Visual Basic (Classic)
-
Non US format DATE
I should have added that CurrentDAy is THE string with a date as "1/12/2007". Is there no edit for a post? I couldnt find it Michal- MichMat
- Post #2
- Forum: Visual Basic (Classic)
-
Non US format DATE
Hi All, Im having real problems with the date formats in VB 2005. Imports System.Globalization Dim auCulture As CultureInfo = New CultureInfo("en-AU") Dim TheDate As DateTime TheDate = DateTime.ParseExact(CurrentDay, "dd/mm/yyyy", auCulture.DateTimeFormat) Im trying to convert a string in...- MichMat
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
-
DBF Query Join?
Thanks R937 While your code did not work, due to syntax error It at least showed me that I was heading in the right direction. Most times that is as good as any specific advice. Through trial and error I came to a working solution, I WAS SO CLOSE BEFORE "Select * FROM DHistory,DToday where... -
DBF Query Join?
Thanks, dbase is the data bases, I wouldnt think that that it would matter in the sql statment. The join statment ? In the examples in the tutorial there was no mention of such thing. Michal -
DBF Query Join?
Hi All, First post and absolute begginer. I have 2 dbf tables. One has todays drivers and the other has drivers history(ie each past driving job) I want to create a dataset? which has the driving history for each driver engaged today so that I can do some stuff with it. The drivers(today)...
