Okay then I write in my own words and use the google option is not for translation. The problem is that the create mail works perfectly if I make a new search ID, then the new Email created perfect data but not the document that is still the same. I do it one more time refresh then everything...
where i put the DoCmd.OpenReport "RpTPlanning", acViewPreview, , Me.Filter, acHidden
DoCmd.SendObject acSendReport, "RptPlanning", acFormatPDF, Email, , , "Planning", True
in the loop ???
Can you help me with rewrite the code?
I have a little problem and have these as I have sent a mail with this code, and a new mail sent word after I've filtered by productid he still the old mail sent how do I fix it
Private Sub Mail_Click()
Dim Email As String, FileName As String, Filepath As String
Dim strSQL As String
Dim rs As...
yes i know but the couting is not working, so you can see in th month Februari 28 day`s but hy count 28 and then 25 26 27 28 29 30 31
and the newe date for martch the 1 is if i loke 1-1-2014 and not 1-3
Oke thanks it`s like to work
but is it possible , if the date from the next month come in display, that he se this als new date next month.
So yes what must I do
As you can see, these are the date s that not working good 28 and 29.
He gives as 1-1-1 March 2013 and not 1-2-13 Sunday 2 February is completely gone.
oke dat is i small problem but what?
this is the code for calendar.
but i don`t get al the days als datai don`t get 7day`s but 6 days
1 2 3 4 5 6 7
1 9 10 11 12 13 14
1 16 17 18 19 3nz
Function fVulinMaand()
Dim iJaar As Integer
Dim iMaand As Integer
Dim iJaarVandaag...
first off al i do this in the query
i have the field Workingday`s and time now i need the formule that day`s * time so i have total hours
days are 12 time 8:00 so it is 96 hours
the formele [days]*[time] don`t work give in the query ( fout)
i like to tell you that writing Engels is small problem but, if i make time for it its going well.
The question is can you help?
The problem I have whit it is, can make al the stuff I need for the day`s no problem but when I change the moth he don’t switch the day`s .
I hoop you know what I mean...
oke mooi dutch haha sorry voor de engels .
maar als ik dat doe is mooi maar krijg dus niet de goede datum er in bv 7 blijft 1 en als ik de maand verander loopt de nieuw gemaakte niet mee .
en dat is eigenlijk mijn probleem
zou je hiermee kunnen helpen?