Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    REAbernathy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2012
    Posts
    46
    Pbaldy,

    Thanks for all of your assistance and I took your advice and did this

    'Send information to TempReport_Table
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "TrackingSystem3 Query"


    DoCmd.SetWarnings True

    Tell me what you think. Also if possible can i ask you a question about looping? I wont send you any information until you respond. And Again Thank You so much for all of your assistance.

  2. #17
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I think that's better than doing the SQL in code, which in your case didn't make sense. Also:

    http://www.baldyweb.com/SQLWarnings.htm

    You can certainly ask about looping.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #18
    REAbernathy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2012
    Posts
    46
    You must be the hardest working man on all forums.

  4. #19
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Nah, I just check in between projects. I enjoy helping people and I often learn something new.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #20
    REAbernathy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2012
    Posts
    46
    What reading material do you recommend so i can get up to speed with Access and VBA? I need to get up to speed quickly and i was wondering if you had any suggestions.

  6. #21
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Well, I went to the "school of hard knocks", so I learned mostly by beating my head against a problem until it gave in.

    Which probably explains the bald spots! I do have/like the "Access xxxx Developer's Handbook" where xxxx is a version. I'm sure there are current books that are good, but I haven't read one so I'm not really qualified to answer.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need VBA code for adding to Outlook calendar
    By geraldk in forum Programming
    Replies: 3
    Last Post: 08-24-2012, 08:38 AM
  2. Adding multiple SQL Statment to code
    By rlsublime in forum Programming
    Replies: 1
    Last Post: 06-20-2012, 01:22 PM
  3. Adding values to a combobox with code
    By jle0003 in forum Access
    Replies: 4
    Last Post: 05-23-2012, 02:15 PM
  4. Adding a field to a table with vba-code
    By Mgomp in forum Programming
    Replies: 4
    Last Post: 03-12-2012, 07:58 AM
  5. VBA code for adding records to a table
    By pwalter83 in forum Forms
    Replies: 3
    Last Post: 12-21-2011, 10:52 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