Results 1 to 2 of 2
  1. #1
    kennyritch
    Guest

    Pop Up Action to alter DB calculation field? (Access 2000 - VB 6.0)

    Hi Folks

    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,

    Kenny.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    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>

    Andrew Cronnolly
    Moderator VB/VBA & Word

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •