Search results

  1. J

    [Access 2k3] Macro for sending mail if data ?

    Hello I need you help please. i have made an unmatched query and in my macro, i would like the database send me an email with an excel file, ONLY if there are some data in the query. If the query is empty, no email i've found this code but i dont know where i can put this code.. in a...
  2. J

    [Access 2k3] Make multiple reports

    Hello First, sorry for my english... I'm french. I'm a begginer in Access. I want to make a query based on something like this : It's a table with our employees with : First Name, Last Name, ID, Equip's name, and lot of data from the working time for each day like Staffed Time, Time in...
  3. J

    Syntax error in a query ?

    Hello, I need your help please. When i want to execute a query, i've got : Syntax error (missing operator) in query expression '[Import temps_productifs_masques].'. Here is the sql code : SELECT [T_M Calendrier].Mois, [T_M Calendrier].[num sem], [T_M Calendrier].Date, [T_M PDE].Client, [T_M...
  4. J

    Question Retrieve data from variable directory

    Hello I need your help It is possible to retrieve files from variable directory to append data in a table ? Ex : i need my access to retrive files from \\srv64\Shared\backoffice_dts_extraction\archive\23032010 \23032010 is date of the automatix extractions from another software. Each day...
  5. J

    [Access 2k3] pb query with dateserial()

    Hello I need your help please. I've a table with [dateretract] as text because the csv file is like that.. (format : 2009-12-01) YYYY-MM-DD. I have used this code in a query to correct it : DateSerial(mid([Dateretract],1,4), mid([Dateretract],6,2), mid([TDateretract],9,2)) This work fine...
Back
Top Bottom