May 20, 2012 #1 DSFord Programmer Oct 3, 2006 4 CA On a form I create a new button and take options to run a query. It creates a macro to run the query I wanted. I expected to see a click event with: stDocName = "#04a my query name here" DoCmd.OpenQuery stDocName, acNormal, acEdit Thanks, Doug
On a form I create a new button and take options to run a query. It creates a macro to run the query I wanted. I expected to see a click event with: stDocName = "#04a my query name here" DoCmd.OpenQuery stDocName, acNormal, acEdit Thanks, Doug
May 20, 2012 #2 PHV MIS Nov 8, 2002 53,708 FR You may convert the macro to VBA if you prefer Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
May 20, 2012 #3 TheAceMan1 Programmer Sep 23, 2003 11,174 US How are ya DSFord . . . Surely [blue]"#04a my query name here"[/blue] is not a query name ... albeit even in a macro? ... See Ya! . . . . . . Be sure to see faq219-2884 [blue]Worthy Reading![/blue] Also faq181-2886 [blue]Worthy Reading![/blue] Upvote 0 Downvote
How are ya DSFord . . . Surely [blue]"#04a my query name here"[/blue] is not a query name ... albeit even in a macro? ... See Ya! . . . . . . Be sure to see faq219-2884 [blue]Worthy Reading![/blue] Also faq181-2886 [blue]Worthy Reading![/blue]
May 22, 2012 #4 merlynsdad Programmer Nov 18, 2010 175 US If you let Access convert the macro to VBA, you get very generic VBA. You may want to clean it up a bit so it's easier to read. If the square peg won't fit in the round hole, sand off the corners. Upvote 0 Downvote
If you let Access convert the macro to VBA, you get very generic VBA. You may want to clean it up a bit so it's easier to read. If the square peg won't fit in the round hole, sand off the corners.