Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

debug issue

Posted on 2008-10-08
12
Medium Priority
?
147 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
[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
  • 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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

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 2000 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

705 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