Recent content by mrwendell

EXCELLENT!!! I ran with my theory it worked...your input was a big part of that it focused me on the right solution!!! MUCH APPRECIATED YOUR EXPERTISE!!! now I can get some brownie points from the boss..haha

okay I follow that logic... so I have a workaround in my head... since I cant AVG a unbound... if I can count the employees per group in a [txcount] use that as part of calc ***[SumOf12MTDAbsenceOcc] is the only ctrl that is bound to the query and is the starting point of this dilenma***...

So... I cant add a txbox to a report, have that unbound txbox read another bound txbox and calculate on it?? if I cant add another field to the query, then I am basically screwed???

it just a simple syntax error... fixed that... my avg txbox comes up with zeros... which i gather means its not reading the txbox sum...

Okay, let me try to state this clearly this time. I have a report... the report has 4 footer groups...employee,supv,mngr and director. in the mngr footer it sums all empl for a supv. one of the columns is not bound to the qry but it does calculate a % based on a txtbox that is bound to the...

PLEASE IGNORE THIS POST... I AM JUST RAMBLING... I NEED TO RE-SUBMIT ...THANKS!

In Access I have a report that is based on query filters...to generate the data for the report... I need to count the number of employee per supv. WITHOUT a major overall of the existing report/query. Let me see if I can explain this clearly... 2 tables...joined by ssn 4 filter queries when...

okay...not having used your example yet... my initial question would be...your code looks like it will lock all records on my form...records are displayed on a subform and in datasheet view. so there may be record in the subform that can be edited. would your code this work? (mymainform)...

if i have a checkbox that is true...how can i disable the entire record from being edited, if so how?

Here is what i need some help with... i have timesheet application in access...i cannot totally make everyones permission readonly...so what i need to do is when there is a change made to a record i need that time and possibly user attached to that record. tblRDM frmEmplRDM.... supv make...

I need assistance with... 1. how to timeout a user from my database when they have been inactive for say 20 minutes? 2. how can i see who is logged into my database?...users donot have to log into a wrkgrpadmin... management does because they are members of a wrkgrp that is used in another...

FANTASTIC!!! THANKS

I have a Mainform/mainsub form...the mainform has a cbofindrecord. Once a selection is made the subform display datasheet of the results based on a query of primary table. However, if the results of this query is "nothing" i would like my user that the query did in fact "run" and the results is...

GUYS I HAVE ONE MORE STEP I NEED HELP WITH...I POSTED THIS ON ACCESS/SQL FORUM ALSO...BUT I FIGURED YOU GUYS ROCKED WITH WHERE I AM SO FAR...I FIGURED I OWED YOU THE PRIVILEGE OF SEEING IT TO THE END...HAHAHAHA... i know such b.ss!! anyway... Mainform/subform-- cbofindrecord select a team as...

I hope I can explain the without gibberish... anyway Mainform/subform-- cbofindrecord select a team as follows Sub cboFindRecord_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[CoachNbr] = '" & Me![cboFindRecord] & "'" Me.Bookmark =...