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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by schnigger

  1. schnigger

    export ACCESS table into EXCEL file

    that was easy! Thanks Schnigger
  2. schnigger

    export ACCESS table into EXCEL file

    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", _...
  3. schnigger

    string as date parameter for query

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

    string as date parameter for query

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

    string as date parameter for query

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

    string as date parameter for query

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

Part and Inventory Search

Back
Top