Search results

I currently have the code Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.RecordCreator = "" Then Me.RecordCreator = CurrentUser() Me.CreatedDate = Now() Else Me.UpdateBy = CurrentUser() Me.UpdateDate = Now() End If End Sub which is not doing what I want it to. I know it is my knowledge...

I want to group my report by field "Nominal" but I need the grouping on part of the field. The Nominal field is a number field and is 6 digits long. E.g entries in the Nominal field are like this: 100110, 100120, 100130, 100140, 105110, 105120, 105130, etc. I need to group and subtotal on the...

I currently have the code below which filters the form depending on who should have access to which records. It all works fine but now I want to add in an extra filter criteria. So basically I need the Me.Filter(shown in red) changed to include DeleteRecord="0" (field in tblContacts) which will...

I have a form which currently filters records by record owner using NTLogin as the filter this is working fine but now I need to filter the records by record owner and their assigned buddy. E.g If Andy or Steph logon they see the same records because Andy is the Record Owner and Steph is his...

I have a report that is date driven and shows when people have booked onto a course. This works great but now my boss wants something different. What he wants is a report that will show what has moved from which month and to where to track sales figure changes. E.g Rob books on a course in...

I have got a search form based on Allen Brownes Find As You Type. I have put the following code into the Dblclick event for all fields: RecordID = RecordID DoCmd.OpenForm "SalesForecast" DoCmd.GoToControl "RecordID" DoCmd.FindRecord RecordID DoCmd.Close acForm, "Search" And I am running into...