Search results for query: *

I have a feeling there must be an easier way to use rave with multiple fields from several records but ended up using parameters myself, a tedious process but it seemed to work

CDate() is a Type Conversion Function in Visual Basic I came across when programming an Access database, buggy and never worked right (or more likely didnt understand it properly) and had to create a work around, one of the reasons I changed to Delphi

All i can think of is that there may be something wrong with the the DATE CREATED field that your checking, if you get no error messages it would suggest that the match is okay but in some way it isnt being represented the way you expect.

I dont know if this helps and I am definitely not an expert user but I used this to select cases from a database s:='WHERE (([Tbl Demographics].Forename)="'+Forename.text+'" '; s:=s+' OR ([Tbl Demographics].Surname)="'+surname.text+'"'; s:=s+' OR ([Tbl...

Hi I had a problem with SQL dates and found that the date was in american format mm/dd/yyyy so i cheated and formated my search string to fit that after it was entered by the user.. not a very elegant fix but it worked.

I am trying to export a access table to a dbase format table for use with other applications, I can do it manually with the export function in access (transferdatabase doesnt seem to work in access basic).. I would like to automate it in VB but cannot find a way to do it.. any help available?