Recent content by testing1two

Can you walk me through how to do this? I have written code in Visual Basic for Excel but Access is still new to me. Thanks

The plan is to have a macro cycle through all of my portfolios and enter date, region (US) only once. Otherwise I have to run the macro manually and wait for the prompts to enter the portfolio name and date and region every time for each portfolio (i have 22 of them).

I tried it with this code: And got the error. " You cannot execute a Select query" It looks like that the above is part of a larger "Update Grand Total" Query The expression: is in query: "f-3 Cumulative WARF All Portfolio" I don't have to enter any amount as it is calculated from the...

I got the parameters part for the 1st query. If I want to run the macro with several portfolios, I can use a loop to push all the parameter names (Porfolios: SAFP, ABCD, etc.) and keep the date fixed. Two other questions: 1. Is it possible to pass parameters through vba to a SELECT query...

Yes, I need another parameter (date 10/31/2014) to be passed to the same query. I also need to find out where is the code for the parameter placed in Access? Where do I put this?

Thanks for this. I found the Parameters in Query view, but where do I enter the "SAFP" and "10/31/2014" as parameters in this view? How can I ask the user to enter the date every time the macro runs. In this case the first date is 10/31/2014, Currency is US (everytime)? I would like to...

I have run the query without the parameter and it works fine. The name of the query is "A) Rpt Qry - Select Data Master". Attaching the database with some bogus data.

Looks like I solved the original problem but now I am running across another issue. My original program was created through Macro which works ok as long as I continue to type in the parameters for each recordset. here is the original code: When I try to customize the code with passing...

It's this line where it breaks: In the actual query, when I use the static value "SAFP" everything works fine. My query looks like this:

Hi, I have the following Visual Basic code which I am using to dynamically pass the parameters "SAFP" and date 10/31/2014 to the query: When I run the query, i get the error "Item not Found in this collection"