Recent content by dhannant

I agree with both of you in the sense that this my least prefered method of doing this however, I've not found a better way. In my original post i mentioned I would much rather find a vba solution, but I just haven't found it. The problem is that this code isn't updated from a form. It's...

jdraw, I came to the same conclusion after running a few tests. Normally, in the actual database at work it's all done through the use of forms. Members get populated automatically to tblRoster during an import function from excel, after that personnel are assigned to positions if required...

wow that's crazy... I was so close to the write code. Macros seem so much more difficult than vba I feel like. Anyway thanks for the help guys I really appreciate it. I'll try this out larger scale tomorrow at work but being that it works like this I see no reason it should work out. By...

ok so on tblRoster goto the AfterUpdate event and you'll see the code written as above. Basically, when you change TCode to anything other than it's current state (the only one that has a TCode assigned at the moment is Jason Vorhes... just for fun). When that code changes it should look up...

So I can't upload the actual database due to PII info and the fact that I'm now at home but I have a sample DB I use to work on ideas which I've attached. It's set up the exact same way as the DB at work minus fields that don't really come into play for this scenario. It doesn't have any forms...

Thanks for the response however, this seems to give me an error even during manual updates now. Description: The identifier '[jnctblPositionRoster].[PositionID]' could not be found. Context: SetLocalVar PositionID, [jnctblPositionRoster].[PositionID] Also... I think there was a type-o on the...

Forgot to post the link to the original question. https://www.access-programmers.co.uk/forums/showthread.php?p=1574688#post1574688

I apparently posted my original question in the wrong are so it's located here at the link below. Essentially I know that the macro is working when I update the one field manually. So I know all the looks ups and what not work however, when I use a query to update tblRoster, the macro doesn't...

Sorry I didn't get back to you earlier but I am apparently unable to access this site from work. I guess that's something new. Anyway... yes the the junction table only allows one RosterID input. From tblRoster to jcntblPositionRoster it's a one-to-one. I will link to this question as you...

Not sure what you mean. It's not a sample... that's the code. I just used the macro function names like you would find in the editor since it's not vba. Only thing missing is the setfield part. Edit: the other thing is that like I said... the code works manually but not when done with a...

I have a roster called tblroster with PK as SSN. I have another 2 tables that work with roster called tblPositionNumber and jnctblPositionRoster. Basically, I import an excel doc that updates a code on tblroster. I have a notes field on tblPositionNumber that needs to be updated when this...

I'm having some trouble figuring out a good way to conditionally format some items in a form / subform relationship. Basically, I have a form called frm_TruckManifest with a subform called frm_TruckManifest Subform. They are linked child to master properly and the design actually works pretty...

Thank you both for the information... not only did it do what I wanted I was able to add on additional features like when the project has been reviewed by which people... not a feature needed as I was just playing around with an idea but hey... I know how now if I wanted to do something along...

So I'm sure this is a very simple answer but I am having some serious issue. I've got 2 tables... tbl_employees and tbl_projects. They are both pretty obvious on what they contain. Numerous people can be assigned to a project but there is only 1 Lead. So I assign individuals to a...

jeez... I read and read and read and even after you posted it again I still missed 1 '... that was the problem. Thanks a lot guys. Feel kinda retarded now though.