?
Solved

where clause when setting dao in access

Posted on 2014-09-25
2
Medium Priority
?
208 Views
Last Modified: 2014-09-25
Can I add a where clause to the following:

Set rstRangeWords = Db.OpenRecordset("tblRangeTemp")



not sure if i can do that directly here or do i have to put in sql?

this holds the value rstRangeMarque.Fields("Marque").Value
0
Comment
Question by:PeterBaileyUk
[X]
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
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40344575
Set rstRangeWords = Db.OpenRecordset("Select * From tblRangeTemp Where <Criteria here >")

or you can use

dim sql as string
sql="Select * From tblRangeTemp Where <Criteria here >"

Set rstRangeWords = Db.OpenRecordset(sql)


.
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 40344602
thank you that was fast
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

764 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