Criteria in Access Project

Posted on 2004-10-11
Last Modified: 2010-05-18
I cannot suss out how to write the following criteria (which I used in .mdb) in an access project :


Sorry but I am a novice!
Question by:Prestigeres
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
LVL 11

Expert Comment

ID: 12276392
Need some more information. The example you gave is a perfectly reference in an adp. Are you attempting to use the field for query criteria? Are you referring to an open form?

Author Comment

ID: 12276797
As a query criteria... it displays "Data Type Error in expression" when I try to save it :(
LVL 11

Expert Comment

ID: 12277308
Could you please post your code? Thanks.
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.


Expert Comment

ID: 12279610
1. You need to have a form open when you run the query
2. You need to put the name of your form and the name of your field in place of the words FormName and FormFieldName. For example, if your form name is frmOrders and the field name is strItem, the following would be the criteria:

Hope this helps.


Author Comment

ID: 12285832
Nope its not having any of it - my code is as follows :

(Country being the name of the form and ddCurrency being the name of the combobox on the form)

I just dont get it.... is it anything to do with SQL Server?


LVL 11

Expert Comment

ID: 12288342
We still need the code in order to assist you. Could you please post the code for your query?

It might have something to do with the query string and what you are actually reading from the combo box, but I can't tell until I see the code.

Author Comment

ID: 12288558
I am sorry you are talking to an absolute thicko.... please show me an example and I will suss it out from there and post the code for you :)
LVL 11

Assisted Solution

Jokra_the_Barbarian earned 75 total points
ID: 12288741
From a different post, you should have some code similar to the following:
  strSQL = "UPDATE tblWWMSData SET tblWWMSData.[CONTACT INFORMATION] = [contact information] & Now() & ' ' & CurrentUser() & ': ' & [forms]![frmNotePad]![txtNewNotes] WHERE (((tblWWMSData.ID)=[forms]![frmNotePad]![txtID]));"

You probably have a select statement vs. an update. This is what I need to see in order to assist you. Thanks. -Jokra

Accepted Solution

leslynf earned 75 total points
ID: 12289744
Here is the deal. Your combo box may be showing text; however, the actually item in the combo box is probably the identifying number that is unique to that item that shows. You are trying to match the choice to a field in your query that is text, when the identifier is what you need to match.

Leslyn :)

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question