Search results

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

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

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

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

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

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

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,"")="";

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

Thanks Plog, This is my result

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

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

Tried using Is Null same result, Thanks

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

Thanks Guys :) Changed to outlook classic and my access database is now emailing, Had some trouble entering my details but finnaly figured out its not a POP account but a IMAP, Thanks again :)

Yes and I dont like it I would to like to use another version can I change my email client? Thanks Bob

I am running Windows pro 11 and Microsoft access 2024 on a 64 bit operating systerm. When I uprgraded from Access 2013 to access 2024 , when My database activates to email its brings up Outlook 2016 wizard. I have Outlook new open but access dosent seem to want to use it. Do you think it might...

This Laptop came with Windows 10 pro, So I imagine Outlook New came with that. So cant go back to Outlook Classic. When downloading Windows Classic and try to install it, I am getting this message. To install this product, first uninstall Microsoft Visio Standard 2019 Microsoft Office...

Thanks Doc Man, Yes this is Outlook (New) , I dont see A option to revert to the old Outlook Also I tried my database through Windows Live and got the same error Thanks for your help.....Bob

My Laptop is running 64 bit Microsoft 365 Office , My database was created in Access 2013 in 32 bit operating System I have opened my Database with Microsoft Office Access 64 bit and everything works fine , except when i go to email I have 2 options of emailing in my database Outlook and...

I have moved my Database from a 32 bit operating system to a 64 bit computer. I am Running Microsoft Access Runtime 2013 and it operates my database just fine on my laptop, Except when my database goes to send a email, It creates the pdf files then I get this error [ Active X component cant...