Search results

no

yes it wooooork great ..but if i want to get value of yasterday for example??

yes i have records of august mounth with all days

i have many records i would make easy to use data i creat a query to get just records of today but is not work as shown in the problem

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

thank you there is no way to get values.. [Closed]!

it not work for me since yesterday im tired

ok let me see how we can do that : my db is below login : admin pass : 1234 thank you

but i need the time portion permenantly this is a time stop sheeft and i need it to calculate later working hours

the problem is not that you tell me if i make Année(Date()) or Mois(Date()) as createria in my other queries my report load date values normaly..the problem is just in date() mean today and date()-1 mean yesteday.

i dont understande where exactely?

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

problem solved thank you @theDBguy this is a great solution :)

there is a differnce betwen the two db

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

ok : how i can get emails for selected persons to use it in macro to send email to this persons as auto generated email make a button to run macro help me plz

yes i try to solve this problem query1 not work

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

this concept don't help me to get email values when i select names from combobox. the concept i want is to load emails when i select names

what a geniuos ;)