Search results

Wow. I now see that this is not difficult! I don't know what I was thinking! Maybe I needed a day away from it to see it, but it makes sense now!! Thanks SO much, I really appreciate it!

Hi! Ok, so I don't know what I don't understand, or what I did wrong... but I can't get it to work at all. If you have the time, could you give me the most dumbed down explanation possible? When I was trying to enter in the Employee's sub experience in this table: EmployeeExperience EmpID...

Oh ok. I may be over thinking this... I guess I just need to implement it, and see how it works before I'll really get it. It doesn't matter how many times I read articles or examples, it won't click until I see it working in my own database. Thanks so much for all of your input. Hopefully...

Ok, I am really confused trying to implement this. Which tables do I create relationships between? I think that where I lose it is ExperienceSubCategories ExpSubCatID, ExpCatID, ExpSubCatDesc 1, 1, Problem Solving 2, 1, Data Entry 3, 2, Industrial Engineering 4, 2, Mechanical Engineering I...

Oh ok. That makes sense. I will probably end up changing to a query, just because that's how everything else is. I guess consistency will be a good habit to start. Thanks for your input!!

Thanks! I *think* I will be able to make this work. The only question I have right now is the description field. Do I really need to have a description in there? I'll be giving this a go tomorrow afternoon and will let you know if I get stuck. Thank you SO much. I appreciate it very much!

Hi! Sigh, Another day, another new Access question. I have an Employee Table that's related to my Employee Experience table. That's working out beautifully. The new issue I'm facing is how to add another level to the Experience table. Right now I track their major category experience, such...

Hi! When I started building forms to fill my junction tables, the example that I looked at based them all off of queries. That's what I've done for the most part. However, this latest subform that I've made and embedded into a main form is based off of a table. Will that cause problems for...

Yes! I am using a subform on the main form, and I think that will work. Now I just have to figure out check boxes :/

Never mind! I think I got it to work: Do any of you see any issue with how I did it? Created the subform off of TblJunctionProjectDesignchoice and put it in the projectdetails main form. So I then could run a query and find specific project design.

ok, so I resigned myself to trying to figure this out with a seperate table. What I did: 1.Created table that is called Project Design PKProjectDesignID 2.Created a junction table that has PKProjectID_ProjectDesign FKProjectID FKProjectDesign Linked them all (ProjectDetails and...

Yeah, I may. It wasn't a problem originally, but the requests of the person using the database keep changing/adding things. It's hard to deal with since I'm so new, each new request brings on a whole host of learning challenges. So if I create a many to many relationship, thus requiring a...

Hi! I'm designing my form and I have a problem. I have five combo boxes for which the user to pick the design of the project. That's all fine and good, but the problem arises when I want to run a query. There is no rhyme or reason to the design of the projects. By that, I mean, the order in...

Is this something that I will need the help of the IT department for? Can I send the database from my laptop Access over email to my desktop copy of Access? And if I'm the only back end user, I will be able to update and change things on the server copy, and it will update to the front end users...

Hi! I work remotely from a lap top, and sometimes connect to my desktop that's physically in the office. Both my lap top and the desktop in the office have Access on them. As I was designing the database for my company, I did it on my laptop because it performs much faster than connecting...

Thanks, Pat! I'll give it a try soon!

So if I do create a new table, would I just have their name, and then would each experience item need it's own field for it to work best? So I would have : NAME: Experience 1 Experience 2 Experience 3 .... and so on up to 50 or so Or is there a smarter way to do it? I have seen some...

Hi Boblarson, Just wanted to give you an update. I made it work. I made one combo box where I just put the Client ID, and then a completely separate box for the Client name, and obviously they have to match table that I got them from. That seemed to satisfy the problem! Thanks!

Hi Friends! I feel like for every one thing I learn how to do in Access, it uncovers 50,000 more things that I need to learn! My issue is this: I have all of our employees in a form that also shows which projects they are working on, as well as their location. I wanted to add to this form a...

Thanks. I'll check it out. I shouldn't have any look up tables, I have read that article so many times! But I'll double check. Side note: I was reading an Access book when I first started this process, and the only mention of look up tables causing problems was a TINY paragraph on the top...