Search results

This problem was solved in another post I made HERE. So thank you arnelgp.

Thank you all for the help on this and being patient with my lack of knowledge. These solutions do accomplish what I was trying to do, thank you.

I am not sure how to call a function with a string in parenthesis.

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

I do see it. I was playing around with it a bit it seems to work flawlessly. Better than what I was trying to accomplish before. I am about to leave from work in the next few minutes, so when I am back after the weekend I will integrate it into my live DB. I will say this is tentatively...

Yes that is correct.

Okay here is the DB i was trying to upload. Sorry it took a few minutes there is a lot of information that had to be removed (privacy reasons). Anyway, I know I probably do not do the naming correctly as some people have told me. But it works for what I need. Now if you click on the button the...

Well, what I need is to select the 2nd month with complete date range enabled. give me a minute I will upload, but I see what the Demo is doing.

I am going to upload a DB here shortly, just removing the things that I am unable to share.

I see the editing. I am trying to figure this out but now it just gives me a syntax error. It says "Syntax error in FROM clause." I am trying to go to from SELECT TOP 2 tblRecap.*, SELECT TOP 1 * FROM (SELECT T.* FROM (SELECT TOP 2 * FROM tblRecap) AS T ORDER BY T.ID DESC) or is it SELECT TOP...

I am trying to see how this works in SQL, but when I try to save it gives me an error on this part... SELECT TOP 1 FROM ((SELECT * FROM (SELECT TOP 2 * FROM yourTable) ORDER BY [AutoNumber] DESC)) It says "The SELECT statement includes a reserved word or an argument name that is misspelled or...

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?

Minty, using the information/guidance you provided, I was able to get the reports up and running the way I needed. Thank you. Pat, thank you for the response also. I will take a look at the example you provided and see if I can use it.

Ah ok. I see. Once I am back at work tomorrow I will look into these changes that need to be made. Thank you for the quick reply.

Okay it is kind of working. I am running into a bit of a problem. If you input a date in the format as the date picker lets you in Text box 131 then hit the Command130 button it will open up 2 reports in print preview. The coversheet form is working correctly because it recognizes the date...

I was basically opening each report with its own button on a form, then using the criteria from a query the user would have to input the date desired. But that takes up 7 buttons and a lot of user input. I am trying to get it down to just 1 or 2 buttons max to minimize the user input needed...

I see what you did there, but there is going to have to be a lot of sizing and modifying the sub-reports to make them fit into what format I am looking for. I appreciate what you did and the time it took you to modify this example. Thank you. I will hold onto it for future use. I am still...

Once I am back at work tomorrow I will take a look. Thank you. Yes the error is no big deal. I know where it is coming from. This is from my actual database, just lots of things removed for privacy reasons.

It was working for almost 2 years, until this month it stopped working. It would process all the reports, and then it would remove all the extra ones. I have no idea why it stopped working.

Yes, you are correct that the folder I needed to close is identified by path. This also solves the issue I was having. Thank you. I will mark as solved.