Search results

As Does the debuging!

Thanks A Lot for your help - works like a charm!

Thankyou for your help with this - works perfectly! Am far more used to Excel. One more thing - if I would like to add another condition - say another field titled vessel date as a further search criteria - would i just add AND [vessel date] =..... after the WHERE statement? or am I off the...

As An update - I have managed to create this; Dim lnk As String Dim Lnkedit As String Dim db As Database Dim Tbl As TableDef Set Tbl = CurrentDb.TableDefs("Master Table - Packages") Set db = CurrentDb lnk = Me.LinkBox.Value Lnkedit = Replace(lnk, """", "#") db.Execute "UPDATE Tbl" & _ "SET...

Hi, I am creating a database that requires a user to link a file to a record in the database. To do this I am currently using an update query, The user manually 'copy as link' from the file and pasting into the update to field. The issue is - Copy As Link adds "'s before and after the link...

Thank-you to both posters, very helpfull!

Hi, Never posted here before. I'm pretty good as an excel user so thought writing VBA for access would be the same. However i've become pretty stuck. I have a single table for all the data in my database, and a number of forms that users can use to edit this data. One of these froms is a...