+ Reply to Thread
Results 1 to 2 of 2

Check the value in Textbox and value in cell of excel file - If matches

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Exclamation Check the value in Textbox and value in cell of excel file - If matches

    Hi, Iam a new bee to this MS access.
    what i am trying to achieve is
    a) I have created a Form, Name is "Martina". With a Text box having Date eg., 28/06/2015.
    b) I have a excel file in which specific cell has the Date, say date is 29/06/2015.

    what i want is to compare the date in Text box in a form with the date in specific cell in excel file.
    If the date matches, msgbox should say "Match" if not msgbox should say "No match".

    please help.
    Last edited by prabhuduraraj09; 06-22-2015 at 03:05 AM. Reason: not specific

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Check the value in Textbox and value in cell of excel file - If matches

    first you have to link that excel file with access and then use query to get the date
    and then you can compare with text box date.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create events in Outlook Calender from Excel without duplicates
    By Southernw2002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2014, 02:23 PM
  2. Replies: 8
    Last Post: 01-28-2014, 11:02 AM
  3. Replies: 2
    Last Post: 06-26-2012, 02:20 PM
  4. How to create a calender picker on the form
    By shirley_kee in forum Excel General
    Replies: 1
    Last Post: 06-23-2006, 08:00 AM
  5. date Calender user form
    By sam1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2006, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1