Search results

  1. K

    AutoExec Macro and openForm method word Under access 2000 and not under Access 2007..

    Hello evrybody I have created an application with forms, Macros , as well vba codes (modules) and SQL request ) under access 2000...i'm a beeginner in Access and VBA too. I used an AutoExec Macro wich open a form called 'Menu' at the opening of database . This is the code that allow me open...
  2. K

    Covert english date format to fransh date .Use of Order BY in access 2000

    Hello THANK YOU for response... I have tried the two requery you give me but i have error syntaxe in the first and conflict between distinct and lng ( in the second ... I tried this query ... IT WORKS ... GREATLY SELECT Format([Date Commande],"mm/yyyy") AS Expr1 FROM Relevé GROUP BY...
  3. K

    Covert english date format to fransh date .Use of Order BY in access 2000

    HELLO I'm working in Access database .. i'm using this SQL query to extract dates in English format below : SELECT DISTINCT Format([Date Commande],"yyyy/mm") AS Expr1 FROM Relevé GROUP BY Format([Date Commande],"yyyy/mm"); Result: Expr1 2006/10 2006/11 2008/10 2008/11 2008/12 2009/01 AS YOU...
Back
Top Bottom