Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    luckydead is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2020
    Posts
    25
    You are right here, cint was important part
    Code:
    If DCount("*", place, "[select] = Cint(" & inputData & ") And IsNull([ver1_2])=True") > 0 Then
    make the difference between result is 0 or 1

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,574
    No!, If you type the correct syntax it will work. You are changing the code without any clue as to what each piece is meant to do?
    Look at the links that Gicu has posted and see if you can see where you are going wrong.

    One technique I use is to put the criteria into a string variable, debug.print that until I get it correct, then just use that in the function?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Disk space requirements of additional fields vs additional records
    By pharmacologist in forum Database Design
    Replies: 2
    Last Post: 03-17-2021, 09:23 PM
  2. dcount criteria
    By markjkubicki in forum Programming
    Replies: 2
    Last Post: 11-26-2018, 03:01 PM
  3. close form button with additional criteria
    By woodpecker in forum Access
    Replies: 5
    Last Post: 10-21-2017, 02:31 PM
  4. Inner join with additional criteria
    By cwillson in forum Queries
    Replies: 8
    Last Post: 09-13-2017, 01:00 AM
  5. RC Notation and additional criteria
    By mkc80 in forum Access
    Replies: 3
    Last Post: 11-05-2012, 03:30 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