+ Reply to Thread
Results 1 to 2 of 2

Check if column D value is present in Access table Ref Field VBA

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    880

    Check if column D value is present in Access table Ref Field VBA

    Hi All

    I am designing a project in which there is a form and on that form there is a textbox and Browse button. With browse button you can select a file from the dialog box and that file path will appear in the textbox. This part has been done as below:

    Please Login or Register  to view this content.
    Now the next Part i.e Part2 in which we have to see the references present in Column D of the "Summary" worksheet of the workbook whose path is present in textbox1 and check if they match with any of the references in field "Ref" of the Access table named tblLiterature.
    If value in column D matches with Ref field of the Access table then change the status field of the Access table to the corresponding columns A,B,C named as "Withdrawn","Obsolete","Updated". that means if the column A of the corresponding Reference is Y then change the status field to "Withdrawn". If column B is Y then change the status to "Obsolete" and if column C is Y then change the status to "Updated".

    Please see attached the workbook as this kind of workbook will be searched against Access table .

    Any questions please let me know.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    880

    Re: Check if column D value is present in Access table Ref Field VBA

    With browse button we can select a file from the dialog box and that file path appears in the textbox. SO now how can I perform the following steps using excel VBA:

    1. To copy columns A,B,C,D from Row 8 onwards into Access table named tblmain.
    The tblmain has fields: Withdrawn,Obsolete,Updated,Reference.

    2. Writing excel VBA code to see if the reference present in tblmain matches with reference present in tblLiterature. If yes then change the Status field to either "withdrawn","Obsolete" or "Updated" .

    please see attached the sample excel workbook . Everytime we need to copy data from Summary worksheet of the excel workbook path present in textbox1.
    Thanks

+ 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. Replies: 2
    Last Post: 09-03-2014, 03:37 AM
  2. [SOLVED] Referring to a Sub-Field on Calculated Field Pivot Table Column?
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-27-2014, 02:02 PM
  3. How to present 'text' as a column in a Pivot table?
    By rakk1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-20-2012, 04:28 AM
  4. Calculate no of days due in Access Table Field.
    By ebin charles in forum Access Tables & Databases
    Replies: 3
    Last Post: 11-01-2011, 12:27 PM
  5. How to check a value in a column present in another column
    By naveenarora23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2008, 10:20 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