Search results

Here is the table structure... Thank you!

I've been at it all day... :confused: Still no luck. I just can't figure out exactly how to create, what query. I've been basing my query on the Department/Task table, but then how do I do I set my comobo1 to be a criteria in that same query? Did I misunderstand KenHigg? Any help would be...

I understand I need a new Department/Task Table. Do I need a primary key here or do I create relationships from this table with tblDepartment and tblTasks? This this is a little unclear: "Then in combo 2, set it's row source to a query which has combo 1 as a criteira." Could you explain in a...

I have a combo box on one form where a person picks a department. On the next form there is a combo box with all the tasks that all departments can do (training, programming, customer service, etc). I want to tie each department to each specific set of tasks so when a user clicks on a certain...

Thank you, thank you! That works beatifully!

that was great advice, now one more thing how can i create 2 coditions on which a form opens? Right now there is: stLinkCriteria = "[Project_ID]=" & Me![Combo0] DoCmd.OpenForm stDocName, , , stLinkCriteria I want something like stLinkCriteria2 = "[StaffID]=" & Me![Combo2] DoCmd.OpenForm...

I think I got my relationship lesson down and now that I'm trying to move on to create some forms I'm running into problems again. I'm attaching a sample of my database, so hopefully someone could put me back on the right track. I have 2 forms frmDates and frmProjectStaff. On my ProjectStaff...

OK, here I go again, still struggling with the same relationship. I got it to work on the RI part, now I want to create a query for my form, where someone will be able to pick (from drop down) a project (by name, not ID) and a person, or people (by name, not by ID) and tie them to that project...

Thanks, that makes more sense.

It worked this time, but I don't know if this is what I want. I actually want names displayed, rather than IDs when I go back to the Project table, when you click on the "+". May this won't matter once I build my forms. Not sure, but you thank you for your reply. So, The_Doc_Man, is it...

OK, I'm trying to set up my tables according to "The_Doc_Man" suggestions. From what I understood, I really need 3 tables in order to connect 2 tables together. I guess I'm missing something somewhere... Attached is a picture of my very first relationship and I know I'm doing something wrong...

Thank you! I loved the post! I did feel like I was back in college and it actually brought a big smile to my face :D , so thank you! I will start with this new flow process asap and I know that I will be able to find more help from people like you, who are always willing to take their time and help.

Thank you for all your help. I will try what you suggested and go from there. Thank you, again.

One more thing...that i'm not sure about is how do i tie multiple Functional Areas to one resource? Should this be a separate table and if so, how would I connect it? I don't think I want to create all functional areas next to 1 person, there are just too many and this table would have many...

Thank you so much! This will definetly be a big help!

:confused: I’m trying to figure out the best way to implement a database. It will contain information about all projects (which there might be 10, 20, 30 of them at one time) as well as all of the staff information as well. Staff information will contain staff names, their expertise, dates when...

That helped! Previously I was clicking just on the subform itself, without going through the main form first! Thanks so much for all your help!

When I try and create an unbound control and assign a value from my subform, it's still saying #Name? What I'm doing is creating a text box on the main form, and then I tie in the value from subform to tex teboxs' control source. Is there something wrong with that? I tried this both ways, with...

I have a form on which I have 3 subforms based on separate queries. I have some totals on each of those subforms that I would like to add together. I created a unbound control and I tried to add up values from subfoms and it's saying "#Name?" Not sure what I'm doing wrong...or can these values...

Thank you so much for all your help!