Recent content by RabSwinney

Also I would like if possible a pop up box for the user to insert the mail recipent, please help!!

Im having an issue with one of my databases when trying to email, we now use Office365 which I cant autoemail from the database, how can I change this code to sens using SMTP Function Mcr_Send_New_Supplier _SendVendorRequest() On Error GoTo...

Hi There, I am trying to email a word document from a server, I wish to do this within Microsoft Access from a form with a button. Is there easy code for this?

Done the trick, thanks again

I run this with others when the database opens Function Send() On Error GoTo Macro1_Err DoCmd.SendObject acQuery, "Qry_Detail Hierarchies", "MicrosoftExcelBiff8(*.xls)", "bbbbbbbbb@bbbbbbb.co.uk", "", "", "Detail Hierarchies", "", False, "" Macro1_Exit: Exit Function Macro1_Err...

Hi, I send out queries in excel format daily from access. The problem I am having some of the queries might return no data (Blank Sheets) How can I set up to auto send queries but only if there is data there (Non Blank)????????

Hi, I need to automatically print Access Reports to PDF and publish on a network server, I have Adobe Acrobat 6 Pro and I have it as my default printer. I am new to VB so can you go easy on me if you are giving me code.

Is there any way I can convert Access Reports to PDF and send them to a local Intranet Automatically?

I Have have a query being exported to microsoft excel, the problem I have is the decimal places are not the same as I have in access, I have the data fixed decimal places. Thanks

Hi There, how can I get a module to run automaticaly, can you have a look at my code and tell me what I need at the start. I will use the module with the Autexec Macro. Sub run() DoCmd.OpenReport "Rpt_GB01 Ex Pefc and Fsc", acViewPreview, "", "", acNormal DoCmd.SetWarnings (False)...

I have two tables in my database, one for customer details and one for products, when entering data into a form I have the customer data then a subform with users entering products. When I am in the query I want to copy and paste some rows of data then change a few details, the problem is when...

Tools, Startup is blank in my database. HELP!

Help! How can set up a parameter query, instead of the parameter box coming up asking for the parameter, I can bring up a combo box so the user can pick from a list to run the parameter?

Im trying to add and subtract months within text box,s just say I have a text box with the function =now() with mmmm format giving me January what I want is to be able to do another text box taking one month off but I dont want to use days like =now()-30

Remove Security all together!