Search results

the shiftvlisttbl is the matrix the purpose of dutyrecordstbl is to be used as source in crosstab query and monthly report so then, given a year and a month from parameters on that form to produce a report with people vs dates in that period like this (where ypallilosID) is a person belonging in...

Hello, i would love some help please In work there are 5 groups of people working in shifts like in my table “shiftvlisttbl” I would like to achieve this rotation with a query so given a year and month from form parameters and then another query, produce in my table “dutyrecordstbl”...

By mistake i d pressed solved

Hello, I need help to represent finished or future shifts, for each group of employees daily in each month (1 to 30 or 31 depending on month) in a crosstab query and then report Employee groups are A, B, C, D, E Each Group has to be represented with a regular shift each day of month...

Solved with arnlel's code and Gasman's help about null values that should be blocking whole thing (producing correct values so outlook would work) so i returned with an sql query besed on my table where condition of isnull = false refrase that to vba and boom Private Sub...

Gasman i would love this to work without wrong code and i wouldnt want null replication to be there, but i wasnt able to send emails via outlook "uknown message recipient(s); message was not sent" with stEmail = stEmail & ! & ";" what would be wrong? tryied that with just stEmail = stEmail...

Problem solved after tests from arnelgp's code and in line stEmail = stEmail & ! & ";" to stEmail = stEmail + ";" arnelgp thank you!!

Still cant get it work.. did some tests and in line stEmail = stEmail & ![email] & ";" if subtructed the & ";" recipients list is generated but canot be sent, else put above code ,returns "uknown message recipient(s); message was not sent"

i saw that excuse me still changed with those intraction sending was not achieved with message: "uknown message recipient(s); message was not sent" Private Sub cmdDiataxiE_mail_Click() On Error GoTo Err_cmdDiataxiE_mail_Click Dim stReport As String Dim stWhere As String Dim stEmail...

email was not send arnelgp, is it because my email field name is "email" ?

arnelgp hi, even with your answer helping me a lot, i still need help (how to achieve that) Private Sub cmdDiataxiE_mail_Click() On Error GoTo Err_cmdDiataxiE_mail_Click Dim stReport As String Dim stWhere As String Dim stEmail As String Dim stSubject As String Dim...

Hello, having trouble specifiying email recipients in vba command syntax: I have a form with command to send email (click open report from my form and send attached report via outlook), it is working fine to recipiets whose emails are speciafied in vba For practical use, i need to send...

Yes that worked!! Thanks you!!

Arnelgp i have erased on purpose fields and some irrelevant tables from uploaded database. So there is no problem in form openfrm if you meant that one. What i would like to solve is: on adeiesfrm form, when opens and shows new record to have those calculated textboxes not show #Error

Hi all, Is there a way to eliminate #Error in calculated texboxes in forms? I have problem in adeiesfrm in my uploaded database..

Yes it is correct!! Thank you!!

Yes it is quite close, only it is missing records if opened side by side Qradeiescurrentlastyear and main form with filter applied for the same person that query has : WHERE (((DateDiff("yyyy",[Enarxi],Date())<=1)=True)) Your solution is fantastic but i would prefer solving that problem as i...

It is a button "Show Current and Previous Year" if i undrestood the question

Hi, i would like help to change a subform's recordsource by clicking a command button in my main form. Read some articles but still cannot achive it Main form name is adeiesfrm and subform's name is adeiesfrmsub1 adeiesfrmsub1 default recordsource is adeiestbl and i need changing that...

Worked like this =IIf([Epitheto] & ""="";" ";"Υπάλληλος" & " " & [Epitheto] & " " & [Onoma]) I am not completely aware why ypallilosID didnt do the job