Search results for query: *

that was easy! Thanks Schnigger

Hi there, I am trying to export an MS ACCESS table into an EXCEL *.xls file using VBA code. I've no problem with creating a *.dbf file, using the code: DoCmd.TransferDatabase acExport, "dbase IV", _ "E:\Database\db_main", acTable, "export_prj_exc", _...

HI Larry, thanks, to create the respective SQL statement should not be a problem. The question is if there is the possibility to avoid writing this SQL code but entering this criteria directly into the line "criteria" of my query (in Design format). Meaning if it is possible to base...

The date fields are full dates, format: dd/mm/yyyy. My database is on projects including one date field for the start and one for the end of each project. I want to allow the user to apply search functions like: "StartDate before 1999 AND EndDate before 2002" or: "StartDate...

Hi Larry, thx for your reply. I would like to use it in a query since I have quite a number of search options in my form and creating a proper SQL statement is getting complicated and confusing. The solutions you suggest work fine for other fields but in the special case of the date fields the...

Hi all, I'm also getting crazy: I'm trying to base a query for a date field on a string that has been entered by the user using a form, e.g. "> #1/1/2000#". How can I directly use this string as criteria for the respective query? 'DateValue(Date_String)' doesn't work cos I have to...