Search results
-
L
Change of data type
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...- leighj
- Thread
- Replies: 3
- Forum: Modules & VBA
-
L
Search Listbox with Multiple Critera
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...- leighj
- Thread
- Replies: 5
- Forum: Modules & VBA
-
L
Expected: expression
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...- leighj
- Thread
- Replies: 3
- Forum: Modules & VBA
-
L
Passing pre-defined text from Form to Form
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...- leighj
- Thread
- Replies: 8
- Forum: Modules & VBA