Form help

[jober]

The form that im trying to make has three spots to fill, DiaGo,DiaNOGo,TDM & they could have up to 10 entries per field. What I'm asking is how? If i just want to populate the three with whatever numbers i have or do i need to make a new table for each?:banghead: Because on my report it will have them in columns with the entries underneath. If that makes any sense.
Dia. GoDia. No-GoTMD

 

[GinaWhipp]

I'm thinking Subforms and/or Subreports but by your initial post I am finding it difficult to wrap my head around what you are doing. Please elaborate...

 

[jober]

I work at a steel mill and we make steel bars with drill holes in them. There are push pins with sizes on them which if the pin fits in the hole " say the hole is .25 thats the DiaGo, and the DiaNoGo is .26". The TMD is the test metal distance from the top of the bar to the top of the drill point. Well call that .50" So write no we write this is an Excel page with Dia.....& TMD in there own columns. I'm moving everthing over to Access to make our lives simpler. My question is i have one tbl but only just has one listing for DiaGo,DiaNoGo, & TDM. Each bar could have up to ten enries. Would i have to make a table for each? If so i could do i just use the one name for each? Attached is the sheet that im trying to transfer over to access.

Bitmap Dia. GoDia. No-GoTMD

 

[GinaWhipp]

The *one table* is a problem, so I want to say yes you need some *look-up* tables BUT no image attached so I cannot *see* what you are talking about to say for sure.

 

[jober]

Had to send as PDF but its normally in Excel. But that pic is how i need it to be. And most of the time i dont have to fill all of the spaces. Just an FYI. I'm just not sure if access had a button to use on this or not. If i have to make a table for each thats ok. But is there a buttom to add muiltiple DIa...& TDM's? Like when i have more then one how could i add that to the form?

 

[GinaWhipp]

Okay, as I see those are Column Headers then yes I would put them in what is referred to as Look-Up Tables. BUT I still don't think we are speaking the same *language*. When you want to show multiple values under one heading you can either use a Subreport that is continuous or if they are in the same record you can just set the Detail section to Continuous and put your Labels in the Page Header section.

Side note, there is no *button* that does this for you.

 

[jober]

Ok that makes a little more sense. So that we are on the same page what i mean is this is just part of a tbl. I have a total of 5 tbl to merge into one. Im adding customers, Employees, instruments, and a few other things to make one record. Ill send along my Access database so you might see what i have gotten so far. The RCB tbl will be the one that prints out the reports to my customers.

 

[GinaWhipp]

Is this what you are looking for?

SELECT RCB.RCBID, [RCB Bar Shape].Shape, RCB.RCBDiaSectionID, [RCB Procedure].Procedure, RCB.RCBTestTypeID, RCB.EmployeeID, RCB.InstrumentsID, RCB.DepartmentID, RCB.ZoneID, RCB.TransducerID, RCB.RCB, RCB.Order, RCB.Heat, RCB.Grade, RCB.NormalSize
FROM [RCB Procedure] RIGHT JOIN ([RCB Bar Shape] RIGHT JOIN RCB ON [RCB Bar Shape].ShapeID = RCB.ShapeID) ON [RCB Procedure].ProcedureID = RCB.ProcedureID;

Note, I did not add all the Look-Up Tables.

 

[jober]

Yes when its all done that will all be added. Ill attached the semi final drawing for the report i plan on printing out for my customers. The middle is where i figured i have the most trouble bc i could have so my values with the DiaGo, nogo and the Notches Section.

 

[GinaWhipp]

Okay, so you're going to need a few Subreports using queries as the Recordsource. The sample file you uploaded did not show any reports. Have you begun that process yet?

 

[jober]

No i have not. I do have another question. With the DiaGo, NoGo section you told me to use a lookup table. Like i said b4 there could be up to ten entries per column & all different. How would i use a llokup table to make the user be able to easily enter that data? I looked online to see if someone has done this but could not find. Would i have to make a tbl for each column? What im trying to do is have the user just use the main form RCB to enter all the data but if it needs more info it sends him to that page to enter it. then back to the main form. Does that make sense?

 

[GinaWhipp]

Hmm, let me ask you a question. Is this your first time creating a database? Because leads me to believe you are unfamiliar with the way Forms/Subforms work, as well as, how Look-Up Tables work.

 

[jober]

No made one b4 but trying to make it more simple then the way i made my other one. plus this time i trying to add everything that i do into one. For instance Employees, Calibrations, RCB's, Linearity checks. I will open this database and select one of 5 catagories to chose from. Everything i do here is linked together somehow so all im tring to do is make one access database. I have a bachelors dregree in computers and elecrronics but im at a steal mill now and dont quite use what i went to school for!!! LOL The only issuses that im not aware of are the few questions i asked about. I no that i have to have a main form and all the others are subforms adding to the main. What i still dont quiet get is on excel i have a column and i fill in space below. On this im not sure how to save all the info. Like on the DiaGo NoGo and TMD the numbers are always changing but if they are the same can i recall them? The Databases i made before were a little simpler to construct. I order the 2010 Access book on Amazon to further help me on this project.

 

[jober]

But figured someone out there has done this b4, but yes still a noob with access!!

 

[GinaWhipp]

Good news then... I just wasn't sure thanks for elaborating.

Depending on the Data Model you may need five subforms BUT you could get away with less. The best thing is to do a Data Model and show it here. That will help us *see* what you are doing and help to better determine what layout you can use.

 

[jober]

Ok attached is what im working with. Again i have most of the items i need and there forms. The only thing im stuck on is the Notch section and the Dia section. I have a key code for Im not sure how to add them all togther like the spreedsheet? Bc of the muiltiple rows that i will need. Plus how will that save a primary key when it only will except one entry? If i use a Countinous form it lets me enter it but then gives me an error code of you have selected a null...... Thanks for all your help. i bought a book for kindle last night ACCESS 2010 The missing manual but doesnt seem to have what im looking for

 

[GinaWhipp]

Okay, that Data Model is not helping me see the big picture because the lines drawn to Tables are not showing me how they are related. Can you please take a screenshot of your Relationships window and post that here.

On another notes, you are using Reserved Words for field names. Not a good idea, have a look at...
http://allenbrowne.com/AppIssueBadWord.html

 

[jober]

Hope this helps.

 

[GinaWhipp]

Yes, that did help, thanks!

Okay, so you will need a few Subforms because I can see the data is in separate tables as it should be. I guess now I don't understand the problem. You put the Subforms on linking via perspective PK's to FK's. Remember this is not Excel so you can't set up the data like the Spreadsheet you need to use Form/Subform scenarios.

 

[jober]

Well the issue im having is that i dont want to use a text box but a combo box to enter the data on the form. For example i have another form that the user will use to enter the procedure then use Procedure&","& REV&","& TA&","&REV1 so that it all shows up in a combo box. Can this be done with it being unbound? and of course i need to have muiltiple Procedures per RCB, & muiltiples for the Dia, NoGo, TMD, and the notch section.