Results 1 to 4 of 4
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    A most unusual query

    In the db file attached, the record source for frmPersonnel is .... what?

    I did not write this part of the db so I do not take any responsibility for this.

    The record source reads:

    SELECT qryPersonnel.* FROM qryPersonnel;

    That is nothing that I have ever seen before. It obviously is a query. From well, I do not know.

    That is the purpose of the question posed here.

    Any help appreciated. Thanks in advance.

    Respectfully,



    Lou Reed
    Attached Files Attached Files

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    That is peculiar. You can use SQL code in the Record Source, but what the SQL code you posted essentially says is "select everything from qryPersonnel". There is no calculations or criteria in that query.
    So it seems utterly unnecessary. You could just select the "qryPersonnel" object to the Record Source without all the SQL code, which changes nothing in this case.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I know, I am confused. What is going on here?

    Respectfully,

    Lou Reed

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you are asking me to try to determine what the original programmer was thinking, I have no idea. Your guess is as good as mine.
    I see no reason to do what they did.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-01-2017, 03:11 PM
  2. An unusual(?) parent-child form
    By bnorton in forum Access
    Replies: 10
    Last Post: 08-19-2014, 04:55 PM
  3. Unusual string
    By Yap in forum Access
    Replies: 6
    Last Post: 12-13-2012, 08:35 PM
  4. Importing Text - Unusual delimiters
    By Jackfam58 in forum Programming
    Replies: 4
    Last Post: 08-07-2012, 06:33 PM
  5. Percent textbox unusual behaviour
    By Deutz in forum Forms
    Replies: 4
    Last Post: 06-05-2011, 06:46 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