Solved

debug issue

Posted on 2008-10-08
12
138 Views
Last Modified: 2012-05-05
when i step into codes in vb

there is code called DoCmd.OpenQuery "Search"

how can i check whether the query is giving the right results?
0
Comment
Question by:jaisonshereen
  • 6
  • 6
12 Comments
 
LVL 75
ID: 22671296
Go to the database window, and open the query directly ... and look at the results.

mx
0
 

Author Comment

by:jaisonshereen
ID: 22671362
what do u mean by database window?
is the object ....queries in the left pane?
when i went there i can see the query "Search"

but the icon is different than others different

0
 
LVL 75
ID: 22671364
What type of query is 'search' ?

SELECT? or an Action query (Update, Append, etc) ?


mx
0
 

Author Comment

by:jaisonshereen
ID: 22671391
See this file and rounded in red
query.bmp
0
 

Author Comment

by:jaisonshereen
ID: 22671438
when i right click and take the design view i can see this:


search.JPG
0
 
LVL 75
ID: 22671449
ok ... it's an Append query.  

open in design view, then *temporarily* change it to a SELECT query - and run the query to see the results - which is what you would get  - if it actually does the Append.

mx
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:jaisonshereen
ID: 22671501
there was no row to append !

how can i know where this data comming from?
0
 
LVL 75
ID: 22671565
From the table in the query - in design view.

mx
0
 

Author Comment

by:jaisonshereen
ID: 22671657
can u explain what does the search.jpg mean?
0
 
LVL 75
ID: 22671700
no clue what you are referring to ... JPG ???

mx
0
 

Author Comment

by:jaisonshereen
ID: 22671722
ok from the second pic!!

Can u explain what the values represent ?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 22671816
Your question was:

"how can i check whether the query is giving the right results?"

I explained how to do that ... and apparently there are no results.  You need to look at the data in the Table.

mx
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now