Recent content by carole

Thanks again for the help... yes, one direction I was thinking is that one attribute applies to many serial numbers. In our work we measure one attribute of all the serial numbers before moving to the next attribute. I will give rev 03 a shot.

Ok, I have a couple questions about the carole01 database nanscombe built. I don't see where relationships are defined. Was that just left out or is there a different way to do them? I am trying to flip-flop the frmItem so the attribute is in the main form and the sub form lists the...

Thanks! it helps having a visual

When you say do you mean tblSerialNum.SerialNumID one to many tblSerailNumAttribute.SerialNumID?

That sounds great. I will try it and let you know if I have issues. Thank you so much!

That does make sense. I will try it. How can I then transfer the information in tblSerialNumAttributes to a form?

Hi, I am very new to Access. I know the basics about tables, queries, forms, relationships, etc such that I can modify existing databases, but now I am trying to build one from the ground up. The database will be for collecting inspection data. I am planning the table to have serial numbers...

Thanks, I am reading it now. any source of information is helpful. Also, sometimes what I need is a kick in the opposite direction :)

on the order of 100 fields.... maybe I can split it in half if I design my table differently, but I would need to access both tables still for data entry

Thank you!!! Fortunately I have programmed in other languages and in VBA in Excel, so hopefully I am part of the way there.

I am a supreme newbie at building databases. I can understand and modify existing ones, but I have never built my own. I have one that I need to build, and it will eventually hold quite a bit of data at any given time. It also needs to be able to allow multiple users to input data. I have a...

Hi Everyone, I have searched these threads and found them very helpful and now I have questions of my own. I am building a database at work, and I have been trying to work up the nerve to use VBA in access for a while. I hope this helps me! Thanks!