Recent content by chrisb1981

Thanks addy that worked perfect. Like I said it's my lack of knowledge which is holding me back!!

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

Thanks for the quick reply Ken. I am fairly new to access and I don't know what you mean. Could you explain what to do or point me to where I might be able to read about it. My current coding is: SELECT SalesForecast.CompanyName, SalesForecast.CourseName, SalesForecast.TotalGross...

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 tried the coding you gave me moniker as I wanted to use cleaner code and I get a error on the lineCase "chris.butler" Or "caroline.mulvihill" Or "caroline.farrell" It says Type Mismatch. Which is why I ended up using multiple IF statments in my original code as I could not get it working.

Like MStef said use the "On Timer" and "Timer Interval". In "Timer Interval" put in 5000 which is equal to 5 seconds. For "On Timer" use: DoCmd.Close acForm, "Loading", acSaveNo change "Loading" to your form name.

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

Thanks Brian it worked great!!

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

Thanks edtab it worked great!! I just couldn't think what needed to be added

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 fixed this now. The problem was recordID was an autonumber field I changed it to a different field and it works fine

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