Search results

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

I will give that a try now then. Thanks :)

The VBA that opens the backend is stored in the Excel ribbon code (data manipulation) and the front end (data entry). The code in each of those tools opens the backend to create the backup when a change is saved. Having those two tools though copy the backend and paste to a new folder is a...

I am able to copy and paste manually while it is open, but the code still will not work for me. The backend does only contain tables and the queries are stored in the front end. The reason the back up function is stored in the back end is because a lot of the data manipulation is occurring via...

Hi CJ, thanks for your reply. I corrected those two errors and I am still getting a permission denied message. Is it possible that this error is occurring because I am trying to copy the same database that the code is running in? Meaning the code is running in the backend of the database and...

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

Thank you! That seems to have fixed my problem! :)

There really isn't any point. There are other queries in the module though where I am using today's date so I thought it would be easier to assign a variable to the function.

That is the dt variable that I just assign earlier in the module. I will try the format function and post back on if it worked or not. Thank you for all of your help :)

I do use the date function when running it in VBA, but it still does not work. Any ideas?

Which part of the date criteria is off? When I use the SQL query is VBA the date itself (i.e. 7/3/2014) is substituted with a variable "dt" so I think it should automatically be in the same format if it is just the standard Date function, right?

Yes, if the criteria is removed, it returns data. The following query I created in Access and it pulls in the desired records. However, when I paste it into my VBA code in Excel it does not return anything, including the data headers. What am I doing wrong? SELECT tblsojrol_oc.[Today's Date]...

Thank you for your suggestions. When I paste my SQL statement in Access nothing is returned, meaning I have something wrong with my criteria. Am I adding days correctly in the SQL statement? I've never added days to a date before so I wasn't positive how to do it. Thanks again.

Yes I have Access to the database. Earlier in the module I am opening the connection to the database with ADO. The headers of the table pull in, however, no data comes through so I assume something is wrong with the query logic.

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

Re: System error "&H80040111 (-2147221231) Class factory cannot supply requested clas Hi - sorry for the delayed response! I am not 100% positive of what version of Windows 7 we are running because everything is pretty locked down on our computers by the system administrators. I did try to...

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

RainLover - In thinking more about it, I could just have the backup program running on my machine to create a backup somewhere on the shared drive, correct? Not everyone's computer would need to be creating a back up. Can you help me out though with the AutoExec script that you reference? What...

That makes sense. My one remaining question is you mention using Windows Scheduler to fire the auto back up. Would that have to be set up then on every computer that is using the database?