[Webinar] Streamline your web hosting managementRegister Today

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

How to know where my query in the vb code

i have a query called "search" in access object

i need to know where the code is called in my vb developed application.

how can i find that ?
0
jaisonshereen
Asked:
jaisonshereen
3 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
By "vb developed application" do you mean you have an application in Visual Basic, or you have an Access application with VBA code? They are two entirely different things ...

For Access - Rick Fisher's Find and Replace will do it: www.rickworld.com

For either - MZ tools may be able to do this: www.mz-tools.com.
0
 
Gustav BrockCIOCommented:
Pick Find from the menu. Look for "Search". Select last option Entire project.

/gustav
0
 
jaisonshereenAuthor Commented:
Pick Find from the menu. Look for "Search". Select last option Entire project.

this meathod is not working , i cannot find any "query"

But in database window i can see the query

so ..is it mandatory that , i will not be having a "query" which is there in database window , is mandatory in the vb code ?

LSMConsulting:

it is an access application with vba code !
0
 
Gustav BrockCIOCommented:
> i cannot find any "query"

Then your query is not executing from code.

A query object is not generated with VBA code. It lives by itself.

/gustav
0
 
RobSampsonCommented:
Hi, try picking Find from the menu. Look for "select", then select to search the Entire project.

If there is no SELECT query in the code, then look for
DoCmd.OpenQuery
or
DoCmd.RunSQL

Regards,

Rob.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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