Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
  1. #31
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51
    When I try to run this code I get an error message box that says:
    Compile error:
    Expected: end of statement

    What am I missing?

  2. #32
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Sometimes when I cut and paste, the forum eats my carriage returns.

    In my code, there is a line like this
    Code:
    Public Sub CreateSSWPDUnion()On Error GoTo Err_CreateSSWPDUnion
    put a return after the () like this
    Code:
    Public Sub CreateSSWPDUnion()
    
    On Error GoTo Err_CreateSSWPDUnion

  3. #33
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51
    Oh man, what a difference a simple CR makes. The code works exactly as I had hoped. You're incredible, thank you.
    In an earlier post there was mention of a 15 minute run time. Is the code module to run this code very complicated?

  4. #34
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    You would only need to run this code to regenerate the query SQL whenever a new table is created. If you wanted to, you could set up ways to run the regen automatically, either the first time anyone logs on in a day, or on command, or every hour, or whatever. For example, using the timer on a hidden form for one - and ONLY ONE - user.

    Please mark this thread solved (top of page, under Thread tools), then start a new thread asking about how to run a query on a schedule... there are lots of ways so that's likely to be a long discussion.

  5. #35
    rmoreno is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2013
    Posts
    51
    Thanks again for helping me with this issue.

    This problem is SOLVED

  6. #36
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    You're quite welcome.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-23-2012, 12:46 PM
  2. Capture data from TCP port
    By todster in forum Access
    Replies: 0
    Last Post: 07-19-2011, 12:22 AM
  3. Capture Form Data to Export to Excel
    By ajones92 in forum Forms
    Replies: 8
    Last Post: 06-16-2011, 03:35 PM
  4. Replies: 2
    Last Post: 01-31-2011, 08:31 AM
  5. Select Data from SQL into an Access table
    By MichaelC in forum Programming
    Replies: 4
    Last Post: 07-28-2010, 04:10 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