+ Reply to Thread
Results 1 to 2 of 2

Access - check a values in a table

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Access - check a values in a table

    Hi everyone.

    I would like to ask you for a tip how to solve following problem:

    1) I have a table named 'Insuarance'. There are a few columns but one I am interested with is the Column: Month
    2) I have a form based on that table called 'Add a Insurance"

    What this form does is to add a new record into a table.

    However my problem is that I need to achieve following goals:

    1) The form shows me by default value with next month in the order from January to December
    2) The form checks if the record with a following month name does not already exists

    For example:

    I have in this table records from January to April so then be opening a new form it shows me by default May (in a combo box) and allows me to add a new record. But when I choose March for example in a combo box and try to add a new record then a message box appears "Month already added to a table"

    Can I achive this in Access?

    Thank you in advance for any tips.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,803

    Re: Access - check a values in a table

    Probably, but without seeing the whole picture it is difficult to say. It will probably require you to tweak either your Macro or VBA codes (they are different in Access). You will need to see what is happening behind the curtain.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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: 1
    Last Post: 12-02-2014, 05:46 AM
  2. Check if the value in textbox is present in Access table using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-16-2014, 09:42 AM
  3. Check if column D value is present in Access table Ref Field VBA
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 06:01 AM
  4. Replies: 2
    Last Post: 09-03-2014, 03:37 AM
  5. Check access database table as part of if statement
    By greenlemon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2013, 10:24 AM
  6. Replies: 3
    Last Post: 08-24-2005, 04:05 PM
  7. How can I use VBA ADO to check if a table exists in an Access DB?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2005, 02:52 PM

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