Search results

  1. M

    Display Query Results Sensible (Filter in LstBox?)

    Hi All, Been scratching my head on this one, hopefully one of you smart chappies can help me. Basically I have a database that inspects pieces of machinery. All of my results are collected in a table called, tbl_Inspections. I have created a couple of queries that will: a) Filter on Max...
  2. M

    List Box Form Filter

    I want to be able to show all records from tblRecords where, The [tblUser][PositionID] = The Value selected on the list box.The problem being I don't really know how to do this with them all being on seperate tables and linked via relationships. I.e. [tblRecords] only holds the UserID, [tblUser]...
  3. M

    Filter Records: Adding unbound Date listbox to Filter String

    I'm trying to hash two scripts I've found into 1 functioning filter, however I'm still relatively new to vba and can't figure out how to get this working. I'm trying to use Allen Browne's Search Criteria: with another snippete of code I found here: 'Purpose: This module illustrates how...
  4. M

    Populate textbox based on 2 list box selections

    Hullo there Guru's. Had a quick look for this as I thought it'd be quite a common problem but can't seem to find a soloution. I have 2 tables. tblOrderType tblArea On my form I have two list boxes: An Order Type List box, and an Area Listbox. What query criteria or VBA code would I...
  5. M

    Newbie Query Criteria: When ID = Current Record ID

    Hello Everyone, I'm just venturing into Access and VBA and have found this forum really helpful on my journey, but the time has come when I actually have to ask you guru's for some help :p. I am creating a vehicle maintenance DB, The 2 important forms are: frm Vehicles: Where I have some...
Back
Top Bottom