Recent content by Nittylions

I have a program that I currently have linked to an access table. The only thing is that this program requires that you close it down and re-open it when the access table is updated. I called the vendor and they said in order to stop from closing the app down I need to create a "~" delimited...

I always make a back up when getting help from outside my mind. I'll ley you know how this goes.

So all I'll need to do is add the table for holidays and then copy in this code over my current code?

I currenly have a module set up to exclude weekends from 2 different dates. I now need to expand that to also exclude certain holidays and have no idea how to do it. It will normal be the same holidays every year. Any help would be great.

Here is what i want to do. I currently have a query created that will make a table. What I want to do is use that query and create a table daily without losing the prior table. For example I run the query to I would like to create a table entitled "Research_070708" then i want to run the same...

I got it fixed. I kept the same code that i had before. Here is how i fixed it. When the database was opened i had the form open automatically at start up and and the module was setup to start on load of the form. I went tools in the menu bar and also made it so it would show the database...

I removed the DoEvents line and I still get the error. SHould I breakdown this code or is there another way to get this data exported in one piece of code. :confused:

That worked but now the error drops to the the next line of code!

Smart, I need to export the query to excel so the management team can do their thing. I have the Module to run when a form is opened on start up. When i tested this i get the error but when i'm in the design view of the form and change it to form view it works fine. I don't understand what is...

I'm t rying to export multiple spreadsheets and reports using a module. When i run the code i get the following error: "RUN TIME ERROR '2046' The Command or acction 'OutputTo' isn't available now It works fine until it gets to section highlighted in blue. If i remove that piece...

Thanks i'll look into what you gave.

The company i work will not allow us to download programs off the internet. Is there coding i could in access that will allow emails to be sent?

pbaldy, Thanks for the suggestion were can you find the items you suggested. I have never heard of them

I'm sorry if a repeat a question that already been asked in this forum, but i could not find the answer to my question. I have reports that i want acces to email each morning automatically. I have created a sendobject macro. When the marco is run i get the following prompt "A program is...

I'm currently have a module set-up to run in the early morning to reterive production data from the day before. I would like to be able to the same thing but on a weekly and monthly basis. When this module is run on a weekly basis i would like for it to capture the data from the week prior or...