 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008FORMS
Hi All, I've created a form using multiple tables for data entry. If I do not fill in all entries in the form, my form record count at the bottom will not count the entry. I will have the data in my table but I do not see it in the form. I have set my relationship to 1 to 1 with a primary key. How do I capture/count all records in my form? Please Help. Thank you Hi, it sounds as though the relationship 1 to 1 is causing the problems. Can you post back with some details about your tables, here is an example of the info that would help us to help you. Name of table Name of primary key field Name of another important field in this table Do the above process for all the tables that are used for the form with the problem. Jeanette Cunningham > Hi All, > [quoted text clipped - 10 lines] > > Thank you Table1: WellInfo = API (PK), wellname, Wellnumber, Company Table2: SonicCurve = API (PK), DT, TVT,SDT, CDT Table3: ResCurve = API (PK), ILD, ILM,M2RX, M2R9 In a form I want to enter my well information and then if that well has a particular curve associated with it I would like to add that data. As of now in my form I entre all the well information and say I have only the DT curve (under SonicCurve) and no data for ResCurve. When I get out of the form and come back in I will not have the record in my form display but it will be in my table.... Thanks Jeanette for your help and any suggestions. Sean > Hi, > it sounds as though the relationship 1 to 1 is causing the problems. [quoted text clipped - 24 lines] > > > > Thank you Yes, the table setup is causing the problem with the form. Before I make any suggestions, could you explain a little about sonic curve and res curve fit with a well. can a well have both a sonic curve and a res curve? or can a well only have either a sonic curve or a res curve or no curve? with the fields in table sonic curve do you need to fill in the dt, tvt, sdt and cdt for each well that has a sonic curve? and similar for res curve? Jeanette Cunningham > Table1: WellInfo = API (PK), wellname, Wellnumber, Company > Table2: SonicCurve = API (PK), DT, TVT,SDT, CDT [quoted text clipped - 45 lines] >> > >> > Thank you Thanks again Jeanette. For any type of curve I will have a well but I could have a well with no curve. A well can have both sonic curve and a res surve in the same well. A well can also have only a sonic curve and no res curve or have res curve and no sonic curve. I will have to fill in each curve name for a well. Ex1. A well has a DT curve I want to fill in the well info and under the sonic curve fill in DT Ex2. A well has a DT and ILD cuves I want to fill in the well info and under the sonic curve fill il DT and under the res curve fill in the ILD curve. Thanks so much for your help! > Yes, > the table setup is causing the problem with the form. [quoted text clipped - 56 lines] > >> > > >> > Thank you 2 important questions that impact on how many tables for this database: Will a well ever have more than 1 Sonic curve, or more than 1 ResCurve or more than 1 PorCurve? Will a well ever have more than 1 company? If the answer to both questions is no, put all the details in the same table. tblWells . API > Primary Key A single field for each of Well name Well No Company DT TVT SDT CDT ILD ILM etc For any of the above fields that are text data type, I usually set the property called Allow Zero Length to No. For any of the above fields that are number data type, I always clear any zero from the Default Value property. Points to consider: Will you want to search for all wells that have a sonic curve? Or all wells with both a Res curve and a Por Curve? for example? If a well has a sonic curve, will you always fill in a value for DT? If a well has a res curve, will you always fill in a value for ILD? If a well has a por curve, will you always fill in a value for POR? Create a form for entering well details Group the text boxes for sonic curve together and put a box around all 4 txtboxes and a label saying Sonic curve Similar for the other 2 curves Open the form in design view On the data tab set Allow Additions to yes and Data Entry to No Jeanette Cunningham > Thanks again Jeanette. For any type of curve I will have a well but I > could [quoted text clipped - 11 lines] > I want to fill in the well info and under the sonic curve fill il DT and > under the res curve fill in the ILD curve. Jeanette, I can have many sonic curve types for one well. Ex. Well 1 could have curves DT, TVT, ILD (sonic, sonic, res) Well2 could have DT (sonic) only Well3 could have ILD, ILM, M2RX (res, res, res) only In my form, if I do not fill in at least one entry for evry field then at the bottom of my form (record:) I will not get all entries. Thanks Jeanette > 2 important questions that impact on how many tables for this database: > Will a well ever have more than 1 Sonic curve, or more than 1 ResCurve or [quoted text clipped - 52 lines] > > I want to fill in the well info and under the sonic curve fill il DT and > > under the res curve fill in the ILD curve. Hi, Sorry it is taking me a while to understand about wells and curve types. This is the most important stage for doing a database. If we get this bit right it will all be fairly easy from here on, but if we get it wrong, it will work for a while then you will have to go back and redo the whole setup. I had a bit of a browse on the internet for sonic and res curves and these is a multitude of curve types. Here is how I understand what you want to do - please correct me if I am wrong. The main form has a text box where you can type in the number, name and company for the well. On the form there is a way to record all the different types of curves for that well For example: --a checkbox for each type of curve --a list showing all the curve types and you can select as many curve types as you wish --any curve type can only be selected once only --with each curve type there is no other information about the curve type that you want to keep in the database --later on you may want to go back to a particular well and change which curve types it has. --you will want to print a report showing all the different types of curve for each well --you may want to print a report showing all the wells with a particular curve type Jeanette Cunningham > Jeanette, I can have many sonic curve types for one well. > Ex. Well 1 could have curves DT, TVT, ILD (sonic, sonic, res) [quoted text clipped - 65 lines] >> > and >> > under the res curve fill in the ILD curve. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.