Recent content by Rene Lazaro

Yes; fGetUserName is called from a public function I have declared in a module. In light of some research I've done on the issue, I will opt for Bob's solution - insert it with a form - which I was trying to avoid. Guess there's no way around it. Thanks for your help!

Good morning, I employ a function that obtains the windows username and use fGetUserName() on forms to obtain it. This works great, however, when I insert fGetUserName() into the Default Value property of a field in my table, I get a message stating that the function is unknown. How can I...

I was not aware of the evils of using lookup fields in tables. This is perfect! Thanks again!!!!!!!!!!! Rene

[Injury Classification] is a text field. Yes; I am after a count of how many records had an injury classification = "Lost Time". tbl_Injuries 1) Case Number (Auto Number) - Primary Key 2) Social Security Number (Text) 3) Injury Date (Date/Time) 4) Description (Memo) 5) Insurance Code...

Good morning, The query has the following six columns (Totals Query): Column 1 (Group By) TheMonth: Month([tbl_injuries].[injury date]) Column 2 (Group By) TheYear: Year([tbl_injuries].[injury date]) Column 3 (Group By) [Parent Company] (There is a relationship between two tables. Please...

I am trying to use the same approach with another scenario but am unsuccessful, can you help? The query has the following six columns (Totals Query): Column 1 (Group By) TheMonth: Month([tbl_injuries].[injury date]) Column 2 (Group By) TheYear: Year([tbl_injuries].[injury date]) Column 3...

Good morning jzwp22, This is it! Exactly what I needed! Thanks a loooooottttttttt! Rene

The query has the following six columns (Totals Query): Column 1 (Group By) Month: Format([Begin],"mm") Column 2 (Group By) Year: Year([Begin]) Column 3 (Group By) [Parent Company] Column 4 (Sum) [Hours] Column 5 (Expression) Hours Ytd...

Good afternoon, I am trying to develop a report but get a message stating that I have reached the limit to the amount of tables that can be open at the same time when I run a test report. As a result, I cannot conclude its development. I've attached two pages of the report for your review...