Search results

Hi I'm using this code that I found on the internet to correct capitilisation Public Function ProperCase(AnyText As Variant) As String 'r_cubed 'Convert passed text to all lowercase. Use ProperCase() as you would a built-in Access function. 'If passed value is a null, ignore all...

Thanks Bob - in the new upload i've made that change and also commented out the beforeinsert code that was erroring. Let me know what you think?

Hi Pat - sorry the forms display fine on my laptop but I'm running 1600 x 900 pixels which may be smaller than yours... I'll repost with scroll bars added to all forms to make it easier to see I'm not sure about the confusing comment - that may have been caused by me cutting down my main...

Thanks Pat & Bob Attached is a sample of my database which replicates my problem.. I've tried to insert Bob's code and now I get an error on the form opening let alone when trying to close... Any help gratefully received

Hi - I'm a little confused tblProjectFundingType has ProjectTypeID ProjectType 1 Funded Projects Only 2 Non-Funded Projects Only 3 All Projects But yes my tblYesNo table YesNoID YesNo 1 Yes 2 No So currently if a project has funding someone selects...

Ok here is the search form as it currently works... Thanks for your time looking and helping :-)

Thanks I'll just try and sort that out so I can post something This is the query in SQL if it helps at all? Looks jibberish to me in SQL... SELECT tblProject.ProjectID, tblProject.ProjectName AS [Project Name], tblProject.[Funded Project?], tblProjectCountry.ProjectCountry AS [Project...

Hi Trevor - I've made that change but still no records show... :-(

Thanks Trevor i've got the delete query working :-)

This sounds so simple but I cannot get it to work Combo box has three options 1 Yes 2 No 3 All Table field has two options 1 Yes 2 No In my search form the query on this field Like [Forms]![frmProjectSearch]![cboProjectType] Works if I choose Yes or No but nothing if I...

Sorry I don't understand... what query? And I did just try and make the ProjectID textbox unbound which did enable the record to be deleted :-) but then also stopped any new records being attached to a project even though the project ID was displayed in the box still... So I'll need to bound...

Thanks Trevor for the reply - but no the only record I want to delete is the single line in tblFinanceYear which just links to tblProject by ProjectID but I don't want to delete anything in tblProject just this one line in the Record Source table for the form. The only thing I can think of is...

Hi everyone - this is still rumbling on - any ideas?

Hi Pat and also anyone else who might be able to spot the error of my ways... Any idea why it would allow two entries even though it only stores one for a 'unique' index? Thanks

Hi I've found an old thread called this same thing but it didn't quite work for me still and didn't want to post onto a 2 year old thread... so figured I'd start a new one... hope that is ok and I am staying the right side of the site admin's... I have a cmd button on a form which if clicked i...

I'd reviewed my indexes on the tables involved in this process and they looked fine and tblFinanceYear looked like your picture... I've also now gone through my entire database and removed any rogue indexes that don't add any value and I still have the same issue... It still stops two...

Any ideas - before I lose my sleep dreaming in VBA? ;-)

Ok - I am losing the plot!! :confused::confused: I have this working in one part of my database and I think I'm using the same principles but cannot get it work in another part. Where it works: I have a parent form with annual totals on and a button which opens a detail form to add the data...

That it because I had no idea this existed or any idea how to use it - I'm a complete VBA newbie... Hence setting up tables for everything from Yes/No to Years... those I at least kind of understand...

Thanks Pat - I've now got that working and it will allow me to use the Year 2012 in different projects but not allow more than one 2012 in the same project... BUT... It still doesn't error - how can I get it to check if the year 2012 (for example) already exists for that project and then...