Search results

Thank you for all your help, It looks to me that your database would be able to enter new types of tests, but not necessarily new test results, unless I've missed something. I apologize that I have either not communicated what I'm trying to do effectively or I'm too dense to understand how...

Thank you very much! I'll play with it!

Hey, I've been working on that suggestion you made yesterday about seperating out the reports, results and tests tables but I'm either not quite getting the vision still or maybe my description of the scenario wasn't very clear. I think that a more accurate description of my tables would...

Oh wow, ok. I'm struggling to wrap my head around that concept a little bit, but I appreciate the nudge in the right direction :) I'll play with that and see where that takes me, Thanks!

I've setup my database to allow data entry for results of microbiological tests. We run 3 different types of tests depending on what is being tested, but all three tests are sent back to us in a similar format. The main difference is that a few test names are different. In this example, I've...

Oh thanks for the post, dang, I should have added that my ability to watch videos is blocked while I'm at work. I'll keep looking, thanks again!

I'm pretty unfamiliar with subforms and how they work and so far my tinkering hasn't been getting the job done. Instead of trying to walk through the problems I'm having, I wonder if anyone has a good Subform Tutorial they like that they would be willing to recommend. Thanks! Bruce

Thanks for your response. I have my tables setup like what you are suggesting. I have the relationships setup as you suggested as well. I'm at the point where I need to build the form / subform. I've never done anything with Subforms before. I wonder if you could give me a brief idea on...

I have an idea in my head of what I want to do, I'm hoping I can effectively communicate what that is. My terminology may not be perfect, so I appreciate your patience :) I'm making a database that will store all of our micro bio testing results. In a given day multiple tests may be run...

Thank you very much! that pushes me in the right direction, I appreciate it!

Thanks for your response. During a given day there will usually be more than one lot number used, I don't know if that changes anything, I'm sorry I wasn't clear on that before. Additionally the same lot number may be used multiple times. As far as the two tables go, I can kind of see...

Apparently all my spaces were stripped when I made my post.... Hopefully that still makes some kind of sense ><

I'm self-taught, and somewhat new to creating Access databases, this will be my third. My needs for this database are going to be somewhat different than were my needs for the previous 2 and I was hoping to get some general advice for how to start before I dive in and make a mess. My needs...

I apologize, My limited vocabulary may make this harder than it needs to be. Essentially I have a memo field that I use to store special instructions for each of our products. This memo field appears on a form along with all the other pertinant fields to the product. For some reason every...

It isnt, it is plain text. Would it be easier to work with if it was rich text?

I'm not sure what you mean? I just push "enter"

Access 2010 My form Currently has a memo field that has enter key behavior set to: "New Line in Field". The problem I'm having is that each time I push enter it skips a line so I have double spaces between each carriage return. Is there a way to change this? Thanks!

awesome, this is exactly what I am wanting to do. So the problem I ran into was that when I tried to create the relationship between the table and itself using the lookup wizard, it returned only one result: #NAME? I'm obviously doing something wrong, but I'm not sure what it is.

I've been working more or less as a DBA for about the last 5 months. I started with almost no experience and have been learning as I go ever since. My abilities would probably still be considered very basic by any standard, but I have discovered that it is something that I enjoy and that I would...

Is it possible to have a table that has a relationship with itself or is it better to create a second table? I have a table: tblProductInfo - ItemNumber (PK) - Description - Material The way our production works, every step in the production process creates a completely new product. This...