 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2006Date enty form
I created a form and I want to see all previous items in the form. Exampel 1 of 31 records but when I select Data entry No the 1 of 31 appears for a brief moment. When I close the form and go back in to look at it again, the form shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have problems with any of the the other forms I have have created. I don't believe data entry allows you to view records, only add them. So just set data entry to No. >I created a form and I want to see all previous items in the form. Exampel >1 [quoted text clipped - 4 lines] > shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have > problems with any of the the other forms I have have created. If a form is set as data entry, then that is the correct functionality. If you want to see all records, then turn off the data entry property.  SignatureRick B >I created a form and I want to see all previous items in the form. Exampel >1 [quoted text clipped - 4 lines] > shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have > problems with any of the the other forms I have have created. The response did not help at all. Let's try it again. History - I have several forms where I can see 1 record of 28 and I can scroll through and view all records. This new form will not stay in the data entry mode. When the form comes up, I see a new form ( 1 of 1 record) - this is not what I want to see. I want to see 1 of 27 records because I have users that has to add data to this form and need to see the amounts that has already been entered in Oct, Nov, Dec, etc. and not start a new form over again. I want the form to come up with filled information and show the fiields that need to be filled also. > I created a form and I want to see all previous items in the form. Exampel 1 > of 31 records but when I select Data entry No the 1 of 31 appears for a brief > moment. When I close the form and go back in to look at it again, the form > shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have > problems with any of the the other forms I have have created. You say there are 27 records. Do you want to pull up the form with a particular record displayed? You say you want them to see the information filled in and also show fields that need to be filled in. That does not make much sense. In any given record, there are fields. If a record is added to the database and some fields are filled in, but some are not the record can be saved (unless you have required the fields). If you have 27 records in your table and each has some data missing, what do you want the user to see? You can code your form to jump to a specific record, but you are not making it clear which record you want. To have the user see 1 of 27, simply turn off the data entry property and add code to jump to the first record (number 1) when the form opens. Note that the record number is not something you should be using to identify which record you need. Normally you would have some other unique field in your table to help you identify the appropriate record. SignatureRick B > The response did not help at all. Let's try it again. History - I have > several forms where I can see 1 record of 28 and I can scroll through and [quoted text clipped - 18 lines] >> shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have >> problems with any of the the other forms I have have created. Yes, I have 27 records and I want the form to display the 1st record - (1 of 27). I want to be able to display the data in the next record (2 of 27). I have a table that shows a list of employees with monthly payments for Health Insurance - Oct, Nov, Dec, Jan, Feb- ( Amounts filled in). Mar, Apr, May (pending payment - blanks, to be filled). I want the user to be able to pull the form up with the data that they have already entered and fill in the payment for Mar and then next month pull the form up again (able to see Oct, Nov, Dec, Jan, Feb, Mar) and filled in Apr, and so on. Not pull up a new form an type all information over again which creates another entry line and no data for Oct, Nov, Dec, Jan, Feb, Mar. > You say there are 27 records. Do you want to pull up the form with a > particular record displayed? [quoted text clipped - 38 lines] > >> shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have > >> problems with any of the the other forms I have have created. I will let someone else jump in here. It sounds to me like your table is poorly designed. Are you saying that your table has a field for each month in which a payment should be made? If so, your design is wrong. Your field names should never contain data (like the name of a particular month). Maybe I misunderstand though. To answer your underlying question though, turn off data entry mode. That way all records will be displayed. In the open event of the form, simply tell it to go to the first record... DoCmd.GoToRecord ,,acFirst SignatureRick B > Yes, I have 27 records and I want the form to display the 1st record - (1 > of [quoted text clipped - 69 lines] >> >> have >> >> problems with any of the the other forms I have have created. Adarr, I can't comment on your table structure, but I don't think you are understanding Jay and Rick's recommendation. Access objects, including Forms and Controls, have Properties that can be set that affect how the object behaves. Forms have a Data Entry property, that, if set to Yes, opens with a blank record. To set it to No, which will let you browse through existing records, open the form in Design View and choose View, Properties from the menu. Choose the Data tab, move to the DataEntry field, and select or type No, and save the form. Hope that helps. Sprinks > Yes, I have 27 records and I want the form to display the 1st record - (1 of > 27). I want to be able to display the data in the next record (2 of 27). I [quoted text clipped - 49 lines] > > >> shows 1 of 1 again. How do I fix this to stay at 1 of 31. I do not have > > >> problems with any of the the other forms I have have created. > The response did not help at all. Let's try it again. History - I > have several forms where I can see 1 record of 28 and I can scroll > through and view all records. This new form will not stay in the > data entry mode. [snip] The problem is that your definition of "Data Entry Mode" is not what Access means by "Data Entry Mode". To Access, "Data Entry Mode" means you want the form to be used to enter new records ONLY and have no interest in seeing previously entered records. If you DO want to see previously entered records then you need to turn that feature off. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
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.