Search results

Pbaldy: That did the trick , my knickers are now untwisted. Regards Bob

Pbaldy: Thank you very much for your quick response, so far so good, the search now opens up, but to a blank record. Do I aso have to change the #wherecondition:="Clientnumber" = Me.searchKey # to # "Clientnumber = '" & Me.searchKey & "'"# Regards Ypma

A little bit of assistance is sort on “FindFirst “, I am getting my knickers in a twist as how to show that the “clientnumber “in Sub650 is in fact a text field . Sub 146 is a working correctly when in this particular case the Client ID is a number . Note the record source for Sub 650 is a...

Arnelgp:Thank you, with a few minor changes I got the formula to work. and is as follows: #=DCount("Status","StatusForSwitchboard","Processor = 'Joe Bloggs' AND Status = 'Offered' ")+ DCount("Status","StatusForSwitchboard","Processor = 'Joe Bloggs' AND Status = 'Submitted' ")# I omitted...

Arnelgp thank you for you input. I follow your formula and hopefully it will work . Will test it tomorrow. Regards Ypma

Minty ,thank you for getting back to me so quickly. I seem to get a zero . when running the formula, =DCount("Status","StatusForSwitchboard","Processor = 'Joe Bloggs' AND (Status = 'Offered' OR Status = 'submitted')") I was hoping for a total of the two combined. and if 1 was zero the...

Assistance required, currently I am using a list box on a form to count the records in status Offered, this works fine. As below : =DCount("Status","StatusForSwitchboard","Processor = 'Joe Bloggs' AND Status = 'Offered' ") I wish to have the count to include another status is this case...

I too don't use macros , but if you are happy to use a [Event Procedure]of command button,.The search key is a text box which the record id you require is entered. I hope this will be of some use to you. #Private Sub Command146_Click() If IsNothing(Me.SearchKey) Then MsgBox " pse enter a...

Acces help: Thank you for getting back to me , do you need any other help like counting the On targets, which for yes will be -1 . Regards Ypma

Access Help. You posted a question, please have the courtesy to respond to replies . If you are no longer interested I will unsubscribe from this post. Let me know it your problem has been solved. Ypma

Ian, if it is a split database try compact and repair on the back end as the error is pointing to the path connection . Just a thought . Regards Ypma

Access help : Further to my last post I have entered the formula for each of the Grades to obtain the percentages only. I have used the domain function and it work for me. Another way would be to do your calculation on a query . others may have other ideas which they are free to comment'...

I am no expert but just looking at you control source for total students I used #=DCount("Full_name","qry_mark_grid")# I think you have to use query in your formula , hope this food for thought Regards Ypma

Mike were you in Hong Kong in the eighties , and was your wife called Liz.? My wife Truus remembers a Liz Smart. Truus is from Holland and My name is Bob Fortune I was serving with 248 Gurkha Sig Sqn . If not you my apologies . Bob

Thank you Ridders , for posting the searchable postcode db. It provides plenty of information , but not a road name. I known larger roads are named on the map but not the small ones . Thank again Regards Ypma

Too$hort: I found the following code written by John Viescas which work on access 2003 . It requires a function and an after update event code to call the Function. I will attach a demo. If you cannot access the demo I will post the script and call code. Hope this is of use to you. Regards Ypma

Waterfly: I think I have run up against a brick wall as I cannot workout how to show just the one record . Hopefully Minty or one of the other members can salvage this post . Regards Ypma

WaterFly: My cunning plan did not work out, so I took Minty's suggestion and created a sub form . I not sure if I am quite there, but close . query1 is the sub query which gives the result . USED ACCESS 2010 Hope that's ok Regards Ypma

WaterFly: Thank you for responding, I have read you post again and tried to create the db. as per your posts table structure. Using my latest db. demo what would your expect to seen in the query for Jane ? and any other examples of data you would expect to see the query ? If my structure is...

Waterfly. Not sure what moderated means, still I wish to know if my example database was of any use ? I have not attempted to address the sub query solution that Minty gave you . If my demo db. did not address your problem please let me know why so that I can lean something too. Regards Ypma