Search results

Thanks vbaInet....I think End_Date actually isn't that important. When the user enters a date range in the resourcing form it actually creates a number of records with incrementing start dates but the end date is blank. Basically it creates a record for every single day rather than a date...

Actually the way the records exist in the Resources table It would need to check Trainer_Name, Start_Date and Duration for each date within the range.

Eureka!!!!! Well almost. Now I get the popup but it won't let me program anyone for 02/01/2014 saying everything is a duplicate entry. Do I need some sort of code to let it know that th duplicate combination should be fired when Trainer_Name and Start_Date and End_Date result in duplicates?

No idea what that was doing in there. However the syntax error now appears after I click 'create record' having created a duplicate entry. The first pop up tells me I'm about to append rows (which I expect) then the error pops up

The form in question is called Resourcing:)

See if this works

Have compiled but still get the same. As soon as I tab out of start date I get the error and when I debug it goes to the following line of code: intCheck = DCount("*", "[Resourcing]", strCondition) I would send a copy of the db but it's 3.5mb when zipped

As always I really appreciate your time on this The issue I have is that the error occurs as soon as I enter a start date so I don't get the chance to enter an end date. Perhaps the screenshot will help. This is the form that the user is inputting to.

Thanks vbaInet As soon as I enter a start date the debugger starts. I get an error message see picture attached. It then highlights this line of code [code intCheck = DCount("*", "[Resourcing]", strCondition) [/code] :banghead:

Thanks vbainet. Why can't you read the code? When I go to set the property for the before update event it creates the line Private Sub Form_BeforeUpdate(Cancel As Integer) The person who wrote the air code that I am adapting had the first line as Function ISITOK(Trainer_Name, Start_Date...

Think I've sorted out my issue with the ElseIf sataements in the final block but I'm still doing something wrong. It seems to want End Sub as the second line before the function runs. I'm also worried that it automatically Keeps changing AM to Am Private Sub Form_BeforeUpdate(Cancel As...

Thanks vbaInet Your a star. I really appreciate it. Guinness

Hi Guys I got some air code to get me started but the person who wrote this for me is offline and I'm struggling to adapt it. At the moment I can't even test it as VBA does not like the ElseIf statements in the last block of the code. Can any of you guys have a look over this and point me in...

Thanks vbaInet As you are more aware than most I need all the help I can muster

Also I don't just want to create an error, I want to offer a choice of solution; either edit the record that you are creating or open the edit hours table and edit or remove the existing record

Of course you're ahead of me on not only this one but on every one :D The problem I'm struggling with, with this approach is that there are three variables. You can't book an all day if there is already an AM or a PM but you can book an AM and a PM on the same day. So date can't be a...

Hello again vbInet For once I'm ahead of you but lack your skill. It did occur to me that if I created a unique field based on other fields then I could prevent duplicates within the table i.e. Joe blogs is resourced for AM on 01012014. Create a unique entry like jba01012014. Creating...

Thanks for showing an interest BlueIshDan I don't know if the attached image Picture 1.png might help. It's the design view of my crosstab query and shows all of the fields from the Resources table and the dates table which litterally is just a list of working days from 02/01/2014-31/10/2017...

Hi BlueIshDan Here's all the code already attached to the form in question. As I said though I have no idea where to start with the code to check for conflicts so have no code to show you. As I said before I would need someone to write the code for me or provide an example of something...

Hi BlueIshDan I seriously wish I could write the code myself but I haven't a clue where to start. The only bits and pieces of code I have picked up are from reverse engineering code found online, created automatically by macros or sourced by the good folks on here. So I suppose I'm really...