Search results

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...

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...

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...

So I'm having some issues with this DCount in vba. I currently have vba code ask for a last name, open a form and search for that last name. Everything worked fine until... A married couple started working here. Now the code brings up both of them everytime. So what I need is for the code to...