Description:
Microsoft Office Access newsgroup.
|
|
|
total working hours
|
| |
hi, i am trying to create a data base for the time attendance of the employees i have date- time in- time out-time in 1-time out 1 "the time in and out are date and time short time i need to calculate total working hours per day Total working hours = ????? Thank you in advance
|
|
|
To check all items in a subform
|
| |
Hi, I am currently using microsoft access 2003. The problem senario is this: I am using a form with a subform. In the main form, I have a checkbox. The subform also has checkboxes. My requirement is when I check/uncheck the checkbox in the main form, the subform checkboxes should also be checked/unchecked. How do I go about doing this, as I... more »
|
|
|
Where is the next control identified?
|
| |
Screen.PreviousControl.Name provides the name of the control that last had the focus. That's nice if you need to know where control came from, but there doesn't seem to be a Screen.NextControl.Name or anything similar. I have code that is executed OnLostFocus in which I would like to save the name of the control that will be receiving the focus. This would allow me to... more »
|
|
|
Data Entry form and show old records
|
| |
Hi; I have a form for data entry which displays blanks for new data to be entered which is fine, however it would be nice if it also showed the most recently entered record, but greyed out or something so the user can't edit it? Is that possible?
|
|
|
Can't get debug to break
|
| |
I asked a similar question recently, got no answers. I rebuilt the form (Header/detail) using the wizard, this time with the final form name I wanted. I added three buttons, and a couple of event handlers. One of the event handlers in the subform is acting strangely (BeforeUpdate). I set a breakpoint in it (I tried the simple way--edit via main form, the hard... more »
|
|
|
Creating "key" fields when met, unlock the next step...
|
| |
I am researching how to create veritable "gates" in a database so that when someone initilializes the process filling out a form, they cannot progress beyond a certain point in the process until a specified field is "electronically" signed by the "keyholder" person authorized to approve progression to the next step. The "next step" could be gaining entry into... more »
|
|
|
Is there a way to center (horizontally) items in a list box?
|
| |
I want each individual item in the list box to be centered horizontally. I don't see any properties that allow me to do this, nor any VBA code I can apply. When I tried adding leading blanks and using a fixed font such as Courier New, Access would trim off the leading blanks and left justify the text.... more »
|
|
|
Search for records
|
| |
ramudo, On my website (below) I have an Access 97 and 2003 sample file called Combo Quick Find. It demonstrates how to find any records within a form's recordset.
|
|
|
scroll to click on the tab page in the subform/subreport
|
| |
dear I am new in access, i am having a minor problem, i dont know if i can discribe it well, i have created a subform with many pages and in each page a form is added. once i click on the 3 sheet to make the data entry, and i want to press on the 4th, i cannot the tab listing, i have to scroll page up... more »
|
|
|
Incomprehensible OpenArgs behavior
|
| |
Incomplrehensible to me, at least. I'm hoping wiser heads will offer advice. I have a form (frmCirculars) that displays individual records of correspondence (circulars) in single form view. If the form opens directly, you can cycle through all 13,000 or so records. Each circular is associated with a project.... more »
|
|
|
|
