Recent content by jazsriel

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