Search results

ok, So it's a project database that tracks time. tblProject stores the main info on that tblProjectHistory stores specific history added to the project including employee, time, project id, etc. tblProjectStatus retains the status information on the project, opened, closed, etc. this could...

I've already got that going - sort of. in order to use one query for multiple similar reports i have the end report pull whatever specific data relates to it. (e.g. one user, entire team). Currently when the query runs it dumps records into a temp table for the time period selected, that...

Access 2007 Sub-Report "rptSubEmployeeProject" inside report "rptProgressReportDay". I need to dynamically change the table in the sub-report's record source. I tried (line wrapped in code tags below for reading purposes) SELECT tblProjectHistory_fldProjectID, FirstOfHistory, [History...

It does I think. I guess I was getting caught up in the way I use it is the same it's just the object itself (label vs button) that was different.

interesting. just odd I haven't run by it before. Although I think this is the first time i've used a label with an onclick instead of a button with onclick. Not sure why it'd make a difference. Thank you!

thank you - that did it. but why? is it similar to various updating situations where Me.Dirty comes into play - like a losing focus?

Access 2007 Unbound Form I have a onclick tied to a label (for decoration purposes) that when clicked it launches VBA that essentially updates a form. All that part works except it will not recognize any changed value of the field I was last in? Just to try to explain best as I can what...

Re: count number of dates seen or zero (Solved) that did it! ahhh i knew better too. Thanks!

Hi folks, I'm having a moment - I just can't seem to get this one to work right. I've got the following query. I need to count the number of Null dates or show zero if there are no Null Dates. SELECT DISTINCTROW qryNoticeResponseNew.fldNoticeID, Count(qryNoticeResponseNew.[fldResponseSeen])...