Search results

still not sorted this?

Any luck? thanks

zipped and attached thanks

Yes however, I've just tired using the same text box but different button and that doesn't work either. It says the same error - does not recognize etc. thanks

at the moment it comes up with run-time error '3070' the Microsoft access database engine does not recognize 'name' as a valid field name or express searching for a number works but no name will thanks

thanks for your reply but it doesn't want to work Run-time error '3464': data type mismatch in criteria expression Private Sub Command75_Click() Me.Recordset.FindFirst "[asset]= " & Nz(Me![Text73], 0) & " or [contact name]=" & Nz(Me![Text73], 0) If Me.Recordset.NoMatch Then MsgBox "no record...

Hi there I'm looking for a bit of help - im running access 2010 I've got a command button (on a form)which searches text entered into a text box so command75 search text69 which displays the results for our asset -this works perfectly the code I've got is: Private Sub Command75_Click()...

Hi, I'm fairly new to access databases and currently using access 2010. I have a database for storing information on our PDA's. I have multiple tables for the contacts, software, make, model etc, which is then linked to the asset table. I then have an asset query as well as a contact...

Hi Guys, im fairly new to access so looking for a bit of help :) I work for an engineering company and currently doing a Database to store information on our PDA's :)