Search results

Excellent! Thanks so much for your help. I will give it a try this afternoon! I really appreciate your expertise. :) Many Thanks again Daz

I pressed Enter after it and it came back with "4" I take it that 4 is the number of days - and the 2 is a Monday (stab in the dark as 2 being the 2nd day of the week?) So if I was correct - there are 4 Mondays between those dates?

Thanks for replying. Ok - I have renamed the module in Access. I have opened the module and got the VB window up. I have clicked on on View - Immediate Window and a blank box has appeared below the code window. Not sure what to do with it. Sorry for being a bit of a noob with coding...

I just figured out where the immediate window is - sorry I have never used this before and not really sure what it does.

Well what I did was copy the top bit of the code from the link you sent me, and created a new module and saved it as HowManyWD. I then opened a query window and dragged the DateFrom & DateTo fields - im not really sure what to do next. I assumed I call the HowManyWD function within the query...

Hi I am struggling to implement this - I has basic programming skills. So far I have copied the top part of it into a module: /code Public Function HowManyWD(FromDate As Date, _ ToDate As Date, _ WD As Long) ' No error handling...

Thanks Rural Guy - thats exactly what I am looking for. It's the top option I need. I will give it a try and post back if it works. Thanks again for your help. Daz

Hi Can someone help me with this please? On a form I have a combo box which has 5 options - Mon - Fri I have a date started field on the form too. What I would like is to query how many of the given days fall between a date range. For example a user selects Monday (it has to be weekday...

Thanks Bob - some really useful info on here. Thanks to you guys. I am now 1 hour away officially from beer time!! :)

Thanks dk - i do get easily confused - espy late on a Friday afternoon!! Hehe

Thanks dk They both work! Thanks alot for your help. I really appreciate it! :)

MSAccessRookie - I love you! That works a treat. I was ripping my hair out trying to get that right. Many thanks for your help!! :) Daz

Hi Can someone help me with this please - it's pretty simple I think! I have a form called frmPupils, on the form is a tab control called TblCtl15, on the tab control there is a sub form called subPersonalDailySchedule. I have a field on there called TripPrice. What I would like to do is...

I managed to sort it, I asked her is she will ever need to send to more than 2 people - she said no. So what I did was add an addtional combo box to choose another member of staff. Then I added the following line in the code: outlookmessage.cc - and then the field name which includes the...

Hi Thanks for posting the link - i will look to implement something soon. Not sure how you can accomplish what you are after - my knowledge of VBA expertise is very limited - sorry! Thanks for all your help. Daz

Thanks for your reply Mutdogus! I will give it a try - the way mine works at the mo - it picks the name of the receipient from a field on my form. It's pretty cool actually as it resolves the name from the global address list on outlook without me telling it to! However the plot has...

Hi Mutdogus Many thanks for your reply - thanks for the link - I will play around with it today. Please let me know if you can find a way to bypass the outlook warning. Thanks again.

Here is the code I have used to send the report: /code Dim stDocName As String If Me.Dirty Then Me.Dirty = False stDocName = "rptContactMessage" DoCmd.OpenReport stDocName, acPreview, , "[CPID]=" & Me!CPID Call ConvertReportToPDF(stDocName, , "C:\Documents and Settings\All...

Hi Can someone help me with this please? I have a report which I am emailing from a command button. Currently the button opens the report - converts to pdf and then emails (with the outlook warning). The problem is sometimes the outlook warning doesnt not appear in front of other...

Thanks so much for that - it works great. I would like to tweak one more aspect if possible. Rather than hard coding an email address - would it be possible to bring up the new message window from outlook so a user can select the recipient? Many Thanks Daz