Search results

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!

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.

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

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