Solved

debug issue

Posted on 2008-10-08
12
139 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
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.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

948 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

22 Experts available now in Live!

Get 1:1 Help Now