Search results

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

That worked. I was making the mistake of putting the file name in quotes. Do not put the file name in quotes and then it works. Thanks!

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

That was one of the conclusions I had thought of as well. If that is the case, is there anyway to prevent this type of occurrence from happening?

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

Yes, that's what I am using. When new records are inputted it is done on the front end and then the linked table manager stores it in the backend tables. On the front end side now I would like to have an update form where the user searches for a record, it populates the form with what currently...

I am using an Access Backend. It is a relatively simple database and system with not much data held in it.

Hi All - I have a form in my front end database that is supposed to allow a user to search for a record based on account number and then make changes to the that record and for it to save in the back end database. I have the search function working where it populates different input boxes on...

Sorry, I just realized I did not include in my original post that my ribbon is in Excel. The backend database is saved out on our shared drive and no one except for managers use it. Analysts use the front end ribbon to pull form the database and make edits to the data. So I would need something...

Thanks for your reply, Gemma. I'm not familiar with usys tables. What are those? The ribbon we've built was built with an XML editor and it uses VBA and SQL. Thanks again.