Recent content by msyth2

I am new to vba in general but I have a feeling I will need to use a lot of Access and Excel. Its great that I found this place. Great forum and people are very helpful!

Thank you vbaInet too for your post. Your code is very close to what I actually was trying to get :) Except I had to use Outputto(report) to save the file as .rtf. I was a little confused about LBound/UBound but I do see now for this case it's the same thing as "For Each In". The number I...

It works very well, thank you so much. I am still wondering, is there a way using "For Each i In"?

I have a set of numbers, say (1,3,5,6,8,11) I need to use each of them one time in a sql where clause and print report seperately. I also need to use them as part of my exported file name. How do I loop based on those numbers? Thanks in advance.

The actual column name is "FM" rather than Month, but I do see bob's point. I went ahead and tried '05' again it worked this time... Maybe because I cleaned out the table name in table.column. Thank you all for your help.

it's in a string then assigned to Querydef

bump to look for help :)

Re: input box to capture nubmer as text for sql ty very much. i thought it would work too... but now in the error displaying sql statement, it's like '05' ... it doesn't make sence.

I have code like this Dim Mon as string Mon = Inputbox ("Month","Month") sQL = .... & _ "Where Month = " Mon If I enter 05 in input box, it always caputure number value and sql has error, because in the table filed "Month" is text "05". How can i make it capture text? I tried use str()...

What if I need to export them to file? if I use outputto, there is no filter arguement. thanks. Sorry for shooting misellenous questions one at a time, but how do i set up a set of number, then loop while using the number in their as variable? can I do things like set i in (1,2,3,4,5) for...

Thank you so much for reply. If Im understanding currently recordset is cutting a portion of a table for use? And how do I associate a report to this macro? I created the report based on a hardcoded sql, otherwise i dont know how to create those fields.

Could anyone help me on the following scenario: I have a TABLE_A containg fileds such as Division, Year, Month, Amount How do I set up a macro that can exort a few reports seperately based on divison variable? I am thinking about a structure like this: -enter non-loop variable - Year...