Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Question Unanswered: Auto Fill Search Field

    Is this the correct SQL syntax for auto populating 4 rows in a .ACCDB 2007 field? When testing, it auto populates for a couple seconds, then Access freezes.

    I'm modifying the original SQL in the Property Sheet -> Row Source that auto populates 3 columns (Last Name, First Name, Birthday):

    Code:
    SELECT [dbo_Person].[idPerson], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
    FROM dbo_Person
    ORDER BY [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
    To this in trying to add a 4th column that's just an ID number in the first column:
    Code:
    SELECT [dbo_TestData].[TestNum], [dbo_Person].[idPerson], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
    FROM dbo_TestData, dbo_Person
    ORDER BY [dbo_TestData].[TestNum], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
    [TestNum] will populate, but then after about 2 seconds it will freeze Access and not respond.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    There's no JOIN in your sql statement to tie those two tables together.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Sep 2011
    Posts
    2

    Re:

    Quote Originally Posted by blindman View Post
    There's no JOIN in your sql statement to tie those two tables together.
    How would I add the Join statement to it?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Look up "JOIN" in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Sep 2011
    Posts
    71

    Thumbs up Try Join Example to using at your query

    Try this query in your script after change names of coures

    SELECT UrlCheck.ChangeStatus, UrlCheck.Date, WebSite.Title, WebSite.URL
    FROM UrlCheck INNER JOIN
    WebSite ON UrlCheck.ID = WebSite.URLID
    Last edited by paultech; 09-29-11 at 11:45. Reason: repair sql query

  6. #6
    Join Date
    Sep 2011
    Posts
    75

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •