Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2021
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,739

    davegri, doesn't quite explain why variable would have correct value in Debug but then following line showed it was empty.
    Well, when strange things appear to be happening, my thought was to try the search to rule out some possibility of duplicating names.
    If names are duplicated, who know which the debug.print might be looking at?

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Quote Originally Posted by kdleaver1974 View Post
    Can't explain why, but when I change the Variable name from "FLAG" to "FLG" it works fine. Can't find a reason why such a change worked, but it did. I came up with the idea after doing various "tests" to see what was happening, and the fact when I used various different variable names, everything worked (I did a Replace all variables in entire Project).

    Thanks for the help anyways, and sorry for taking up everyone's time.

    Ken L
    Well Flag does not appear to be a reserved word, so no ide as to why that worked.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Welsh, the actual variable was FLAGShippingCost - "FLAG" was my shorthand.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #19
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Quote Originally Posted by June7 View Post
    Welsh, the actual variable was FLAGShippingCost - "FLAG" was my shorthand.
    I was just going on what the O/P stated.

    Without a DB to see, we will all be guessing.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 8
    Last Post: 01-27-2023, 07:01 AM
  2. Variable Remains Empty
    By dccjr3927 in forum Programming
    Replies: 5
    Last Post: 03-28-2019, 02:50 PM
  3. Replies: 1
    Last Post: 01-24-2019, 12:58 AM
  4. Replies: 17
    Last Post: 08-22-2017, 08:43 PM
  5. Replies: 4
    Last Post: 01-22-2015, 10:30 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