Search results

Actually, that is also solved. Things seem to be working as expected now so I will do some proper testing

Problem solved. It now exports to a PDF, but the application stays open afterwards. Can it be closed from the macro?

I went down another route and now I just create the PDF files and save them to a location. But the macro that calls the code to do that is failing.

Right, I have the code being called by the macro and run from the command line, however, the macro fails with error: 2950

The code works fine itself when executed from a command button. ( I took the "-" out) The problem I'm having is getting that code to execute from a macro, or by calling the macro from the command line

Anyone have any thoughts?

After a couple of days trying to get this to work, I decided that instead of emailing the report, I will fire off a script that exports it to a PDF and then use Python to email it out. However, I am struggling to get this to automatically export to a PDF file via the command line. I have tried...

Problem solved, it was the trusted location issue

The message box doesn't launch either. There is no other VBA code at all in the database so far. How do I go about setting the DB to a trusted location?

It is using the me and it still won't work. The correct command button is calling the correct piece of code.:confused:

Yes it's on the same form. it's a modal form trying to hide the tab control. The code seems fine, but it will just not execute when I click the button!

I just have this code for the event "On Click" for the command button: Private Sub cmdEditRecords_Click() tabComponents.Visible = True End Sub

Hi, I'm having trouble with what I thought was a very basic operation with one of my forms. Because I have had to revert back to Access 2007 from 2010 I have lost the ability to use the shiney new Navigation bar feature, so am having to do this manually via a few command buttons. I have...

Is there a different set of instructions for thunderbird?

Brilliant, thanks for your help

Ok, so I have the following: msaccess.exe E:\user\Documents\Project.accdb /x mcr_Email_Project_Overview This works fine, however, when I run the batch file, I get an error with Outlook which I have attached as an image requiring me to manually click "Allow"

Bingo, it's all slotted together nicely. Thanks for your help. I just need to be able to fire off some reports via a macro and it will be complete

Ah I have it now, I was missing the field from the query that the form was using as a source. The only problem I now have is that the number of decimal places is far too manu despite me setting it to 2 in the text box properties

The control source is: [qry_Project_Time]![Proj_Completed]

I added a text box onto a report, and tried to set the record source to that field in the query. But the query is not recognised as a valid field