Results 1 to 8 of 8
  1. #1
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58

    New Version of Invisible Controls In Form View/DE "No" Prop Issue

    Yet again, buggy, frustrating, confounding Microsoft has managed to make a horrifyingly simple task inspire me to throw my PC out the window and shortly follow it. Consider this new gem:



    I'm not getting existing table records showing up in Form View.

    a) There's records in the table.
    b) The form's Record Source currently contains one-to-one textbox controls from one table. The only control not sourced to that table is not currently sourced to ANYTHING.
    c) The Form "Data Entry" property is set to "No"; the "Recordset Type" is "Dynaset (Inconsistent Updates)"...for flexibility; the "Allow Additions" property is set to "Yes".
    d) The Form Detail "Visible" property is set to "Yes".

    Given those, why in the world would I not be seeing the 14 records in the source table, especially with the "Data Entry" property set to "No"?!

    Confounding Mr. Gates. Confounding.

    Mucho thanks ahead of time for advice on this normally/supposedly easy, yet persistent fix.

    Frank
    Windows XP, Access 2007, .accdb file

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    What do you see when you open the Property Sheet for the Form, click the 'Data' tab, and then look in 'Record Source'?

    Can you post a copy of your db here? You can remove sensitive data before posting your db here.

  3. #3
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58
    The form's Record Source is a SELECT/FROM/INNER JOIN/ON SQL statement. De-sensitized, it's:

    SELECT [A1S1 Onboarding Tracking Table].ID, [A1S1 Onboarding Tracking Table].[First Name], [A1S1 Onboarding Tracking Table].[Known As], [A1S1 Onboarding Tracking Table].MI, [A1S1 Onboarding Tracking Table].[Last Name], [A1S1 Onboarding Tracking Table].Title, [A1S1 Onboarding Tracking Table].[A1S1 Date], [A1S1 Onboarding Tracking Table].[A1S1 Date Outcome], [A1S1 Onboarding Tracking Table].[New or Txfr or Rehire], [A1S1 Onboarding Tracking Table].[If Transfer, from Where?], [A1S1 Onboarding Tracking Table].[External E-Mail], [A1S1 Onboarding Tracking Table].[Movie Code], [A1S1 Onboarding Tracking Table].[Start Date], [A1S1 Onboarding Tracking Table].[Corporate Orientation Date], [A1S1 Onboarding Tracking Table].[Work E-Mail], [A1S1 Onboarding Tracking Table].[A1S1 Date Second Try], [A1S1 Onboarding Tracking Table].[A1S1 Second Try Outcome], [A1S1 Onboarding Tracking Table].[A1S1 Date Third Try], [A1S1 Onboarding Tracking Table].[A1S1 Third Try Outcome], [A1S1 Onboarding Tracking Table].Recruiter, [A1S1 Onboarding Tracking Table].[HRBP 1], [A1S1 Onboarding Tracking Table].[HRBP 2], [A1S1 Onboarding Tracking Table].[Manager 1], [A1S1 Onboarding Tracking Table].[Manager 1 E-mail], [A1S1 Onboarding Tracking Table].[M1 Outlook Invite Sent], [A1S1 Onboarding Tracking Table].[Manager 2], [A1S1 Onboarding Tracking Table].[Manager 2 E-mail], [A1S1 Onboarding Tracking Table].[M2 Outlook Invite Sent], [A1S1 Onboarding Tracking Table].Notes, [A1S1 Onboarding Tracking Table].[Extra Control 1], [A1S1 Onboarding Tracking Table].[Extra Control 2], [A1S1 Onboarding Tracking Table].[Extra Control 3], [A1S1 Onboarding Tracking Table].[HR EOD Contact Name], [A1S1 Onboarding Tracking Table].[HR EOD Work Phone #], [A1S1 Onboarding Tracking Table].[HR EOD Contact E-Mail] FROM ([Unused Movie Code Table] INNER JOIN [A1S1 Onboarding Tracking Table] ON [Unused Movie Code Table].[Movie Code] = [A1S1 Onboarding Tracking Table].[Movie Code]) INNER JOIN [Used Movie Code Table] ON [Unused Movie Code Table].[Movie Code] = [Used Movie Code Table].[Movie Code];

  4. #4
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    slightly confused here. In the original post you state that the controls are linked to a table yet the forms record source is a query. Check the query make sure it's returning the 14 records you're expecting.

  5. #5
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I agree with Ray. Copy that SQL into a new query and see if you get any results.

    Unless there's a reason for that SQL in your post being the record source for the Form, you can always just change the record souce to the name of your Table.
    However, once you do that and save - you will lose the SQL - so make sure you figure out why the SQL is the record source for the Form before you make changes.

  6. #6
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58
    a) You guys just taught me that SELECT/FROM/INNERJOIN/ON SQL statements in a Record Source mean the source is a query. Thank you.

    b) I have no idea why the Record Source of my form is a query. Though, I did notice that when I clicked on the builder thing in the property {(...)} to look at the source, it went into query builder mode and not expression builder mode - even creatinga tab title with "[my form name] Query Builder" in it.

    c) I'm going to change the Record Source to the name of my table, but if I source the two unbound controls to a different table(s), will anything unexpected (Microsoft tm) happen?

    Thanks so much for the help -
    Last edited by Soule; 01-06-2012 at 03:53 PM. Reason: Clarity

  7. #7
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Your query is only returning fields from [A1S1 Onboarding Tracking Table] - but it is using the two other tables to limit what rows of data show on your form [with the current data in those three tables - it would appear from what you said that the query is not returning any rows of data].

    If you inherited the database from someone else, you might consider making a copy of the Form and then making your changes to the copy to see if everything is good.

    Then you can have the existing Form as a backup in case you ever realize that you need to go back to it.

    All the best!

  8. #8
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58
    Record source of form is query and I can appreciate that now.

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

Similar Threads

  1. "On Current" event and ActiveX controls
    By beru777 in forum Programming
    Replies: 7
    Last Post: 12-20-2011, 10:32 AM
  2. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  3. "Dirty"/Save issue
    By jgelpi16 in forum Programming
    Replies: 5
    Last Post: 04-27-2011, 02:05 PM
  4. Fields do not show in "Form View"
    By hawzmolly in forum Forms
    Replies: 4
    Last Post: 01-09-2010, 06:27 PM
  5. Bound controls "mis"behaving
    By DanW in forum Forms
    Replies: 3
    Last Post: 11-16-2009, 11:35 AM

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