Search results

:D:D:D:D:D:D:D Perfect solution Thanks

Thank you over 4 years late;) I am surprised that Form_frmName.PublicSubName(anyVars) works but it does. :D I have not used Form with an underscore before, ! or . but not _. Access.....:banghead::banghead:

DUH! :banghead: I cannot believe I fell for the old "paste code and forget to setup event" trick. AGAIN Added OnClose as Event and everything worked.

Thanks Rachael The Chart Object and OnActivate was the trick for me to modify my chart within Access Forms Thanks

Thanks everyone, this solves my problem of our upcoming conversion to 2007 ( I know, I know 2010 is out) and still using Send keys, i.e. SendKeys "{down}" SendKeys "{enter}" Here is what I use with two combo boxes, the second is a function of the first and if there is only one item in...

Re: Sort (then Re-sort) by form header, Access Ok, I have it working and it is much easier than that what I was using. I use F1 to F5 (have five Column Labels) and I declare them globally. I then reset all the F? to False for all the other filters when I click sort. This ensures that when I...

I want to try this as it appears simpler than what I am using from the sample database. but I do not see where "F1" is declared. What is F1? Is F1 Global, how would it effect a different column label's code? Where is the Boolean sortFlag utilized? Is sortFlag the same as F1? Maybe I just am...

Excellent. Just Change the non "Order by" query source in the module header and the field names in the On_Click and it works! Absolutely Brilliant. Thanks:D

Thanks PBaldy as the link from MS http://support.microsoft.com/default...b;en-us;209203 worked perfectly. The trick utilized in the example is to create a queryDef and assign it the query you are trying to run. Next assign to the queryDef each of the parameters, just like in the query...

Thank you Keith, that worked for me!:D

Re: Running Total w/out storing & using Dsum?? I have found that out but I need to create the running sum as I am attempting to create "On Demand" Charts which plot the "Planned date" vs the "Actual Date" as a percentage of the total. So 20% is 9/12/08 and 30% is 9/30/08 etc up to 100% over the...

Re: Running Total w/out storing & using Dsum?? I could never get DSum to work with my query with Dates but this works GREAT! 6 and 1/2 years later and the post is still helping! You may never get this but Thank You RICH!

Thank you It's been over seven years since this post but Google found it and it solved my problem. thanks.:)