User Profile

Collapse

Profile Sidebar

Collapse
roycunderwood
roycunderwood
Last Activity: Mar 22 '08, 01:20 AM
Joined: Feb 26 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • roycunderwood
    replied to Tag Property
    in Access
    I understand. Thank you! I was using it to store the value of a field for Audit Trail.

    Sample code:
    sql="Me!pwcuser & Changed Employee & Me!FirstMI & Me!LastName & Payrate FROM & Me!payrate.Tag & TO & Me!payrate.Valu e"

    It was a NULL value that was causing the problem. I added code to update all fields of the form on current event to copy the field value to the Tag value...
    See more | Go to post

      Leave a comment:

    • roycunderwood
      started a topic Tag Property
      in Access

      Tag Property

      First off I wanted to Thank Everyone here for all your help!

      Second:

      How do I set the onclick Property Tag of a TextBox to = its Field.value? Example:

      Me!FirstMI.Tag = Me!FirstMI.Valu e?

      This Errors.
      See more | Go to post
      • roycunderwood
        replied to Program Deactivation
        in Access
        Well Thank you! That worked!
        See more | Go to post

          Leave a comment:

        • roycunderwood
          started a topic Program Deactivation
          in Access

          Program Deactivation

          Hi everyone, I have a need to deactivate a msaccess app after a certain date (table lookup field). How can I modify which startup form based on date?

          Thanks !
          See more | Go to post
          • roycunderwood
            started a topic Form Permissions
            in Access

            Form Permissions

            I have 3 forms. 1 form I need to be private only certain users can access this form. I have set permissions so admin has access, and users dont. But users can still open the form.

            Any suggestions?
            See more | Go to post
            • roycunderwood
              started a topic Strange SQL
              in Access

              Strange SQL

              I have a question. I have searched and have not found an answer.
              1 table.
              (client, jobdate, startime, endtime, employee, status)

              I have scheduled employees for 1 job so far and need to schedule employees to different jobs at other times but not if they are already scheduled at that time. I need an SQL to Search for available employees who are not scheduled at 'X' time where status=current.

              Any Ideas...
              See more | Go to post
              No activity results to display
              Show More
              Working...