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

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

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

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

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

Hi All - I have been trying to come up with a solution for a problem I am having for a while to no avail. We have a backend database that stores various tables full of data. We then have a custom Excel Ribbon that connects to the database and pulls in the different tables depending on the user...

Hi - I have a function in the backend of my database that when executed is supposed to create a backup in the location that I have specified on our network drive. The code was working well until I put a password on the back end database. Now when it runs, I receive a run-time error #70...

Hi All - I have a module that is in Excel that is connecting to a back end database. I am trying to pull data from a table that meets a number of conditions. With the following statement, it is not returning any records,even though I know there are records that meet all of the conditions. I...

System error "&H80040111 (-2147221231) Class factory cannot supply requested class In my company we have built a custom Excel add-in using Excel 2007. We have 2 virtual environments that different computers are operating in - 1 is in Windows 7 and the other is Windows Server 2008 R2. Both are...

Is it possible to publish a database built in Access 2007 to a SharePoint 2010 site? I tried to go to file, publish, document management server, and then enter in the address of my SharePoint site but I get a message saying the database can not be saved there. Is this a compatibility issue or am...

Hi Forum - I have tried numerous searches for this topic but can't find anything specific for Access 2007. I would like to be able to write a script in my Access 2007 database to create an automatic backup in a specified folder at a specific time each night (i.e. 9 pm every night) and delete...

Hello - I have a table in Access that I have a form saving new records to. Before this save occurs, I would like Access to check if the account number already exists and if the account does exist if it is outstanding. If both of those conditions are met I would like a message box to display...

Hi Forum - I have a module that saves a worksheet to an Access database. That part is working. Now I would like to add a couple of controls into the module to check for correct values. There is one field "Request Status" that is updated by the user as well as a "Last Modified Date" field that...

Hello - I have a form in my Access database that has 3 input boxes by which a user can locate a record by. The problem I am running into is that I can not get a nested IF statement to work properly to first check which of the search boxes are filled in and second search by whichever is filled...

Hi - I have a database I am trying to build out where there is a main page where the user selects various buttons to import files on a monthly basis. In addition to importing files, on the main page I have created a combo box that has a drop down menu where the user is supposed to select the...