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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error saying 'The ) is missing' in select expert

Status
Not open for further replies.

Sinead

Programmer
Aug 3, 2001
14
IE
I am trying to search for a particular date from a report. When searching I have the following code
Set SelectField = VSelExpert1.GetField(1)
With SelectField
.FieldType = crDateTimeField
.FieldName = "ParkingHist.StartTime"
.AddValue "ParkingHist.StartTime"
End With

Set SelectRange = VSelExpert1.GetRange(1)
With SelectRange
Set SelectField = .SetRangeFieldByName("ParkingHist.StartTime")
.Operation = crSelectEqual ' crSelectEqual
.AddValue "14/08/2001 12:00:00"
End With


An error results saying that 'the ) is missing'
The search works for strings and integers. Does anybody know what's wrong?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top