Search results

  1. J

    Solved Removing Attributes

    Hi, Is there a way to remove read only attributes from all files in a folder using VBA? I found this code and it works but only if I point it to a specific file. My file names are constantly changing in the folders I need to remove these from. Dim fs As Variant, f As Variant Set fs =...
  2. J

    Solved Using SQL to select only 2nd record

    I know there is a way in SQL to SELECT TOP 1, and if you want only the first 2 then it is SELECT TOP 2, etc... So here is what I want to know, is there a way using SQL to select only the 2nd record instead?
  3. J

    Solved Removing pages in report with Module

    Hi, I know I have several problems I am working on at once, but each time a new one comes up it is more pressing than the previous one. Right now I am using the following code in a database...
  4. J

    Solved 7 reports 1 or 2 buttons

    Hi, I am curious if what I am trying/wanting to do is even possible. The usage of the following s for pulling up historical records. I have 7 reports and the only thing they have in common is the date of each report. 5 of the reports are date specific, and 2 of the reports are for the...
  5. J

    Solved Closing specific folders using VBA

    Hi, been awhile since I was on here. Right now there I am on the last part of my current project and I have no idea how to solve my problem. I have a specific Windows folder that I need to close when a button is clicked on a form. I have 0 code on how to accomplish this. Basically, a blank...
  6. J

    Copying all folders and files from one location to another

    I have been scouring the web and forums and am unable to find anything to my issue. I am in need of a way to push a button on a form and have it copy all files and folders in one location and then essentially paste (generic MS term I know) them to another location. The only way I know how to do...
  7. J

    Delete before date that is continuously moving

    Okay, I am not sure if this belongs in the table section, but it is dealing with the data of tables. I am looking for a way to click a button and have information from a table deleted if it has been in the DB for more than 3 years (not sure the time frame yet, but lets just go with that for...
  8. J

    Solved Multiple search criteria using queries

    Hi, it has been awhile. But I am back with a question. I have seen DBs where someone will implement search queries, using wildcards and like on the queries. However, I am trying to do this with multiple search fields on a query. I have had no luck but hoping someone can give me some ideas or...
  9. J

    Solved Report dynamically adjustable labels and text boxes

    Hi folks. I am wondering if it is possible to have dynamically adjustable labels and text boxes based upon what is in the text box field on a report. So on the DB I have attached I have 3 boxes, first is a label with data that will never change, then the date field which will change monthly...
  10. J

    ...

    ....
  11. J

    ...

    ...
  12. J

    ...

    ...
  13. J

    ...

    ...
  14. J

    ...

    ...
  15. J

    ...

    ...
  16. J

    ...

    ...
  17. J

    ...

    ...
  18. J

    ...

    ...
  19. J

    ...

    ...
  20. J

    ...

    ...
Top Bottom