Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Value Reference in MS Access Query

Author  Topic 

mihirvb84
Starting Member

11 Posts

Posted - 2012-07-12 : 09:48:12
Hi Team,

I have created a form with box in MS Access. Later I added a query into MS Access. Now I want to make this query dynamic so that it can run with the value available in that box.

I tried several reference in "where" cluase of query but did not work. Any idea?

---------------
Mihir Borde

prett
Posting Yak Master

212 Posts

Posted - 2012-07-14 : 02:27:40
You can get better solution of your query on access forum....
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-14 : 19:55:49
add a parameter to query and link it to box of form

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Goverlobutah
Starting Member

4 Posts

Posted - 2014-10-17 : 07:22:00
There are some points which should be consider for good database design, here is the list:
http://www.sql.recoverytoolbox.com/
Recovery Toolbox for SQL Server.[url][/url]
Go to Top of Page
   

- Advertisement -