Results 1 to 10 of 10
  1. #1
    ejohnso4 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    7

    My form saves the data into the table, but once saved I can't see it in form view??

    I have created a form that allows me to input new records. These records are being transferred to my tables correctly. However, when I exit the form, I can no longer view those records in form view. I checked, and there is no filter on my form that I know of. What is going on??

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you have the DataEntry property (on the Data tab) set to YES. This allows the form to *only* see new and as yet unsaved records. Once saved, the form will no longer display that record.

  3. #3
    ejohnso4 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    7
    I checked and my Dataentry tab is set to "No". My original data was imported from excel directly into my tables. I am able to view this original data in form view. I just can't view my new record entries in form view. For instance, in all of my tables I have 381 records, 366 of which were transferred from excel. In my forms, its only displaying those original 366 for some reason.

    I would greatly appreciate any tips to fix this issue!

    Thanks

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Then maybe you are using a selective query as the RecordSource of your form or maybe your form has a filter defined.

  5. #5
    ejohnso4 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    7
    If I am using a select query as the record source of my form, how do I fix it. Do I have to start all over?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There is nothing wrong with using a SELECT query as the RecordSource of a form. It is just that if there is any selection criteria in the query then you could be eliminating the return of some records. What is the SQL of your RecordSource?

  7. #7
    ejohnso4 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    7
    Just to preface you, my form is pretty lengthy. Here is the SQL

    SELECT [Patient info].*, [Past Medical History].[Patient ID] AS [Patient ID_Past Medical History], [Past Medical History].Hypertension, [Past Medical History].AIDS, [Past Medical History].[Myocardial Infarction], [Past Medical History].[Congestive Heart Failure], [Past Medical History].[Chronic Pulmonary Dz], [Past Medical History].[Connective Tissue Dz], [Past Medical History].[Ulcer Dz], [Past Medical History].Dementia, [Past Medical History].Hemiplegia, [Past Medical History].Leukemia, [Past Medical History].[Malignant Lymphoma], [Past Medical History].[Peripheral Vascular Dz], [Past Medical History].[Cerebrovascular Dz], [Past Medical History].[Liver Dz], [Past Medical History].[Renal Dz], [Past Medical History].[Diabetes Mellitus], [Past Medical History].[Malignant Solid Tumor], [Past Medical History].Other, [Past Medical History].[History From Excel], [Past Medical History].[Meditech Reviewed (Hx)], [Past Medical History].[Office Chart Reviewed (Hx)], [Past Medical History].[Additional Notes (Hx)], Radiology.[Patient ID] AS [Patient ID_Radiology], Radiology.[Imaging Method], Radiology.[Date of Radiology], Radiology.[Largest Dimension (cm) = Radius], Radiology.[R: Radius Score], Radiology.[2nd Largest Dimension (cm)], Radiology.[Location Of tumor], Radiology.[E: Exophytic/ Endophytic], Radiology.[Nearness to Collecting System (mm)], Radiology.[N: Nearness Score], Radiology.[A: Anterior/ Posterior], Radiology.[L: Location (relative to polar lines)], Radiology.Hilar, Radiology.Hydronephrosis, Radiology.Lymphadenopathy, Radiology.[Bosniak Classification (cysts only)], Radiology.[Preop MAG-3 Renal Scan (L/R)], Radiology.[Postop MAG-3 Renal Scan (L/R)], Radiology.[Preop Renal Biopsy], Radiology.[Radiology Note], Radiology.[Meditech Reviewed (Rad)], Radiology.[Office Chart Reviewed (Rad)], Radiology.[Additional Notes (Rad)], Nephrectomy.[Patient ID] AS [Patient ID_Nephrectomy], Nephrectomy.[Date of Surgery], Nephrectomy.[Age at Surgery], Nephrectomy.Approach, Nephrectomy.[Partial or Radical], Nephrectomy.[Right/Left/Bilateral], Nephrectomy.[Thermal Energy Applied to Tumor Base], Nephrectomy.[Hemostatic Agent], Nephrectomy.[Hemostatic Agent Free text], Nephrectomy.[Procedure Time (min)], Nephrectomy.[Ischemia Time (min)], Nephrectomy.[Warm or Cold Ischemia], Nephrectomy.[Early Unclapping], Nephrectomy.[Super selective Hilar Clamping], Nephrectomy.[Bulldogs or Satinsky Hilar Clamping], Nephrectomy.[Adrenal Sparing], Nephrectomy.[Lymph Node Dissection], Nephrectomy.[Intraop Ultrasound], Nephrectomy.[ASA Score], Nephrectomy.EBL, Nephrectomy.pRBC, Nephrectomy.Platelet, Nephrectomy.FFP, Nephrectomy.[Intraop complication], Nephrectomy.[SICU days], Nephrectomy.[Floor days], Nephrectomy.[Length of Stay], Nephrectomy.[Post-Op RBC Transfusions], Nephrectomy.[Reg Diet on Post-Op Day], Nephrectomy.Surgeon, Nephrectomy.[First Assist], Nephrectomy.[Operative Note], Nephrectomy.[Meditech Reviewed (Op Note)], Nephrectomy.[Office Chart Reviewed (Op Note)], Nephrectomy.[Additional Notes (Op Note)], Pathology.[Patient ID] AS [Patient ID_Pathology], Pathology.[Largest Dimension of Tumor (cm)], Pathology.[2nd Largest Dimension of Tumor (cm)], Pathology.[3rd largest dimension], Pathology.[Grade (Fuhrman Grade)], Pathology.Histology, Pathology.[T: Primary Tumor Stage], Pathology.[N: Nodes], Pathology.Margin, Pathology.[M: Metastasis], Pathology.[Site of Metastasis], Pathology.[Pathology Note], Pathology.[Meditech Reviewed (Path)], Pathology.[Office Chart Reviewed (Path)], Pathology.[Additional Notes (Path)], Followup.[Patient ID] AS [Patient ID_Followup], Followup.[Recurrence on CT], Followup.[Last known status], Followup.[Date of status], Followup.Chemo, Followup.[Type of chemo], Followup.[Subsequent Surgery], Followup.[Followup Details], Followup.[Meditech Reviewed (FU)], Followup.[Office Chart Reviewed (FU)], Followup.[Additional Notes (FU)], [Contact Info].[Street Address], [Contact Info].[City, State, Zip], [Contact Info].[Patient ID] AS [Patient ID_Contact Info], [Contact Info].[Phone 1], Nephrectomy.[Conversion Surgery], [Contact Info].[Phone 2]
    FROM ((((([Patient info] INNER JOIN [Past Medical History] ON [Patient info].[Patient ID] = [Past Medical History].[Patient ID]) INNER JOIN Radiology ON [Patient info].[Patient ID] = Radiology.[Patient ID]) INNER JOIN Nephrectomy ON [Patient info].[Patient ID] = Nephrectomy.[Patient ID]) INNER JOIN Pathology ON [Patient info].[Patient ID] = Pathology.[Patient ID]) INNER JOIN Followup ON [Patient info].[Patient ID] = Followup.[Patient ID]) INNER JOIN [Contact Info] ON [Patient info].[Patient ID] = [Contact Info].[Patient ID];

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you really need all of those fields for this form? At any rate you have a a bunch of INNER JOINs that can eliminate records if there is no match.

  9. #9
    ejohnso4 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    7
    I figured out what it was. I had an inner join between two of the tables in my select query, but one of the tables did not have entries inputed for the new records.

    Thanks for your help!

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Glad we could help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can access have a table view inside a form
    By mossman in forum Access
    Replies: 5
    Last Post: 01-17-2010, 12:19 PM
  2. Entire form not shown in form view
    By ksmall1998 in forum Forms
    Replies: 12
    Last Post: 09-22-2009, 06:38 AM
  3. form data will not populate in table
    By bobsakamato in forum Access
    Replies: 1
    Last Post: 09-06-2009, 07:25 AM
  4. Form data not populating in table
    By sabrown in forum Forms
    Replies: 0
    Last Post: 08-27-2009, 08:19 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums