Recent content by martinw

thank you Rich I'll try that

Rich, I want to keep track of hours spent on a project. When 1.5 hours are reached I need to print a report and pass the information into a table to keep for historical purposes. Then the counter time is reset back to 0 until the next time work is done on the project. Martinw

Can data in a report be passed onto a data entry form? I need the results from computations that take place in a report to be passed un to a form to put that data in a new table for archive purposes. I know it will require coding, but can anyone help me out with the coding aspect. Thank you...

Passing report data reply Pat, Thank you for your suggestion. I will try and find the coding to do this. The reason I wish to di this is maintain historical records of the time spend per day. Thanks again for your assistance.

Can data in a report be passed onto a data entry form? I need the results from computations that take place in a report to be passed un to a form to put that data in a new table. Thank you in advanced for your assistance. martinw

Field Question I am designing a data base that keeps track of time spent on a particular project. I have set the field up formatted to HH:mm but Access wants to treat it as clock time (i.e. 1:30 pm) instead of 1 hour and thirty minutes. Where am I going wrong?? Thanks in advanced for your help.

Make sure the fields are set up as numerical and not text. Then if the field names are correct, it shoud give you a decimal number providing the field that houses the result is numerical with a decimal place of what ever you require 2,3,or 4 etc.

I have created a form called selectiondialogfrm with a list box called lstComplanies that is a multi-select. As I click on the names in the list box, they are displayed in a textbox called txtSelect. What I want to do is to Print a seperate report for each name selected. Any help would be...

It does not work. It is now passing "#Error" for any count whether it is null or not.

No, In the absentee report textbox I have a "0" which is what I want. But when I pass that value to the Reportcard report it comes across as a "#Error".

I have created a report called Reportcard that gets information from 2 other reports (one, absent, adds absentees and the other, tardy, adds tardies). I am using the following: =IIf(Nz([F1])="","0",Count([F1])) to count the records. This works great and gives me the values I need in a text...