Search results

Module Problem Namliam - no need to be arrogant - as I explained I am not an experienced programmer. Is there anyone else more helpful and less pompous that can help please. Many Thanks in advance.

Hi I have tried both variants you suggested but still get the 'variable not defined error'. Am I correct in editing this directly in the module? Thanks

Hi I tried what you advised me: ***************************************************** Function AddWkDays(varDate As Variant, numdays As Integer, _ Optional pexclude As String = "17") As Date Dim thedate As Date, n As Integer, incl As Boolean If IsNull(DateReceivedIYFAForm) Then Exit Function...

Hi Thanks for your response. The previous thread was a different function that I required help on a while ago so didnt continue that one. I will give it a try. Fingers crossed!! Many Thanks again :)

Hi The exact error I get is: Run time error 94 Invalid Use of Null. Below is the full module: ****************************************************** Function AddWkDays(varDate As Variant, numdays As Integer, _ Optional pexclude As String = "17") As Date Dim thedate As Date, n As...

Hi I require some help please. I have a access database with a module which works out a certain date 20 days from a day in a field. The module adds a function called AddWkDays which I call upon in a query. Below is the line in the query: AdmitBy: AddWkDays([DateReceivedForm],20,"17")...

Thanks - its all over!! Many Thanks Thats awesome and works a treat!!

Thanks!! Thats awesome thanks!!! Works a treat. 1 question though - what was the purpose of the 17 at the end of the statement - i am not sure what it does and took it out and the query still works? Thanks again

Hi Thanks for the code - it's looking good but how do I implement this in my query please? Many Thanks

: ( I tried this but it stopped my other functions from working for some strange reason. Help!

Thanks Thanks - i will give it a go. Not the best programmer so fingers crossed!! Thanks again.

New Function Hi Thanks for your reply. The code I used for the DateDiffw function is old code that I recycled. Any ideas on how to create this new function? Many Thanks

Hi Guys I need help on a problem I am having with the datediff function. I have a table in my db which has 4 date fields: DateRequested DateReceived DateReferred DateOfAdmission I have created the following module to work out weekdays (not weekends)...

Tested and Works! Hey Guys I tested this and it works! Many Thanks!!!

Thanks Hi Guys Thanks for your replies, i decided to leave work early and get drunk. I will give them a try tomorrow. Thanks again Daz

Unmatched Query Help Hi I have 2 tables with 2 fields - a name and an area. What I would like to do is compare the area fields and display any that don't match. eg. Table1 Name: Bob Area: 1 Table2 Name: Bob Area: 2 In this case I would like to see this record as the area fields...

I sorted it using the super mail merge found in samples - absolutely brilliant!!

Found the sample! Hi I have found the sample - I will give it a go and see if it works. Many Thanks for your help. I will keep this open until I have found the solution!

I had a look at samples - but didnt manage to find anything : (

Main Merge problem Hi Thanks for replying. I set up the mail merge using the wizard from word. It's very strange as it works no problem when the access database is closed but not when it is open. I will have a look at the samples as well to see if it helps. Thanks for replying.