Skip to main content
47 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
2 answers
61 views

I am seeking to create a multi criteria DLookup for my DB and have not had much luck. I have a db, has 1 form with 3 sub forms sort of like a cascading combo. Lets say I put "Test" in first ...
david pierce's user avatar
  • 1
0 votes
1 answer
60 views

When there is data with the same CustomerID, the button is bold, otherwise it is not. This is my error when we click to add a new Customer. Run-time error ‘3075’: Syntax error (missing operator) in ...
dulster's user avatar
  • 1
0 votes
1 answer
311 views

I appreciate some help I am trying to use Dcount function with 4 criteria I have a text box in a form to count records on table_orders The DCount function has 4 criteria: The ID field in table_orders ...
Emanuel's user avatar
  • 41
0 votes
1 answer
289 views

Getting the following error.... <The expression you entered as a query parameter produced this error: 'rs!StoreID'> rs!StoreID is an integer in the Stores table and prints out just fine in the ...
MikeWojcik's user avatar
  • 15
2 votes
0 answers
335 views

Really struggling to get my reference to register in the search? I'm trying to create a check to see if the record is already in my table? Private Sub Command10_Click() Me.UniqCONCAT = (Me....
Ellis Ellis's user avatar
  • 33
0 votes
1 answer
477 views

I'm trying to create a number of reports in Access 2016. One report is a simple message box that will display the number of records in a specific table ("tbl_Data") WHERE the "...
Shaves's user avatar
  • 940
0 votes
1 answer
597 views

I have been having much trouble with this problem. I have a table in Access called "Import" that I import records to. Each record has a facility name that corresponds to a "region" ...
Christopher Magro's user avatar
  • 1
0 votes
1 answer
184 views

I'm using Dcount on a query column to get how many 1 from another table. I have given the current query column value in the parameter of Dcount as below. DCount("AttnStatus","...
Abzal Ali's user avatar
  • 189
0 votes
0 answers
43 views

I want to add a text after Dcount formula in Ms Access Form. I use the unbound text field to use the DCount formula however I would like to add 'text' within the same field after Dcount formula ...
Yasir Abbas's user avatar
  • 1
0 votes
1 answer
302 views

I am using Access 2016. I am using dcount in my query however I am getting this error "undefined function dcount in expression". Any idea how can I fix this issue? here is my syntax SELECT ...
Samuel Magharious's user avatar
  • 11
0 votes
0 answers
188 views

I've seen a number of post about not opening a query if the query is blank but not sure where to have the code to check the output of the query. Before the query is run i have a number of conditions, ...
hIlary's user avatar
  • 85
0 votes
1 answer
46 views

Hi I've searched the net and couldn't find the right answer to my question. I have two tables GCSALLDATA and GCS-RECONCILED. They both have the same columns but I only need to focus on two [Control ...
mightymax's user avatar
  • 431
0 votes
2 answers
669 views

I'm trying to display the Vendor Name and a message that a selected PO Number (from a combo box on the form) does not require QA in a message box. The DLookup to get the vendor number from the PO ...
Newbie's user avatar
  • 55
1 vote
1 answer
293 views

I have an Access Form with two combo boxes, PO Number and Vendor Number. The Vendor Number will automatically filter to show only those who match the chosen PO Number (PO Numbers are sadly not unique; ...
Newbie's user avatar
  • 55
1 vote
1 answer
48 views

I have a table named [Mailbox Status] listing all email mailboxes that are to be migrated to O365. Mailboxes are migrated in batches (column BatchNumber) and when they are migrated, the column ...
Tom Zvolensky's user avatar
  • 71
0 votes
2 answers
2k views

I have created a userform that insert data into an Access table. while inserting data, I want to make sure that the ID inserted must exist in the Access table. I have used the DCOUNT function to do ...
Bruno Bukavu Thai's user avatar
  • 141
0 votes
2 answers
390 views

Objective: I'm building VBA code to filter through an address table SunstarAccountsInWebir_SarahTest. I want to loop through first and see if the address is "valid". If it is not valid – export to ...
rgorowsky's user avatar
  • 125
0 votes
1 answer
139 views

I'm getting the 462 runtime error when updating an Access table from Excel VBA. I think the references are correctly qualified with the object variable as described here and here, but I'm still ...
MBB70's user avatar
  • 367
-1 votes
1 answer
41 views

I am fairly new to Microsoft Access but I recently created a database to better organize our department data. In my database I have a table that our staff can log their interactions with patients. A ...
Mark Kalina's user avatar
  • 1
1 vote
1 answer
33 views

I have recently created a report that shows the number of rows from my table for different yes/no attributes. Now, I would like to add another box that will show the average of these two look ups, as ...
Matt H's user avatar
  • 147
0 votes
2 answers
121 views

I want to count the call number, Datecall, [Username] is the name of fields of table BCKHDY but why numbercall always equal 0. If I delete AND DateCall= #" & DateFrom & "#, code run, that ...
Luu nguyen's user avatar
  • 157
0 votes
2 answers
1k views

I am attempting to use the DCount() Function to return a count from my table. My issue is that it always returns a NULL value. How should I Re-write this VBA statement so that it returns the ...
IcyPopTarts's user avatar
  • 504
2 votes
1 answer
2k views

First off I am a bit of a novice when its comes to VBA, so everything I do is a bit of hit and miss but normally I eventually figure out the problem. However this time I have been stuck for days and ...
CLS's user avatar
  • 21
0 votes
1 answer
283 views

I want to have a form / database that the data goes into automatically search for duplicate entries. Duplicates can either be by reference number (which contains numbers an a letter) or by name. I ...
user97804's user avatar
  • 13
0 votes
0 answers
444 views

I don´t know whats wrong with this query... I want to know how many records are on another query named: Querie_Planilla that have the following characteristics: The date on the field PeriodoInicial ...
Lio's user avatar
  • 3
1 vote
1 answer
310 views

I am not getting the correct value for DCount Table is "Lessons": ID (auto) pk InstructorID As Integer Weekof As Date StudentID As Integer Status As Byte My function is Public ...
user2978241's user avatar
  • 421
0 votes
1 answer
357 views

I want to use the DCount function in my Visual Studio Project but DCount gets underlined with a squiggly line and the tooltip says "Not declared" What is the solution?
Chandrasekharan K's user avatar
  • 11
1 vote
1 answer
673 views

I want to go through the records in a table to see how many already contain the Julian date of today. I want it to be a wildcard search because my project numbers will be in this format "16-2101". The ...
Mekenzie Buhr's user avatar
  • 39
2 votes
2 answers
752 views

I have 2 tables in a 1-many relationship: Person - Application Every time a person meets criteria, a new record is created in Application, and today’s date is added to field App_OutAwardDate. I ...
Red's user avatar
  • 21
0 votes
1 answer
297 views

I have a calculated column "TimeAfterClass" which uses DateDiff to calculate the number of days between the start of class attendance to an audit date. This works fine. Many of the results have the ...
Pam Leonard's user avatar
  • 59
0 votes
1 answer
161 views

I'm working on building a report and am trying to get the right count of records using the DCOUNT function. I'm in a pickle trying to adjust the CRITERIA part of it, so that it would pull the ...
FatBoySlim7's user avatar
  • 232
0 votes
2 answers
122 views

In the BeforeUpdate event on my field, I have a dcount set up to disallow duplicates in the field SurveyID. This works great, except in the event that, in a past record, the user starts editing their ...
eee333's user avatar
  • 51
0 votes
3 answers
574 views

Trying to get a count of all records from a table called "ComplaintsListMaster" that have a "ComplaintDate" greater than 11/1/2015. The correct value is around 70. But when I use the dcount pasted ...
SQLSuperHero's user avatar
  • 618
1 vote
1 answer
118 views

I'm building a rather complex database for my limited (yet slowly growing) knowledge of database and programming. So, I really appreciate your help. The database keeps track of customers, buildings, ...
Shawn Gadwa's user avatar
  • 11
0 votes
1 answer
374 views

I am doing a dcount in a form through a textbox. I just need it to add the reasons in the table filtered through the reason type and clientid from the open form. The form is open and the dcount counts ...
DotyDot's user avatar
  • 135
4 votes
1 answer
5k views

I know that you should not store calculated values in a database but in this case the structure is given and I have to deal with that. I have two tables: Table1 with the fields (i.e. customer, ...
Thorsten's user avatar
  • 43
1 vote
1 answer
966 views

I am trying to get an Access report to identify if a text field (NH) does not match with the same ID. For example, ID 179 has two rows but each NH is different (12345 & 12346). I am trying to use ...
Reuben Ellis's user avatar
  • 15
0 votes
1 answer
359 views

I'm having a problem with DCount in VBA. I'm trying to fill an array with values calculated by Dcount. One of the criteria I use in the Dcount I want to get from a different array, this gives the ...
Douwe's user avatar
  • 23
0 votes
1 answer
75 views

on click(), I am having problem or wording in the following: Private Sub Cmd_Create_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim rs_conterparty As DAO.Recordset Dim rsCount As Integer ...
CHARUEL Damien's user avatar
  • 11
1 vote
2 answers
2k views

I have problems with the wording of the criteria of a DCount function. On click() I would like to have the number of occurrences of the field "YearMonth" in a tale in accordance with the value ...
CHARUEL Damien's user avatar
  • 11
1 vote
1 answer
486 views

I am using a DCOUNT function to look at a table in access and see if a record exists - if it does then return a yes value. =IIf(DCount("*","COMMENTS","[PROJECTID] = " & [PROJECTID])>0,"YES","")...
Ethan V's user avatar
  • 51
0 votes
2 answers
37 views

I have a large Excel dump from SQL with many columns of data. Two of those columns have different fields with various text values. There are six correct values for the first column and five correct ...
Craig's user avatar
  • 33
0 votes
1 answer
102 views

Thanks for your attention: I have an ultra-marathon scenario with multiple contestants each competing in multiple events (i.e. swim, cycle, run). I need a little help on the formula to only count ...
Stuart's user avatar
  • 1
1 vote
1 answer
2k views

Access complains "Data Type Mismatch in criteria expression" with this code ... If DCount("[Serial Number]", "INVENTORY OVERVIEW", "[Serial Number] =" & Val(txtSERIAL)) > 1 Then Serial Number ...
Adam Bowsey's user avatar
  • 11
2 votes
2 answers
332 views

I have two commands in Microsoft Access 2010 that works fine individually: =DCount("*","Order","DATE = #" & [Forms]![formOrder]![DATE] & "#") =DCount("*","Order", "STATUS = 'ST." & [...
Arjun's user avatar
  • 25
1 vote
2 answers
1k views

I tried hard but couldn't found out why the formula in cell S10 below returns value 0 instead of 1, could you explain?
alwbtc's user avatar
  • 29.8k
0 votes
1 answer
2k views

How to use DCOUNT on select- sql query while using group by? I have a problem and first, I want to show part of the real table ![I WANT a query that show me per date the amount of bl_no in ...
Liran Kremer's user avatar
  • 51