I've been struggling with this for some time now and have tried multiple solutions. I have about 20 linked tables to Excel and would like to have those automatically copy over to local tables, replacing the data that existed from the prior month in the local tables. Reason being that I have...
I have a table that contains the discount rate and cash flow for about 20K assets. Curious if it's possible to calculate the NPV for each of those properties and have it print in the table? It doesn't look like there's an NPV calculated field in the version of Excel I'm using and have tried...
This is the solution that worked for me. Taken directly from the thread linked above by jdraw.
Paste this into your module within Access.
Sub SFTPGet()
Dim strQuote As String
strQuote = Chr(34)
Dim strSFTPDir As String
strSFTPDir = "c:\program files (x86)\winscp\"
Dim strCommand As String...
Thanks so much. This solution seems to work. I actually saw this earlier and it didn't work but after I re-looked at it from your post I noticed that within WinSCP there is the ability to generate a URL which I used and it worked. For those looking at this in the future, make sure to include the...
Hello: I am trying to develop a module within my Access database that once triggered will connect to an SFTP site and download a specific file onto my local drive. I've tried a number of different solutions I've found throughout the forum but can't find anything that works. I am using Access...
In doing a re-read of the post I was able to answer my own questions! So please disregard those previous follow-up questions. I do have one question though. If I want to automate the process of changing the text file name using VBA is that possible? So for the administrator I could give them a...
Thank you for the link, that looks like a viable solution. I just have a couple follow-up questions...Not sure if you would know the answers though?
- Do these forms get placed in the front end database or the back-end?
- Where does that text file get created to let the code know that there...
Hi All -
I have a database stored out on a shared drive at my company that multiple users connect to via a front end application that they save on their own hard drives. Recently I have noticed that the back end database keeps getting opened exclusively which prevents other users from being...
What I ended up doing was adding an additional field to the end of the dataset when the user imported the table into Excel that said "Save Updates" with a drop down in each cell to identify the records that the user wanted to save. So far, it seems to be limiting records from getting saved over...
Thanks for your suggestions. The way the database is constructed is multiple users could be making edits to the same table at one time. Within the Excel ribbon where people are importing data from Excel I included multiple different options for imports (people can import closed accounts, open...
Hi All -
I have a back end database that a number of people are working with using an Excel add-in that imports and edits records saved in the backend. Occasionally, when a user will update a record at first it saves to the backend but then an hour or two later, the changes made disappear. We...
Yes, the form is based on the backend table. It is populated through a lookup by the primary key ID field.
I actually was able to get it to work through using a filtered recordset where the ID on the form equaled the ID on the backend.
Thank you for your help!
Sorry maybe I'm not explaining it properly. So the user first puts an account number into the form. They press search. The other fields on the form populate with what is in the backend. The user then makes updates to the different fields and then presses a "Save Updates" button. Those updates...