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 derfloh 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: *

  1. tmccork

    Can code refernce a Row in a table

    Thanks Rollie, I am not sure that I explained my problem. I have a form that I would like to have multiple records on, for instance records 1-5. Each record has five fields, [RecordNum], [Name], [Frequency], [Date1], and [Date2]. The [RecordNum] field will change as well as the others so I would...
  2. 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
  3. tmccork

    Help with SQL query/report in code please.

    I see what you are saying Ken. What I was planning on is having the check boxes reference tables in a union query for diferent types of products. There is a table for additional items, and Misc items for items added in the future. Can I make a check box hidden, and have it be renamed and then be...
  4. 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...
  5. tmccork

    Help with Where Clause please.

    Thanks everybody, I used the chr(34) and it works. I appreciate the help. Terry
  6. tmccork

    Help with Where Clause please.

    I tried removing the quotes, the form opened but does not bring up the record. If I try to filter just by one field it works fine, stLinkCriteria = "[Color]=" & "'" & Me![Color] & "'" My string that opens a blank form looks like this stLinkCriteria =...
  7. 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...
  8. tmccork

    Setting a variable = Query

    This will be used in a double click search box. The goal is to double click on one record, from that record have it run a query to display an associated item from a seperate table. Then find all records that have the same property. eg: Double click on a [Wire ID] from a list box on a form...
  9. 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
  10. 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...
  11. 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...
  12. 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...
  13. 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