Search results

Yes sorry for the quotes. I've tried what you have suggested now nothing happens. Private Sub cmdEmailSupplierClaims_Click() Dim strTargetFolder As String strTargetFolder = CurrentProject.path If DCount("*", "[HistoryCardNCIC]", "[PIR] Is Null") = 0 Then MsgBox ("No records to...

Here is my original code And I was trying to adapt this to stop it from running but kept getting insufficient parameters. I was trying to adapt But struggled with the if statement and kept getting a message saying insufficient parameters!!!! Bit rusty I think as it's been a while since...

Hi, wanting to know if anyone has come across any code that stops the vba from running if an 'output to' function is null. I've found some code using the DCount function but I'm struggling to adapt this to multiple excel outputs, any help much appreciated. I'm sending 5 excel files via E mail...

Hi again Paul. A lad working with me is having a problem with code in Access 2010. The code keep failing with a n error message stating Error 3066 at least one destination required. Would you give a quick look to see if there's any thing obvious we are missing?

Hi Paul, It's working. Had to enclose all the body fields in () to get it to recognise it as a field and use my form to run the code. Works exactly how I want it to. Thanks for the help

Hi Paul, ?Tried everything I know just comes back saying that (Firstname) Compile error: External name not defined. The only think different about this is it is part of the mail body text!

Hi Paul, Took on board all your points and it works as it should barring one section. In the body of the E mail I've referenced the persons name in the query but it doesn't recognise it Any ideas? Graham

Thanks for that Paul I'll rectify that problem and give it a go. Did the rest of the code look right? i.e. the do While and the loop? Graham

Hi, Not used loop function before and I'm struggling to understand how to set it up on my code.All works but does scroll to next record and repeats the code. Any help much appreciated.;) Dim db As Database Set db = CurrentDb Dim recRework As DAO.Recordset Set recRework =...

Never come across this before could you expand on it as I'm struggling to understand what you refere to as X. Thanks

Hi, needing some help with a idea I have for my database but not sure how to . I have VBA to send multiple reports to a group of people depending on a toggle button selection. what I'm wanting to do is have it loop through the e mail process until all 5 toggle buttons have been selected and the...

Not sure I fully undersand what you mean! I have this working fine now but I still want to stop it E mailing out if the [FirstReminder] has a date in. Can you show me how I could do this? Everything I've tried it just ignores.

Hi JHB, Thanks for the reply. I very rarely use VBA but this is what I have now and using your advise I have added me. to the control and yes it is a field on a form, but it still gives me the same error!

Hi , Trying to send out some reminder E mails using some dates that I've set up in text boxes but can't get it to work. I've started out simple to get it working as I'm not familar with VBA If Me![Planned Finish] <= [2days] And Me![Final Reminder] Is Null Then MsgBox "YES", vbOKOnly...

Hi, Wander if any one has come across this before. I'm exporting a query that has currency values in with no decimal places but when it's viewed in excel it has 2 decimal places! I've changed the properties in the query to none, anyone know how to stop this from happening? I'm using 2003.

Unfortunately not as it's too big. If I can find the time I'll create a version just with the form and query in.

Hi, moving my database from 2003 to 2010 and I'm wanting to use custom tool bars that I created in 2003 to run searches Doing this I hide the ribbon, including the 'File' tab is this possible?

Hi, I have a search button on my form that filters the form via a macro and querie allowing you to fill in all combo boxes with your search criteria. I'm wanting to start the search from the form but it makes all the buttons in active when set. Is there a simple bit of code to make sure that my...

Even though the date was formatted it still returned zero for everything with both date fields populated. I've just tried CazB suggestion of =iif((Format([date received],"mm/yyyy"))=(Format([date of reject],"mm/yyyy")),1,0) and it works a treat.

Tried that it didn't work.