Results 1 to 5 of 5
  1. #1
    gzgzgz is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2

    Post Code to read a Yes/No table and perform an if statement if yes

    I need help with the code to call on a Yes/No table and to read the table. First shot at it and I keep getting an object required error. Any help with be much appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    zero information provided, so zero solution provided.

    what are you actually trying to achieve?
    what is a 'yes/no' table?
    what code do you have at the moment?

  3. #3
    gzgzgz is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    2
    I have an Access "Yes/No" table and I'm trying to write a code that when a report (column on table) is checked and if statement runs to export the report. i pretty much only have the IF statements written and need help with a way to initialize the table and the code.

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    A lot of questions here.
    I have an Access "Yes/No" table
    Show us the table design. Why do you call it a Yes/NO table?
    I'm trying to write a code that when a report (column on table) is checked
    Checked where? On a form? Do you have a form? Does the table list a variety of reports?
    if statement runs to export the report.
    Do you mean Open the report? If not, where is the report exported to?
    have the IF statements written
    Would you like to show us the code?
    need help with a way to initialize the table and the code
    Can you explain how you want the table to change, via the Initialize?

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    What is the data base about? What "business" does it support?
    Inventory, Finance, Reservations, Document Management, Sales, Education...... any hint
    in plain English would be helpful.
    Remember, we don't know you, your environment, your background, your business etc
    so a Yes/No database is whatever you dream it to be. Readers are great guessers, but
    not clairvoyant.
    Welcome and good luck with your project.

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

Similar Threads

  1. Perform a Union All Query For Two Columns in the Same Table
    By DigitalAdrenaline in forum Queries
    Replies: 14
    Last Post: 08-19-2018, 05:39 PM
  2. Replies: 12
    Last Post: 02-21-2017, 08:33 PM
  3. If statement to read from table
    By ekulrenlig in forum Macros
    Replies: 4
    Last Post: 09-19-2015, 08:21 PM
  4. How to Perform a DLookUp for something Not in table
    By nick404 in forum Programming
    Replies: 7
    Last Post: 07-09-2015, 12:31 PM
  5. Replies: 6
    Last Post: 11-21-2014, 05:35 PM

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