Completedness
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 54 articles for 0.287 sec
If I read your original post correctly, you have about 7 steps. You will enter the 7 records in the Step table just once. When you enter a new person, the PersonID autonumber is assigned automatically. The 7 steps are then entered in the subform. There are a couple of ways to do that. One would be to use a combo in the subform so the user can enter the 7 records (for the 7 steps.) Another     

Group: microsoft.public.access.formscoding · Group Profile · Search for Completedness in microsoft.public.access.formscoding
Author: Allen Browne
Date: Sep 14, 2008 21:00

bhicks11 via AccessMonster.com wrote: Oops - sorry. Should have given you a report solution. Make your text box Control Source calculated with the following: =Iif([orders].[completedate]-[orders].[ordersdate]>90,"Yes","No") Bonnie http://www.dataplus-svc.com bhicks11 wrote: Hi Pau: Here's the SQL: SELECT "Yes" AS TextField FROM Orders
Show full article (6.97Kb)
The button was already there so now I just made it invisible. Although I need to do something similar on another database and will use your suggestion in place of the button. Thanks Ken, appreciate the advice!!! "Ken Sheridan" wrote: > Why have the button at all? Why not just put the code in a function in the > form's module and call that in the controls' AfterUpdate event procedures     

Group: microsoft.public.access.reports · Group Profile · Search for Completedness in microsoft.public.access.reports
Author: paul
Date: Jul 27, 2008 10:23

Why have the button at all? Why not just put the code in a function in the form's module and call that in the controls' AfterUpdate event procedures? Ken Sheridan Stafford, England "Stockwell43" wrote: Got it! I used the Call cmdTurnTime_Click in the AfterUpdate event of both fields. Thanks Guys, I appreciate your help!!! "Jeff Boyce" wrote: Are you saying
Show full article (1.05Kb) · Show article thread
Got it! I used the Call cmdTurnTime_Click in the AfterUpdate event of both fields. Thanks Guys, I appreciate your help!!! "Jeff Boyce" wrote: > Are you saying that after a user updates one of a couple of possible fields, > you want to force the user to click (another) control? > > If so, why? (as in 'why force the user to do something that you and Access > already know needs to     

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Stockwell43
Date: Jul 23, 2008 08:31

Hi Jeff and Ken, Thank guys for responding. Yes, I want the user to click the button after the date is inputted in one of the fields. The users have a habit of going to another record and not hitting the button which throws off the elapsed days because either the days are incorrect or there are no days at all. The button does a calculation based on the date. So when Original date is
Show full article (1.74Kb) · Show article thread
Are you saying that after a user updates one of a couple of possible fields, you want to force the user to click (another) control? If so, why? (as in 'why force the user to do something that you and Access already know needs to happen?') Another approach might be to have Access "click" the button after either of those fields is updated. You could use the AfterUpdate event for each/both     

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Ken Sheridan
Date: Jul 23, 2008 07:35

It depends whether you want the button to execute something before or after the OriginalDate or CompleteDate controls are updated. If the former you'd need to declare a module level variable to determine whether the user has already clicked the button, e.g. Dim blnGoAhead As Boolean Then in the button's Click event procedure set this variable to True if the procedure executes successfully
Show full article (1.41Kb) · Show article thread
"Stockwell43" <Stockwell43@discussions.microsoft.com> wrote in message news:D0AD831F-4B28-46D7-8AEB-3381E86AE3C0@microsoft.com... > Hi Clif, > > That seemed to work and so far everything works as I need it to. Great! > > Thank you for your help!!! You're welcome. -- Clif Still learning Access 2003 > > "Clif McIrvin" wrote: > >> You had: >> >> > If Me.CompleteDate     

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Stockwell43
Date: Jul 22, 2008 11:25

Show full article (1.12Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Stockwell43
Date: Jul 22, 2008 11:21

Show full article (2.37Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Jeff Boyce
Date: Jul 22, 2008 10:41

Show full article (0.90Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Ken Sheridan
Date: Jul 22, 2008 10:38

Show full article (1.75Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Stockwell43
Date: Jul 22, 2008 09:15

Show full article (0.21Kb)
    

Group: microsoft.public.access · Group Profile · Search for Completedness in microsoft.public.access
Author: Clif McIrvin
Date: Jul 22, 2008 07:54

Show full article (2.18Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · next