Search results

  1. N

    Question Creating a .DAT file

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

    Removes Holidays from Date Diff Cal.

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

    Creating a table with VB

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

    VB help needed!!!!!

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

    Auto Email Report error

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

    Scheduled task.

    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...
Back
Top Bottom