Search results

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...

Managed to figure it out, For anyone with a similar problem, the soloution was to create a query showing records with only the userID which corresponded to the PosID and then change the record set of the form to this query: Private Sub LstPos_AfterUpdate() ' Purpose: Change the form's...

I'd ideally like to keep it all filtered through the current VBA Filter and not a query. In the same format as: If Not IsNull(Me.LstUser) Then strWhere = strWhere & "([User] = " & Me.LstUser & ") AND " End If If Not IsNull(Me.LstDays) Then strWhere = strWhere & "([EnteredOn] >= " &...

Pr2-eugin, thanks for the reply. Sorry I shall try and explain better. I am trying to create a form that filters all the Report records based on the criteria that is selected in the list boxes. This is the table whose records I am filtering. TblReport ReportID ReportDate Shift OrderType...

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]...

Sorry for wasting your time, but I managed to get it working, there was a problem with the date format. Perhaps you can help me with another problem though. I'm trying to add another field into the filter - Position. However the position field is in a seperate table to the records being...

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...

Do you mean have 3 hidden text boxes with all 3 seperate order no's displayed depending upon what Area is selected. And then something like IF listbox.OrderType = 1 THEN Make Textbox.1 Visible? The problem with that being I then want to store that order number along with the entered report. I...

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...

That's hit the spot perfectly, thanks! I'm not familiar with this fuction so I shall go and have a read up. Is there a way I can store this information in my vehicles table? Thanks again!

Thanks for the response pr2-eugin. Sure, It's not a brilliant description. Bascially I have a list of records for each vehicle: and a list of records for maintenance done on that vehicle: Each vehicle will have many maintenance/service records, with each record storing the date that the...

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...