Recent content by William86

OK, yes, I understand. In my case the X:\ drive on the Server is mapped on the local machine, but I will try \\Server\ instead. thanks for the advice!

Thanks, I will try it!

OK, but I DO want to change the folder from the current folder on the local machine to a network folder on the Server? at the moment I change the directory for the save folder to what I want on the Server and then do "SaveAs" which works fine other than it is in C:\documents instead of the...

Sorry, I forgot to mention that I am using Excel 365 on Win8.1

I receive spreadsheets from various sources (via email). Once received and opened I use VBA to add a timestamp to the xls file name and then want to save them all to the same folder location on the server using a network address ... for example "X:\central\excel". I run this from a workstation...

The query extracts data from a TABLE, the only thing is that each time period concerned has its own TABLE and to distinguish one from another the table has a number. what I need to do is input the table number so that the query can go to the correct table.

Ok, thanks, I understand ... although the database I am using is about 15 years old and I have 44 of those tables. It has been added to over the years and I don't want to do a complete rework!

I am using Access 365. I have a query which can be used with a large number of tables, each table being named TABLE plus a number. I don’t want to duplicate the query multiple times with a different table name. Is it possible to have an input box which opens when the query is run to ask for the...

I am surprised this seems to have no simple answer, so I will think of another way of doing the task, please regard this thread as finished!

thanks for your reply. I tried changing the SET ORIGINAL LINE line to ActiveExplorer and Active Inspector (I don't really understand the difference) but that didn't work. Also, I tried changing the SET ORIGINAL LINE - "Selection" to "CurrentItem", but now I just get an error all the time. Sub...

I am not very experienced in using VBA (I mostly copy what has been done before). I have an Access365 database which does my accounts and creates a REPORT which is an invoice. Then to email the invoice I click on the email icon in my quick access toolbar and I have a blank email (in OUTLOOK)...

Thanks for your reply. I am an amateur with this and although I more or less understand what you are suggesting, it is far beyond my ability to actually do it. Is there an easier way of doing it with a macro?

I am using Access 365. I have a report listing transactions, grouped on different offices. Each group starts on a new page via the "force new page before section" property setting for the group header. The group header contains the labels for the headings for the data fields in the detail. The...

Thanks for your reply. I need to send a report (which is actually an invoice made by the dbase). With EMailDatabaseObject I was able to convert the report to pdf, then email that. With the code above, I assume it emails the file that is "c:\folder\file.zip" as an attachment so to get this to...

I have been having the same problem! My database was made in 2013 with (I think) Access 2010. I have a series of macos that use EMailDatabaseObject. Recently I upgraded to Access 365 which I assume is the same as Access 2013, but I get the error message 2293. I first tried just copying the macro...