Solved

debug issue

Posted on 2008-10-08
12
141 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
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!

 

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
 

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 - Microsoft MVP, Access and Data Platform) 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

713 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