Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

debug issue

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
jaisonshereen
Asked:
jaisonshereen
  • 6
  • 6
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Go to the database window, and open the query directly ... and look at the results.

mx
0
 
jaisonshereenAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What type of query is 'search' ?

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


mx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jaisonshereenAuthor Commented:
See this file and rounded in red
query.bmp
0
 
jaisonshereenAuthor Commented:
when i right click and take the design view i can see this:


search.JPG
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
jaisonshereenAuthor Commented:
there was no row to append !

how can i know where this data comming from?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
From the table in the query - in design view.

mx
0
 
jaisonshereenAuthor Commented:
can u explain what does the search.jpg mean?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
no clue what you are referring to ... JPG ???

mx
0
 
jaisonshereenAuthor Commented:
ok from the second pic!!

Can u explain what the values represent ?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now