Search results

Thats odd I had to modify yours to =Sum(IIf(Not IsNull([DISCLeavel1]),1,0)) but it worked. Doesn't make sence to me but this will do. Thanks a million for the help.

The Control Source if I put =Sum in the place of =Count it works.

I want to count the # of fields in a report that have data like you would in a SUM field. In the Control Sourse I have =Count([DISCLeavel1]) but I get an error when I preview it...can any one help me with this.

Thanks CEH...that worked but I also had to put the Watch as "Watch". Thanks for your help. Still learning.

This is what I have in another field to put a date in: Private Sub Checkdone_AfterUpdate() If Checkdone Then Me.Date = Date Else Me.Date = Null End If End Sub and works great but I want to replace the date with Watch. Any ideas

Thankyou for your responce...please explain.

I have been looking for 2 days for this info and have been unsuccessful. Can someone direct me to a post or help me with this problem. Bottom line…I have a field from a table on my form, I want to make a checkbox to fill in the field with information from a table. I already know how to add the...

Got it...Thanks a million...did all but that...it works great.

Thank you for your reply…I don’t want to sound drummer than I am but where do I put the: select * from table where D1 = [Enter date] or D2 = [Enter date] or D3 = [Enter date] or D4 = [Enter date] or D5 = [Enter date]

I have a Query with a field “D1” from my “Data entry Form” and want to do a date search [Enter Date] in the Criteria; easy. But I also have 4 other fields “D2”, “D3”, “D4” and “D5 in the same form. How can I do a query search to find a certain date looking in all the fields? :confused:

I got it to work…for some reason I had to delete the sub form off the main form and the re-insert it. Thanks for all your help

Ok I have the form as a sub form…I opened the form separate from the main form and it works…any ideas to make it work as a sub form?

tried that I still get the last record show up

When I open a form in Access 2003 to add new data…how do I open the form: 1) With a blank form...all fields are empty. 2) I also want to block and previous data to prevent employees from seeing other employees info. Any help would be great. TX

Still doing something wrong - still get the #name? This is what I have in the new form "DataEntryForm" based off the "DataEntryFormQ" Query: Adding a text Box: In the Control Source...

Thanks I will re-do it and try it. Thanks for your help.

No - I have others based on query's but not this one because it is for data entry. I am thinking I should re-do it before it's 2 late eh?

Sorry - I am lost now - I am only self taught beginner at this – thanks for your help any how.

This is what come up when I put it in =[me]![myProcessSheetTime]+[me]![myProcessSheetTime1]+[me]![myProcessSheetTime2]+[me]![myProcessSheetTime3]+[me]![myProcessSheetTime4]+[me]![myProcessSheetTime5] when I vier the form I get #Name? I must still be doing something wrong because I have always...

Thanks Thanks for your responce - whare do I put this? Control Source?