Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tmccork
  • Content: Threads
  • Order by date
  1. tmccork

    Can code refernce a Row in a table

    I am trying to find a way set a textbox on a form = to a recordsource row and colum. Or a work around so that if the records change the boxes will change. Any Ideas welcome Thanks Terry
  2. tmccork

    Help with SQL query/report in code please.

    I am trying to create a form for custom reports. I would like to give check boxes for the different products (t-shirst, Sweatshirts, ect), and with the products checked create a sql query and run a report, from the click of a button. If there is a better way I would be interested too. I am new...
  3. tmccork

    Help with Where Clause please.

    I am trying to open a form and have it's where clause filter by [size] and [color] from the current form. I cannot seem to get it to work. I get the error. Syntax Error (Missing Operator) in query expression '[Size]=11 oz. And [Color]=Blue'. "11 oz." and "Blue&quot...
  4. tmccork

    Setting a variable = Query

    How do I get a variable to = the value of a query, then from that variable run another query to display a list of all records with that have that value. I am not sure where to start, any ideas will help. Thanks
  5. tmccork

    Can Visio shapes use ADO to reference a database .

    I have been working on getting a linked shape to communicate with an Access database using ODBC, it works but I need to be able to locate where the database is and then reference it. ADO can do this I have been told. Is there a string I can put in the shape sheet to reference an ADO datasource...
  6. tmccork

    ODBC Connection that can be changed through code.

    I am wondering if anyone has some code that will allow me to have my root directory change, and still be able to locate my ODBC data source. Basically I need to have my code do a search for what drive the file is on and then connect and update when the file is opened. I would apreciate any...
  7. tmccork

    Trying to reference a file root, to locate another file.

    I am trying to make a reference in a user defined ODBC cell that will reference a database located on the same root drive as the visio drawing. There is a way to do it because visio sample database does it, but I am not sure how. The goal is top be able to put both an Access database and a visio...
  8. tmccork

    Can ODBC code in a shape reference the root of a file.

    I am trying to make a reference in a user defined ODBC cell that will reference a database located on the same root drive as the visio drawing. There is a way to do it because visio sample database does it, but I am not sure how. The goal is top be able to put both a database and a visio drawing...

Part and Inventory Search

Back
Top