Search results

I have a form with a subform in dataview and wish to append the selected record in the subform to another table when double clicked. I have the following code in the double click event of the subform. Private Sub Form_DblClick(Cancel As Integer) Dim strSearchName As String...

I have a form with a subform in Datasheet view. I want the user to double click a record in that subform and a query to ammend it to another table. I want to trap the double click event of the subform but how do i run a query based on a current record in a subform?

Dsn Thanks for that guys. Haven't a clue what DSN is but it gives me another avenue to explore.

I have a database with the tables linked from another database. The problem is that i need to copy the database to and from another machine in order to work on it. As this involves putting it in a different location each time, i have to relink the tables. Is there a way to link the tables...

I am trying to force a query to select all fields with a zero value but to carry out a different query if the value is more than zero. I have tried with IIF statements in the criteria but without success. ie IIf ( [tblClothing]![ChestMax] = 0 , [tblClothing]![ChestMax] ...

No. As i am starting out, the harsher the words the better. I was hoping that i was making a basic error as they are easier to rectify. That not being the case i will have to look again at the structure of the database. The Stock numbers of each item is different, including sizes thanks again...

I am trying to create a query that gives me a stock number relating to an item of clothing dependant on the sizes of the person concerned. When working i will make it into an update query but the criterea's seem to have a problem with each other. I Got around this to an extent by using IIF...