jaisonshereen
asked on
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?
there is code called DoCmd.OpenQuery "Search"
how can i check whether the query is giving the right results?
ASKER
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
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
What type of query is 'search' ?
SELECT? or an Action query (Update, Append, etc) ?
mx
SELECT? or an Action query (Update, Append, etc) ?
mx
ASKER
See this file and rounded in red
query.bmp
query.bmp
ASKER
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
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
ASKER
there was no row to append !
how can i know where this data comming from?
how can i know where this data comming from?
From the table in the query - in design view.
mx
mx
ASKER
can u explain what does the search.jpg mean?
no clue what you are referring to ... JPG ???
mx
mx
ASKER
ok from the second pic!!
Can u explain what the values represent ?
Can u explain what the values represent ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mx