Search results

  1. Y

    Copy Value Into Form

    Nicole, like Gasman i fail to follow what you end games is? I have added Gasman's formula to your database and it works as intended, however the questions i ask is why a memo field a text field can except 225 characters and will you have a different record for daily changes? Please supply more...
  2. Y

    TShirt Query, (newbie!!!)

    Not hijacking this post, just suggestions . Why not us the true/false field for you r criteria , if set to false you would would not need to ice team <> "withdraw, which should read <>ice team And <>"withdraw" hope i have understood your requirements . # YPMA
  3. Y

    Decimal place issue

    munkeyroot: Assuming the filed is numeric have you tried the setting, under data type the Decimal places to ZERO . This would work a tale level. Just a thought YPMA
  4. Y

    When value equals 0, record disappears

    CountOfProvider Name Mnemonic Active / Inactive 1 FFPA Active 1 FIXX 2 FMCC Active 1 FMSC Active 4 FMSR Active Not sure what you require in the active / inactive field ? currently this field is counted but is Blank . Have you considered using inactive...
  5. Y

    Findfirst for text string

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

    Findfirst for text string

    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
  7. Y

    Findfirst for text string

    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...
    • ypma
    • Thread
    • Replies: 5
    • Forum: Forms
  8. Y

    list box on form Dcount

    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...
  9. Y

    list box on form Dcount

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

    list box on form Dcount

    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...
  11. Y

    list box on form Dcount

    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...
    • ypma
    • Thread
    • Replies: 5
    • Forum: Forms
  12. Y

    Record search is bringing up a blank record when no record exists

    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...
  13. Y

    #Error - Form Field

    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
  14. Y

    #Error - Form Field

    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
  15. Y

    Unrecognized Database Format

    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
  16. Y

    #Error - Form Field

    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'...
  17. Y

    #Error - Form Field

    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
  18. Y

    Mike were you in Hong Kong in the eighties , and was your wife called Liz.? My wife Truus...

    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
    • ypma
    • Profile post
  19. Y

    A fully searchable UK Postcode database

    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
  20. Y

    Replace 3rd character in string with uppercase

    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
Back
Top Bottom