Search results
-
A
Automatically emailing a Access report once a week
Actually, that is also solved. Things seem to be working as expected now so I will do some proper testing -
A
Automatically emailing a Access report once a week
Problem solved. It now exports to a PDF, but the application stays open afterwards. Can it be closed from the macro? -
A
Automatically emailing a Access report once a week
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. -
A
Automatically emailing a Access report once a week
Right, I have the code being called by the macro and run from the command line, however, the macro fails with error: 2950 -
A
Automatically emailing a Access report once a week
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 -
A
Automatically emailing a Access report once a week
Anyone have any thoughts? -
A
Automatically emailing a Access report once a week
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... -
A
Changing the properties of controls at runtime
Problem solved, it was the trusted location issue -
A
Changing the properties of controls at runtime
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? -
A
Changing the properties of controls at runtime
It is using the me and it still won't work. The correct command button is calling the correct piece of code.:confused: -
A
Changing the properties of controls at runtime
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! -
A
Changing the properties of controls at runtime
I just have this code for the event "On Click" for the command button: Private Sub cmdEditRecords_Click() tabComponents.Visible = True End Sub -
A
Changing the properties of controls at runtime
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... -
A
Automatically emailing a Access report once a week
Is there a different set of instructions for thunderbird? -
A
Automatically emailing a Access report once a week
Brilliant, thanks for your help -
A
Automatically emailing a Access report once a week
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" -
A
Problem counting and storing records
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 -
A
Problem counting and storing records
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 -
A
Problem counting and storing records
The control source is: [qry_Project_Time]![Proj_Completed] -
A
Problem counting and storing records
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