Recent content by Purpleswanage

Please help. I've inherited a database which uses staff numbers as the primary key. Having had these numbers for 30 plus years it was figured that this was a pretty good unique identifier. That was until 1st April (no it wasn't an April Fools prank) when all the finacial systems changed and we...

WOW!:) David, thank you so much this works like a dream. Thank you to everyone who has helped me with this problem. Helen:)

I have written a database to track Errors, New Requirements and Requirement changes in the software code our programmers develop. I have secured the database using the in-built Security Level Wizard using the "Full Permissions" group for those I trust not to fiddle and the "Full Data Users" for...

Russ, Paul, DCrake, I just wanted to thank you all for your extremely useful posts. Having struggled with the Query Builder for many days I finally took 'the bull by the horns' and had a stab at understanding the code posted. D'you know what? It wasn't that scary and I now have a functioning...

Russ, Thank you for coming back to me and offering to help. I thought I might have cracked it but alas I was worong. At the moment even the 'sanitised' version exceeds the upload size so I can't up load at the moment. I'll keep trying. Helen

Sorry for the delay in replying but I pretty much lost the will to live yesterday! OK I have my Query (in the query builder) with all the fields I could possibly want. In the 'Criteria' of the first field I have [Forms]![FmAdvancedSearch]![ARNValue] In the 'Or' of the second field I have...

Thanks I think I see what you are saying and I will have a play:) Can I be really thick? Could you give me a definition / example of 'Control'? I keep seeing it in code but I can't really work out what it means. Sorry! As I said I am really new to this. Thanks Again Helen

This Forum is a God Send and everyone is so helpful. Ghudson's Audit Trail code saved me many hours of hair pulling :) Anyone out there who may be able to help with my Audit Trail Query? Anyway, I've been developing a database for the last 2 weeks (night & day it seems!) to track "bugs" found...

Thanks. Have used a form to add values and the performed a requery on the 'Got Focus' to update the main data entry form. Thank you for your help. Helen:)

This works a treat. Thank you so much for your help :) Helen

Thanks i'll give it a go! Helen:)

This probably should be really easy but I can't get it to work. My main form has a number of fields which are Combo boxes drawing their values from tables. In event that the required value is not available I need to be able to DblClick on the field to open the source table to add the new value...

re. ghudson's audit trail code... Absolutely brilliant, thanks. DOH! It would help if I included the code I was using! Function AuditTrail() On Error GoTo Err_Handler Dim MyForm As Form, C As Control, xName As String Set MyForm = Screen.ActiveForm 'Set date and current user...

Help! Very Very new to VBA & totally out of my depth!!!! I have an automatically generated reference field (text box) within the main data entry form of my database. AR/2008/### which is generated by the code below. The 'AR' is constant for every record, the '2008' is generated from the...

Hi! Being relatively new to VBA this piece of code was a God Send to find and works brilliantly. Thank you. The fields I am tracking are linked to tables which have two columns. The first is the unique ID and the second being the 'description'. The audit trail report returns the changed...