+ Reply to Thread
Results 1 to 4 of 4

Check access database table as part of if statement

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    17

    Check access database table as part of if statement

    Afternoon Folks!

    I've had a little problem in the office with some VBA.
    I've been trying to get information from staff listed in a database, now that was fairly simple (A userform posting data to an access database).

    Now the problem is I have hundreds of staff to get the required data from, I have a userform that opens when excel workbook is opened but I have staff having to see this userform every time they open to file when they have already listed their required data.

    I have a list of NT Usernames which does get listed as part of the information dumped into my access database when they hit submit. What I want to do able to do is have excel check the data table and verify that the specific user has or has not submitted data then either display the form or skip it.

    Can this be done?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Check access database table as part of if statement

    It might be easier to have a query in Access that returns either a list of users who have data or those that don't have data.

    Then you could import that query into Excel and check the user's name against it.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Check access database table as part of if statement

    Could be, Thanks for that!

    I've got it working now

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Check access database table as part of if statement

    Or you can query Access table with Excel. With Excel 2010 you can download free PowerPivot add-in. This is an awesome tool!
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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: 07-05-2013, 09:37 AM
  2. IF/THEN Statement in Access Database
    By mcranda in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-03-2012, 03:34 PM
  3. Get data from an access database table
    By GWB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2010, 02:41 PM
  4. [SOLVED] vlookup and Access Database Table
    By finster26 in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 06:20 PM
  5. Pivot Table against an Access Database
    By Richard in forum Excel General
    Replies: 1
    Last Post: 02-27-2005, 12:06 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