User Profile

Collapse

Profile Sidebar

Collapse
arnold
arnold
Last Activity: Oct 25 '09, 07:38 AM
Joined: Apr 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • arnold
    replied to display user friendly message for date validation
    in Access
    Dear ajalwaysus ,
    Thanks and God bless you
    I am much obliged to you
    See more | Go to post

      Leave a comment:

    • arnold
      replied to display user friendly message for date validation
      in Access
      Thanks ajalwaysus for your hard effort.
      But I'm still having the same problem

      Remark : regarding your point whether my text box is bound field to a date field in my table the answer is yes
      See more | Go to post

        Leave a comment:

      • arnold
        started a topic display user friendly message for date validation
        in Access

        display user friendly message for date validation

        Dear friends,

        I am using the following code in the afterupdate event of my textbox:
        Code:
         If Not IsDate([MyTextBox]) Then
     MsgBox "Invalid date!"
Else
     'do nothing, date is OK
End If
        My problem is that if the user entered false date such as 15-15-2009
        The Ms Access error message is displayed "The value you entered is not valid for this field" instead...
        See more | Go to post
        Last edited by NeoPa; Oct 21 '09, 10:57 PM. Reason: Please use the [CODE] tags provided.
        • arnold
          replied to Data sheet view or continuous form view
          in Access
          Thanks nico5038 I really appreciate your kind reply...
          See more | Go to post

            Leave a comment:

          • arnold
            started a topic Data sheet view or continuous form view
            in Access

            Data sheet view or continuous form view

            Hi Friends,

            I wonder if any body has the solution for the following problem:
            My form view is datasheet view and I have unbound text box which is not related to any field but I need it in my form for some purpose. My form might consist of many rows or records. My problem is that when I put specific text in my unbound text box the same text is repeated in all other rows. Hence is there a way which allows me to enter a value in...
            See more | Go to post
            • arnold
              started a topic small Ms access problem
              in Access

              small Ms access problem

              Hi all,

              I have created a form which gives the user the ability to search for specific data. Number of records in my database exceed one million records therefore in some occasion the searching takes an approximately a long time. Hence I have decided to show a hint message to inform the user that searching is going on and he has to wait. So in this regard I have created a label which is invisible at the beginning when...
              See more | Go to post
              No activity results to display
              Show More
              Working...