Search results for query: *

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

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

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

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

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

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

I have a issue where I want to update a field, with a timestamp via commandbtn. I have a subform (adminsub) that onopen queries a table with results displayed as datasheet, with a field (udate)which will hold my(timestamp. cannot loop thru the query since I did not index that field due to...

Trying to put a checkbox or commandbutton on the parentform...and when either is activated will change the current state of all my checkboxes on a subform.datasheet to a true state! subform is the result of a query. is this possible in access???

Need some help folks... Trying to put a checkbox or commandbutton on the parentform...and when either is activated will change the current state of all my checkboxes on a subform.datasheet to a true state! I can get it to change the state of the first checkbox but can not get it to loop/move...

Before you laugh...please read :0) I have a form...3 textboxes...cmdbtn. What i what to do is input the the default value in the txtboxes...click continue and generate a report or file with every possible combination beginning with the default. so box1 default is always..."S" box2...

i want to deploy an access 2000 app....the forms have non-default colors selected from access palette. when i test the appl over the network the colors change to access default or desktop default..... how can i force my colors to the user screen?

i have a input form that ask for [ssn] if the ssn is invalid i have a msgbox vbok...here it stops execution and shows input form again...with the previous entry still there and hilighted...what i want is an empty textbox with focus of course? can anyone help please. ok one more...plz 2...

if i turn off break on all errors...other than my users won't see a access generated error msg just my custom msgboxes...is there anything else i should be aware of?

Can anyone help me with this... I have 2 forms...form1 form2...based on form1 input (ssn) it will either open form2 with a record matching (ssn) or give a custom msgbox, however access2000 also displays after clicking vbok on the custom msgbox...the error is being generated from form2--docmd...

Can anyone please look at the code below...(see asteriks) this code will run as far as, sending the email out...but it will not attach the file (rptTIME.snp). and yes, I have tried using the full path. This code is ran from Acc2000. the mailservice is LotusNotes. Just for clarification I have...

oh i am really feeling like an idiot...i have a access2000 form that contains checkboxes (10) per category (4). checkboxes were named check1to10 in the first category, check11 to 20 and so on... i want to count just the "yes" boxes for each category. because each category needs to be...

oh i am really feeling like an idiot...i have a access2000 form that contains checkboxes (10) per category (4). checkboxes were named check1to10 in the first category, check11 to 20 and so on... i want to count just the "yes" boxes for each category. because each category needs to be...

Need help trying to email reports from acc2000 using Lotus Notes over company Intranet. Running wizard send report gives only outlook config options. HELP PLEASE!!