Search results for query: *

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 =...

one more question guys... havent tested yet...using the tagid over the network... currently my users access the db from desktop shortcut...and naturally there can mutltiple users at any given moment... is there any thing i need to be aware of in a multi-user environment?? also, anyway to...

Ace...it worked just fine!!! only a couple of issues... 1. when the sql update runs... it prompts with an "you are about to update...." obvisiously i cant have my folks seeing that...anyway to turn it off? 2. if i read it correctly... before and afterupdate code would gray out the navigation...

guys i tried setting data entry properties to both yes and no...neither worked. i am thinking i wasnt clear...it is a (single form) both main and sub... and the navigation buttons are custom to the point i used bitmap image but the code was produced by the wizard. let me see if i can clarify...

did you find a way to convert .mdb to .exe or .mde?? i need to convert an existing db to one or the other also.

I hope someone can help with this.... I have a Form/subform...the main form populates employee info from tblemplinfo...the subform using formview...allows employees to add records to tblrdm. these are related by [ssn] currently when the form opens..it displays all previous entry based on that...