Results 1 to 4 of 4
  1. #1
    igourine is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    4

    Test String test besed on table data

    Dear All,


    i need urgent help, i have field in form & based on the data i will put in the form i need vba to check if this data is within the range see attached sample
    Attached Thumbnails Attached Thumbnails New Picture (1).jpg   New Picture2.jpg  

  2. #2
    AlexHedley's Avatar
    AlexHedley is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    England
    Posts
    180

    Test String test besed on table data

    You could try the InStr function.

    http://office.microsoft.com/en-gb/ac...001228857.aspx

  3. #3
    igourine is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    4
    Dear Alex,
    thanks for your reply but i need the following:
    check type of material in table if Yes/no then
    chack welding progress in table yes/No
    check the wtpipedaimeter in table if is greater the dia in table
    the check if thik is within the range of Thik Min & max in table
    all these has to be in 1 vba code

    sorry but that is the requirement i hope you can help me in this issue

  4. #4
    AlexHedley's Avatar
    AlexHedley is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    England
    Posts
    180

    Test String test besed on table data


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-03-2013, 01:35 PM
  2. Query To Pareto Test Results Data
    By rmoreno in forum Queries
    Replies: 1
    Last Post: 06-06-2013, 02:58 PM
  3. How to test of record exists in table?
    By tdaccess in forum Access
    Replies: 3
    Last Post: 04-13-2011, 10:22 AM
  4. Test data for queries
    By nacho in forum Queries
    Replies: 6
    Last Post: 04-16-2010, 11:01 PM
  5. Keying in Test answers to Access DB from Written Test
    By CityOfKalamazoo in forum Access
    Replies: 3
    Last Post: 03-01-2010, 08:58 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