If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot view multiple records in Form view
I am using Access 2000. I have three tables and one
form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather |
#2
|
|||
|
|||
Cannot view multiple records in Form view
1. Open your form in design view.
2. Open the Properties box (View menu). 3. Set the Data Entry property to No (Data tab). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Heather" wrote in message ... I am using Access 2000. I have three tables and one form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather |
#3
|
|||
|
|||
Cannot view multiple records in Form view
Any other suggestions? The Data Entry property was
already set to "No" -----Original Message----- 1. Open your form in design view. 2. Open the Properties box (View menu). 3. Set the Data Entry property to No (Data tab). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Heather" wrote in message ... I am using Access 2000. I have three tables and one form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather . |
#4
|
|||
|
|||
Cannot view multiple records in Form view
Hey Heather - Please post the recordsource of the form.
If it's not the Data Entry property, then probably the recordsource of the form has some criteria that is excluding all records. - Anne -----Original Message----- Any other suggestions? The Data Entry property was already set to "No" -----Original Message----- 1. Open your form in design view. 2. Open the Properties box (View menu). 3. Set the Data Entry property to No (Data tab). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Heather" wrote in message ... I am using Access 2000. I have three tables and one form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather . . |
#5
|
|||
|
|||
Cannot view multiple records in Form view
I used the Form Wizard to create this form. I'm very new
with Access, but I think this is what you're talking about. SELECT [tblIdentification Data].[Name], [tblIdentification Data].[Social Security #] AS [tblIdentification Data_Social Security #], [tblIdentification Data]. [Employee ID], [tblIdentification Data].[Address], [tblIdentification Data].[Phone Number], [tblIdentification Data].[Birth Date], [tblIdentification Data].[Program], [tblIdentification Data].[Program Status], [tblIdentification Data].[Amount Received], [tblIdentification Data].[School], [tblIdentification Data].[Graduation Date], [tblCollection Data].[Reason for Default], [tblCollection Data].[Default Date], [tblCollection Data].[Total Amount Due], [tblCollection Data].[Date of 1st Letter], [tblCollection Data].[Date of 2nd Letter], [tblCollection Data].[Date to Collections], [tblCollection Data].[Paid Amount], [tblCollection Data]. [Date of Payment], [tblCollection Data].[Type of Payment], [tblCollection Data].[Date to HR Finance], [tblCollection Data].[Comments], [tblCollection Data].[Social Security #] AS [tblCollection Data_Social Security #], [tblSON Default Interest].[Sent to Tax Dept] FROM ([tblIdentification Data] INNER JOIN [tblCollection Data] ON [tblIdentification Data].[Social Security #]= [tblCollection Data].[Social Security #]) INNER JOIN [tblSON Default Interest] ON [tblCollection Data].[Social Security #]=[tblSON Default Interest].[Social Security #]; -----Original Message----- Hey Heather - Please post the recordsource of the form. If it's not the Data Entry property, then probably the recordsource of the form has some criteria that is excluding all records. - Anne -----Original Message----- Any other suggestions? The Data Entry property was already set to "No" -----Original Message----- 1. Open your form in design view. 2. Open the Properties box (View menu). 3. Set the Data Entry property to No (Data tab). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Heather" wrote in message .. . I am using Access 2000. I have three tables and one form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather . . . |
#6
|
|||
|
|||
Cannot view multiple records in Form view
Hi Heather -
Yup, that's what I was talking about. This query has the words "INNER JOIN" in it. If you were to look at this in query design view, the "INNER JOIN" would be represented as a line between the two tables with no arrows on either end. In an "INNER JOIN" records are only selected if they appear in BOTH tables. So in your example, records will only be pulled if there is a corresponding record in EACH of your talbes [tblIdentification Data],[tblCollection Data] and [tblSON Default Interest]. If any of those tables do not have a record, then the query wont return anything. So if, for example, there is a record in tblIdentification Data, but there are no corresponding records in tblCollection Data, then nothing will be returned. Does that make sense? To fix this problem, you need to figure out which table you want to be the "Master" table. This is the table that will ALWAYS have inforamtion in it, even if the others are blank, probably tblIdentification Data from what I can see here. Then open the form sql in query design view, by clicking on the three dot button next to the property. You'll now see the three tables joined by lines. Double click on the line and access will open up a dialog box labeled "join properties". Choose the option that says "Include ALL records from [your master table] ...". Repeat that for the other join and you should be all set. - Anne -----Original Message----- I used the Form Wizard to create this form. I'm very new with Access, but I think this is what you're talking about. SELECT [tblIdentification Data].[Name], [tblIdentification Data].[Social Security #] AS [tblIdentification Data_Social Security #], [tblIdentification Data]. [Employee ID], [tblIdentification Data].[Address], [tblIdentification Data].[Phone Number], [tblIdentification Data].[Birth Date], [tblIdentification Data].[Program], [tblIdentification Data].[Program Status], [tblIdentification Data].[Amount Received], [tblIdentification Data].[School], [tblIdentification Data].[Graduation Date], [tblCollection Data].[Reason for Default], [tblCollection Data].[Default Date], [tblCollection Data].[Total Amount Due], [tblCollection Data].[Date of 1st Letter], [tblCollection Data].[Date of 2nd Letter], [tblCollection Data].[Date to Collections], [tblCollection Data].[Paid Amount], [tblCollection Data]. [Date of Payment], [tblCollection Data].[Type of Payment], [tblCollection Data].[Date to HR Finance], [tblCollection Data].[Comments], [tblCollection Data].[Social Security #] AS [tblCollection Data_Social Security #], [tblSON Default Interest].[Sent to Tax Dept] FROM ([tblIdentification Data] INNER JOIN [tblCollection Data] ON [tblIdentification Data].[Social Security #]= [tblCollection Data].[Social Security #]) INNER JOIN [tblSON Default Interest] ON [tblCollection Data].[Social Security #]=[tblSON Default Interest].[Social Security #]; -----Original Message----- Hey Heather - Please post the recordsource of the form. If it's not the Data Entry property, then probably the recordsource of the form has some criteria that is excluding all records. - Anne -----Original Message----- Any other suggestions? The Data Entry property was already set to "No" -----Original Message----- 1. Open your form in design view. 2. Open the Properties box (View menu). 3. Set the Data Entry property to No (Data tab). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Heather" wrote in message . .. I am using Access 2000. I have three tables and one form. I can enter multiple records in the form and use the record selector to scroll among the new records. But if I close the form and then reopen the form, all of my records are gone. I am back to 1 of 1. The information remains in the tables, but I can no longer see it in form view. How can I view old records and new records in form view? I will be forever grateful if someone can solve this simple problem. -Heather . . . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form view vs Design View | Matt_Worland | Using Forms | 5 | July 21st, 2004 03:29 PM |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
Select various records (contiguous) in a form in datasheet view | Carlos | General Discussion | 1 | July 15th, 2004 01:00 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
Passing value to modal child form in MS Access using VBA? | Grahammer | Using Forms | 6 | July 4th, 2004 11:53 PM |