Recent content by dr223

Ok my friend- this is not an application I developed my self. Those where its thrown to you resolve before end of week thingy. The guy who developed this seemed to have used the Application.FileSearch - as you noticed is the root of the problem thank you for that.. Now, I need to...

Ok - How can i use the Dir method / vb code directing to the code; Sub Search2() On Error GoTo Search_Err Dim strPrompt As String, strTitle As String ChDir AttachmentPath ' Changes directory to new file path Dim i As Integer With...

Ah ! Apparently FileSearch method was taken off in Access 2007 Any way round it ? Thanks

At run time - when I open the form (frm_Enq_Address_Dialog) - A message box comes up with teh message; "File Path not Found (You entered an expression that has an invalid reference to the property FileSearch)" I clicked Ok - same message came up - Clicked Ok same message came up (3...

Hi, I had an application developed with another developer in Access 2003, our company has upgraded our laptops to Microsoft Office 2010 and now when I open a form (frm_Enq_Address_Dialog) I receive an error on Form load as "File Path not Found (You entered an expression that has an invalid...

Ok - fine but I still need to have that at the last of the list.. Its a business type and I cant ignore it at all. If there any approach I could change the query to consider this. There will always be 1 business type that will not be a winner and I want it to be at the bottom of the list...

Thanks pbaldy- Result; BusinessTypeCombined TotalCount TAXI 3 MPESA 2 KIOSK 1 Nearly there - I dont get the businesstype TUKTUK as the last type available. Why? Thanks

Someone out there should be able to help... Thanks

Tried as suggested; SELECT IIf([QryCalcWPM2].[Score]>1,[QryCalcWPM2].[A].[BusinessType],[QryCalcWPM2].[B].[BusinessType]) AS BusinessType FROM QryCalcWPM2 ORDER BY QryCalcWPM2.Score DESC; Result I received was: BusinessType TAXI MPESA KIOSK MPESA TAXI TAXI I want the query to...

Ok - attached is a sample of the database. Please shade some light for me - the problem is in QryWPMScores2 If you open QryCalcWPM2 you'll notice the; A.BusinessType B.BusinessType Score KIOSK MPESA 0.97 MPESA TAXI 0.97 KIOSK TAXI 0.95 MPESA TUKTUK 1.21 TAXI TUKTUK 1.25 KIOSK TUKTUK 1.18...

ThatOtherQuery - gives wrong results. SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; As with the below data; BusinessCombined Score KIOSK/MPESA0.97...

pbadly - I tried what u suggested .. SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM [B]ORDER BY QryCalcWPM.Score DESC; The database is to huge and sensitive to attach.. any hints

Yes, I did change the query to; SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Results Based on the initial query: BusinessCombined Score...

any help please to formulate this query - am working with Access 2003.

How can I do that please?