Search results

  1. R

    group values in a query

    hello need a quick help to grouping (service maintenancier) in this query by geting (somme of NB service) once time this is the maximun value of dcount for (service maintenancier).. the meaning is to groupnig each (service maintenancier) with there (somme of nb TR) exemple : Atelier Bulls et...
  2. R

    number of record from query and two combo boxes

    i have a form named (TR Jours par Service) with two combobox (sc_cbo) for select services and (day_cbo) for select days of month and a query (Q_JM_select_TM) loaded from a table (t_rec). i try to get number of records of one service in day (day_cbo) where i select sc_cbo and day_cbo i try for...
  3. R

    impossible to get year in format date

    hello: i use this formula in an access query to get year/mounth and [deb] is my date field in the table expr1: Format([deb];"""yyyy""/mm") but when i execute the query i get the result shown in the picture below i use frensh windows and the language of my computer is frensh / format of deb field...
  4. R

    impossible to get date time values in a query

    problem: -I have two fields named [deb] ; [fin] as a short text in table t_rec -Form to enter the informations in the table t_rec used as data source and [deb] ; [fin] is a date time field -I creat a query to get values as date/time for today and i use as creatiria exp1 : datevalue([deb]) and...
  5. R

    report from query not load values

    i have a query and i put date() as creteria in deb coloumn to get filtred values of date/time of today but in my report issu of this query it still empty. deb format in my form is : "dd-"mm"-yy "hh:nn please help me to resolve problem
  6. R

    how to email with vba from a form using cbo and list box selection

    hello programmers i have a mini form used to send emails to two person ( nom_hc) listed in (resp_acc) with emails ( email_hc) in the form the user should select in cbo1 person1 and in the cbo2 person 2 and he will get emails in two listboxes below and record it in t_dci table source of the form...
  7. R

    related combo_box to get emails and send it with outlook

    hello programmers i have a mini form used to send emails to two person ( nom_hc) listed in (resp_acc) with emails ( email_hc) in the form the user should select in cbo1 person1 and in the cbo2 person 2 and he will get emails in two listboxes below and record it in t_dci table source of the form...
  8. R

    get listbox values from combobox multiples selection

    in this db a want to get the emails in listbox from selectin combobox multiple choises. how can i get it into table (t_dci) automatiquely thank you for help me. db in the attachements below login : admin passe :1234
  9. R

    Insert selected item into Access table

    hello i m new in this forum proud to be here
Top Bottom