Results 1 to 2 of 2
2001-07-17, 07:20 #1kennyritchGuest
Pop Up Action to alter DB calculation field? (Access 2000 - VB 6.0)
I have created a Commission Report using Access and the calculations are based on historic sales as well as sales for the current month.
In one of my fields I have a Control Source set to
=IIf([dateBank] Between #01/07/01# And #31/07/01#,[comInitial],10)
Now and again I need to change these dates to a different month. Is it possible to create a pop up box using VB that asks the user for the 'between dates' i.e. 01/07/01 and 31/07/01 as soon as the Report is opened and for these values to then be entered into the Control Source?
It would be somewhat easier for the user as opposed to having to edit the Control Source in the Report directly.
Cheers for any help you can give me,
2001-07-17, 08:46 #2
- Join Date
- Feb 2001
- Dublin, Ireland, Republic of
- Thanked 0 Times in 0 Posts
Re: Pop Up Action to alter DB calculation field? (Access 2000 - VB 6.0)
All replies to this thread should be posted to <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=54895&page=0&vie w=expanded&sb=5&o=0&part=>a duplicate post on the Access Board</A>
Moderator VB/VBA & Word