Search results

Hi All, I'm using a multi-field search code, which I got from this forum I've also inserted code so that when a record is selected in the search, i can click a button - and it the particular record found will carry into a new form. Private Sub btnLoan_Click() On Error GoTo Err_btnLoan_Click...

Thanks for your feedback Bob. I'm very new to this, so I'll do some research on normalising a database. Cheers, Leigh

Please find attached a stripped down version of my DB Thanks Bob

Hi All, On one of my forms, I have a list box (SearchResults). This pulls data from "tblContacts". What I want to do, is to add two "filters" to narrow down the listbox results. I've got other forms running with code which work perfectly for only one condition... but now I'm trying to add...

On it's own line, it works fine: DoCmd.OpenReport "tblEquipment", acViewNormal, , "txtBarcode=" & txtBarcode but as soon as I put it into the line in my code for it to fire on vbYes - it doesn't. Sorry, very much a novice!

That's perfect, thanks so much for your help :)

Hi All... I'm sure this is something very basic and simple - but I can't get it. This line keeps shouting an 'Expected: expression' compile error at me - DoCmd.OpenReport tblEquipment, acViewNormal, , txtBarcode= & txtBarcode Can anyone please advise? Full Code: Private Sub...

That works great! Thank you! The only other thing that I would like it to do (not sure if it's possible) is if a template is selected, it does not overwrite all of the txtTemplate field - but instead adds the template to the end. So if I load the form, and type in some immediate notes into the...

Thanks for your replies. I guess I just thought it would be better, layout wise, if it was sat on another form... as the templates wouldn't be used on every data entry. But just going with what you have suggested... I've inserted a new table (tblTemplates) with three fields, ID, Title...

Hi All... I'd really appreciate some help. I'm fairly new to Access and VBA... and I'm working on a project for an issue logging system. Here's what I'm trying to achieve. I've got my "New Issue" form (FORM 1)(frmNewIssue) and on that contains an 'Template' button (btnTemplate) and lots of...