Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem concerning Time
The code should be written in the Code Builder. The easiest way to put the code in the proper place is: (and please don't be offended if I sould too simple) in design view of the form, select the TimePurchased text box control, in the properties of the control click on the EVENT tab, in the...- oltremari
- Post #11
- Forum: Microsoft: Access Other topics
-
conditional background color ?
Check out the following link to the Access Web (an excellent site) http://www.mvps.org/access/forms/index.htm there are a couple of articles here that address your question of conditional formatting of continuous forms. This can be done with no actual coding. I believe that all of the...- oltremari
- Post #2
- Forum: Microsoft: Access Other topics
-
Problem concerning Time
JPhillis, What version of Access are you running. No there is not a "compiler" for Access in the sense that you can create an executable from an Access database. There is a debugger which allows you to examine/monitor the execution of your code. You can place a breakpoint on the...- oltremari
- Post #9
- Forum: Microsoft: Access Other topics
-
Problem concerning Time
In your modified code set frm=forms(Calls) should read set frm=forms("Calls")- oltremari
- Post #7
- Forum: Microsoft: Access Other topics
-
Problem concerning Time
Could this not be handled easier using the NZ function which converts null to zero? Also you do not have to create a form object to reference a control on another form. Try this... Private Sub TimePurchased_AfterUpdate() me.TimeAvailable = NZ([Forms]![Calls]![TotalTime])-...- oltremari
- Post #6
- Forum: Microsoft: Access Other topics
