Results 1 to 3 of 3

Thread: splash

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: splash

    this code updates a subform on a main form. DoCmd.OpenQuery followed by DoCmd.Close causes undesireable screen splash. how could i fix/avoid this problem?.

    For Each qdf In db.QueryDefs
    If qdf.Name = "qrymytable" Then
    objectexist = True
    End If
    Next qdf

    If (objectexist <> True) Then
    Set qdf = db.CreateQueryDef("qrymytable", strSQL)
    End If

    db.QueryDefs.Delete "qrymytable"
    Set qdf = db.CreateQueryDef("qrymytable", strSQL)
    'Open the query, built using the IN clause to set the criteria
    DoCmd.OpenQuery "qrymytable", acViewNormal

    DoCmd.Close acQuery, "qrymytable"

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Can you use the echo command? Like

    Code:
    docmd.echo false
    'run query
    'close query
    docmd.echo true
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make sure you have Echo On in error handling!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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