Search results

Hi! I have a field that has a description of the project I'm working on, which has client information on it. I want to take all 600 of those records and copy them to fields in the same table, so that I can remove the client information, which will allow me to pull whichever of those two I need...

Hi All! So I have a form that has a sub form on it (based off of a junction table), indicating which category a particular project belongs to. It can belong to multiple categories: ProjectID 100 Category Admin Finance But I want to run a query to find all of the projects that are both admin...

Hi! In design view I moved around some of the fields of a subform for them to make more sense for data entry purposes, but when I save it and go back to the main form in view, the changes are not reflected. I even tried editing it in the subform itself and it still won't reflect the changes...

Hello! I'm trying to figure out a way to use Access instead of Excel to do some tracking. What is being tracked: The number of days between a project due date and the actual date is being turned in, the day there is feedback given, and the day that it's sent on to our client, the day that...

HI! So when BD comes to me and asks me for specific information, and I run a query to create a report, do I save the query and report that I've created? It kind of drives me crazy to have them in the navigation pane, but I didn't know if it was typical to save them? Or do you export them and...

When I was building my database, I had to take a lot of tables and turn them into junction tables since there could be so many records per project. For example: On FormProjectDetails (where I enter in all the project details) I have SubFormStudyDesign, which can have 0 to 8 entries for one...

Hi! So, maybe this is bad design (please tell me if it is) but I have a table that has the list of "Project design" choices, and I enter in there the choices that a project can be. I then have that table related to a junction table that has the "Project design choices" linked to the "project...

Hi, I just ran a query off of a junction table for project design types. When I run the query, it comes back with 6,000 records, even though i only have 600 projects. Why does it come back with so many multiples? what am I doing wrong here? Thanks!

Why is it that Access stumps me every other day!? I had to create a table that would track two layers of employee experience: This is what I did for my two levels of CRA experience (thanks to the help of another use): You kind of have to break what you have now and start over--your...

Hi All, I really just wanted some opinions. When I first was making my database I used all auto numbers for PK's. But then I read an article or two saying that you really don't need to do that if you don't have to (actually, the article said "don't use autonumber if you want anyone to...

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

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

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

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

Hi! Question: I have Form Project Details that I made for data entry. I based it off of a query that I made off of TblProject Details. TblClientDetails has a one to many relationship with TblProjectDetails (based off of an PK of a name and ID). My question is this: When I view the form in...

Hi All! Thanks for all of the help in the past month or so. I still have a lot of learning to do, but I think that for now, I can actually use the database. My next question is just a general access question. I created a database that has all of our project information in it, and in that...

Hi, When I enter a combo box on a form, whatever I choose from the combo box, it populates everything. If I go to a different row to change it, it changes them all. How do I get that to stop? And why does it do that? Thanks!

Hi Again! I've have been googling this question for awhile now, and I still can't find a clear answer. When you have junction tables for your many to many relationships, do you put the data into that table? Or just in the two tables that are joined to the junction table? If you don't enter...

Hi All, I'm brand new to Access and this forum, and have been slated to build a database on my company's experience. I'm trying to figure out the correct relationships and table design and I'm having some issues. The way I've broken it down, I have about 8 tables, and 6 of those 8 end up...