Recent content by turniporange23

  1. T

    Bold font for numbers more than -1

    Well nearly did the trick, I am trying to get tbInvoiceAmount to drop its font from 9 to 8 if tbFlag is -1 Conditional Formatting has no option of reducing the text size, Any Thoughts...........Regards Bob
  2. T

    Bold font for numbers more than -1

    Thanks Tom that did the trick
  3. T

    Bold font for numbers more than -1

    On my subform of my report I am trying to force access to give numbers more than minus 1 and bold font Is this possible? This is the control source to the text box =IIf([Flag]=0,[AmountSummary],"(" & Format([AmountSummary],'$#,##0.00;$#,##0.00') & ")") Thanks for any help................Bob
  4. T

    Solved-Trying to Delete empty records!

    I moved my code to OnLoad of my Main opening page instead of my closing button, and now the code is deleting the records thats have the 4 blank fields Thanks for everybodys help :) Bob
  5. T

    Solved-Trying to Delete empty records!

    Any reason the delete code dose not work When I shut down my database .. Thanks Bob Private Sub cmdQuitSlow_Click() 'Me.ckbUpdate = True 'Forms!frmMain.Requery DoCmd.SetWarnings False DoCmd.SetWarnings False DoCmd.OpenQuery "qryOrphanAddCharges" DoCmd.OpenQuery "qryOrphanDaily" DoCmd.OpenQuery...
  6. T

    Solved-Trying to Delete empty records!

    DELETE tblHorseInfo.HorseName, tblHorseInfo.MotherName, tblHorseInfo.FatherName, tblHorseInfo.StableName, * FROM tblHorseInfo WHERE (((tblHorseInfo.HorseName) Is Null) AND ((tblHorseInfo.MotherName) Is Null) AND ((tblHorseInfo.FatherName) Is Null) AND ((tblHorseInfo.StableName) Is Null)); This...
  7. T

    Solved-Trying to Delete empty records!

    When I entered the Nulls the query said there where no fields , Thanks
  8. T

    Solved-Trying to Delete empty records!

    Ok one little problem ,when I double click on my query it works but when i enter in into my shut down button it does not delete the top 3 records, Thanks for any help ..Bob qryDeleteNoDetails is my query Private Sub cmdQuitSlow_Click() Me.ckbUpdate = True Forms!frmMain.Requery...
  9. T

    Solved-Trying to Delete empty records!

    isladogs your a legend, Your code worked perfect deleted out the top 3 fields, Thanks for all your help everybody :) Regards Bob DELETE *<br>FROM tblHorseInfo<br>WHERE Nz(HorseName,"")="" AND Nz(FatherName,"")="" AND Nz(MotherName,"")="" AND Nz(StableName,"")="";
  10. T

    Solved-Trying to Delete empty records!

    Thanks Tom, Usally Horses keep there racing name unless they go to another country,This database is just for my stable so if the horse leaves I put that horse in finish mode, Actually Horse Name and Stable name are usally different. Example horse Racing Name "Perfect Dividends) and stable Name PD
  11. T

    Solved-Trying to Delete empty records!

    Thanks Plog, This is my result
  12. T

    Solved-Trying to Delete empty records!

    I Ran your code June7 , for some reasson record 218 does not have a zero, the top 3 records should be deleted
  13. T

    Solved-Trying to Delete empty records!

    DELETE tblHorseInfo.HorseName, tblHorseInfo.FatherName, tblHorseInfo.MotherName, tblHorseInfo.StableName, tblHorseInfo.HorseID FROM tblHorseInfo WHERE (((tblHorseInfo.HorseName)="") AND ((tblHorseInfo.FatherName)="") AND ((tblHorseInfo.MotherName)="") AND ((tblHorseInfo.StableName)="")); Code...
  14. T

    Solved-Trying to Delete empty records!

    Tried using Is Null same result, Thanks
  15. T

    Solved-Trying to Delete empty records!

    There is about 20 fields in each record, but if these 4 fields are all empty I want the record deleted. All the fields are Short text. At the moment I have a record that has 4 empty filds but it is not asking to Delete 1 Record. Thanks for any help.......Bob DELETE tblHorseInfo.HorseName...
Back
Top Bottom