Search results

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...

Thanks. working with Access is a continuing learning experience ... mainly thanks to Microsoft who keep changing things! checking the references when we update versions is something to remember for the future.

Indeed, the problem is in the references. I have compared the reference list in the "problem" database with another good database and the first thing I notice is that Microsoft Office XP Web components is marked as "MISSING" in the problem dbase, and omitted from the list in the good dbase. So I...

yes, what seemed to be a format problem now seems to be something more fundamental. I suppose the fact that all was fine with Access 2010 and the problem occurred with the move to Access 2013 should have flagged the problem, but I find that sometimes problems in Access are not that easy to find...

Thanks for your reply and continued help in trying to figure this out. I think what you say about 2007 being stricter than 2010, and 2013 stricter than 2010 probably is quite correct. It's a pity that MS don't tell us these things! The version of 2013 that I am using is via Access 365 which...

I created a new text box and put in it =Format([kwartaal begindatum],"dd mmm") kwartaal begindatum is Dutch for quarter begin date. when I open the report, I am asked to input the parameter value (kwartaal begindatum), that is okay. I input the date in the form 1/1/2015 and I get #Error if I...