Recent content by andreohnona

Hi, Is it possible to display only the cell that is selected? How about just a select group of cells (e.g. selected cell + the two cells to the right)? Context I am trying to program a YES/NO questionaire with hyperlinks. Depending on your answer to question 1 you get a different question 2...

Doc Man & Pat, Thanks a lot for the explanations. Definitely helps! regards, Andre

Hi guys, Does anyone know of a good resource (thread? website? whatever..) where i could learn the basics of programming Events? I'm not looking for anything too advanced, just the basic stuff that one needs to design a user friendly database. thanks, Andre

Thanks a lot Doc Man! This really helps my understanding. I have now read up on Normalization and can see things a little more clearly. best regards. Andre

Hi, Two questions regarding choosing & using primary keys: 1) Is it always recommended to use Autonumber as primary key? What about a scenario where the table already has an inherently unique identifier, such as a part number in a product table? What about junction tables? 2) In scenarios...

Thanks a lot! I will re-work my manufacturing DB design, based on the info from this example. Just for my personal education: why is it a bad idea to list the all ingredients in one record? (i.e. "option 2" in my original posting ) does it make it more complicated to work with the data...

Hi, Context I am a database novice currently in the process of building an access database to manage production in a manufacturing company. Simplified Version of Problem Suppose I wanted to build a database to manage the baking process at a bakery. Goal is to eventually generate a report...

Hi, I need to run a parameter query in which you enter a product number and the query (a) returns the list of components and (b) then automatically reruns the query for these components. In other words, I enter an input (a product number) the query gives me outputs (component numbers) and then...