Search results

I am not sure what you mean. How do I use Image Control? Kind regards

Please find attached the PNG image that I have been using. Using it in Word gives a very crisp and clean layout, but in Access it gives a rather bitmap like and unprofessional appearance. Thank you for offering to look at this and I look forward to hearing from you. Kind regards

I am inserting an image into Access 2007 (it is a company logo) using the commands on the Forms Design Tab. The image should have a white/transparent background and if I choose Insert Picture in Word, it appears perfectly, but using either the Logo or Image command from the Design Tab, my...

It appears that I am falling at the first hurdle. The = before the first email address comes up as a compile error (Expected: list separator or ) ) although the system has let me change the Optional Byval information. Should I be passing the email address to the code? Just to recap, I have the...

Thank you pbaldy for your help and assistance, I will get it (try to get it) working on my home machine first and then I will probably need to post again to find out what I need to amend / find out from my clients when I install on their machine. I am sure I will be posting again for advice...

Thank you Spikepl for your advice which I am now about to start reading and trying to implement on my home machine initally, but what is the "linked microsoft KB" that you refer to?

I will have a look a the CDO script - I have never used it before. I am writing the code at home on Outlook 2012 on a non exchange environment It will be implemented on Outlook 2012 on Exchange Server 2003. Will I need to amend the code in order for it to run here and then when I load it onto...

Am I correct in thinking that if I revert to the first code then this will bypass the Outlook Security issue. I have posted another question about this and the reply mentions CDO. If yes, I will have another go at my first macro, if not then I will try the CDO route (haven't got a clue what...

I have successfully managed (with help from forums) to write some code to send a report to Outlook, but the security dialog box in Outlook keeps appearing requiring user intervention. I have found various bits of code on the system, but they all seem to be packages that you have to pay for. I am...

"problem solved" I have now finally managed to get the code to work - so for anyone who may have a similar problem in the future. This was my final solution Public Function ReviewDate() Dim TR As String Dim criteria As String Dim trnum As Integer trnum = DCount("[Date for Review]"...

Now that you put me in the right direction for getting the email to work I could experiment a bit further. I have since found the following code that sends the email. Public Function ReviewDate() DoCmd.SendObject acSendReport, "RptTrainingDueReviewDate", acFormatPDF, "abc@emailaddress", , ...

Thank you for the information about the quotes for the strings, the macro is now passing information to the VBA code BUT the code that I have is now giving a compile error. User-defined type not defined for the line Dim olApp As New Outlook.Application The full code which I placed in module...

I have set up a task scheduler to automatically run a macro to call a VBA script to email a report. I have set up the task scheduler as follows Action - Start a program Program/Script - "C:\Users\User\Desktop\CIS Database.mdb" Argurments -/x ReviewDate This appears to be working correctly as...

"Now in your form frmcontacts as part of the button to add a supplier put;"... thank you for your reply and I have incorporated the first part of your reply, but I am sorry, but what button are you referring to? - do you mean the field that holds the supplier ID as I do not have a button to...

I have a supplier form (frmsuppliers) where I add the information for new suppliers, I want users to be able to click on a button to open the contacts form frmcontacts in add mode with the name of the supplier that was shown automatically shown on the screen. The following code opens the form...

Thank you so much, it works like a dream. I have understood what you and smig have told me, so it has been a very useful learning exercise. You are both stars, I cannot thank you enough. For those that follow this thread in the future looking for help and advice, I have included the final...

As always it is the idiot in the driving seat who causes the problem. I have now managed to get the code working to send the order details to email. The correct information was sent and all in the right places - I could not have done it without your help, so thank you very much. I do however...

I have just realised that the code did not come out very clearly so I have posted my amended code again. Sorry about that Private Sub EmailJob_Click() Dim strMsgAddress As String Dim strSubject As String Dim strBody As String 'code to send email with job details DoCmd.RunCommand...

I hope I have got the syntax correct, but to clarify all the fields listed at the top are in a frmOrders with only one calculated field POnum and the fields in the ISNull statement are in a subform called frmOrdersItem, the last field being a calculated field. I am assuming that the fields...

Thank you VBAInet for clarifying that, I have managed to eliminate one error, so I will keep working through each control in turn to try and get the correct syntax. Thank you also smig for clarifying how to pass the information to the module - easy when you know how! Thank you both very much...