Search results for query: *

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...

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

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...

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...

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

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 =...

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...

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...

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

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...

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...

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...

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...