User Profile

Collapse

Profile Sidebar

Collapse
Xanfere
Xanfere
Last Activity: Dec 4 '08, 05:12 PM
Joined: Dec 3 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Xanfere
    replied to Global Variables Reset on Error
    in Access
    I did a workaround...

    Upon successfully logging into the app, I write the values to a text file (in the same folder as the .adp file). Then, if any of these values are blank when I access it, I just read in the values from the text file and refresh the custom properties.

    So far, it seems to work fine...
    See more | Go to post

      Leave a comment:

    • Xanfere
      started a topic Global Variables Reset on Error
      in Access

      Global Variables Reset on Error

      Hello All,

      I have an issue with an Access 2003 ADP file hooking up to SQL Server 2005.

      I had a global variable in a module like the following:

      Public loginUserName As String

      I found out that upon errors, the value for this variable gets reset. So, after some initial online research, I changed this variable to a property in a code module:

      Public Property Let UserID(strUID As...
      See more | Go to post
      No activity results to display
      Show More
      Working...