Search results

I am mid way through MCDBA with computeach and have found them to be a good training provider, my only problem is making enough time in an evening to do the course - as i have to do in my own time, have resolved myself to the fact i wont get it finished in time due to home commitments but their...

is the problem a conflict using double quotes " could you not use single quote ' ie: =" ' "&[RootCauseStatement]&" ' " Ian

I did use a change password form that uses access security, see the link below to sample database, BEWARE if this is used on a non secured database, you could change the default access password, and unexpectedly lock yourself out. It is simple to use just drop in the form and module and away...

Hi - There is a post on the sample database section of this forum which i found to be very useful, and would probably suit your purpose very well, take a look at the link below to "Searching & Sorting" article http://www.access-programmers.co.uk/forums/showthread.php?t=110203 Ian

Thanks for the reply Neil, It could be worth trying that - running the same query with Left, Mid & Right (separatley of course) - as doing the manual way i am averaging around 200 matches per hour... I think i will have lost the will to live when I get to the end if I have to do them all manually!!!

Hi - I am working on a database where i need to update a table with a "UniquePersonID" I have a master table which stores: UniquePersonID Surname Forename DOB SEX Postcode This table is approx 600k records, now the problem i have is that i have further tables which contain Surname, Forename...

I think you could use a Between in your statement as follows WHERE tblSchool_Clean.TOTAL_RESIDENTS Between Forms!YourFormNameHere!txtResidentsMax AND Forms!YourFormNameHere!txtResidentsMin ; Ian

Hi Rich, Many thanks for pointing me in the right direction - it works a treat. I have posted the working code below if it is of any use to anyone else Dim Answer As Integer Dim intX As Integer intX = DCount("*", "qryReminderCount") If intX >= 1 Then Answer = MsgBox("You have " &...

Hi All, I wonder if anyone out there can help with a huge headache i am getting - We have a database which logs patient contacts & requests and have a reminder system within which requires users to run a report to see if they have any actions that are required. What I would like to do is when...

Cant take credit for this but have found this method quite useful: Try the handy and overlooked Microsoft SysInfo Control 6.0. It gives you the work area of the desktop, and an event if it changes. Without a border, you need some way to close the form, so I used a button. Option Explicit...

Many thanks for the reply Dom, I will be sure to look further into this. Regards - Ian

Have a look in the sample database section - there is a very good example for search and sort - which does exactly what you are describing. Ian

Hi, I have just been having a look at the XShortcutBAR in sample databases by Dom DXecutioner - an excellent outlook style menu bar, I would like to use something very similar - or indeed start with this very sample - but i am struggling getting my head around the menu changes, for example when...