Search results for query: *

I have a form with a field named comment which is populated from the following code (which is on the after update property of text box on the form which allows users to enter text): Private Sub txtNewComment_AfterUpdate() Dim NewComment As String txtNewComment.SetFocus NewComment =...

Hi, Details: tblTIMESHEETDATA Fields: WRKDAY (format date/time-short date) SUBNAME PROJECT ACTIVITY ENGDESC HOURS What I need is a query that will sum hours by SUBNAME/PROJECT/ACTIVITY grouping. This would be easy; EXCEPT I need the hours grouped and...

Ok - you ever have one of those things that you know has a simple answer but for the life of you, you can't figure it out? Well this is one of those things. Whenever I import an excel spreadsheet, I can't get access to allow me to change or even see the properties of any fields except the...

I have a report that which contains three fields: [ASOF] which value is today's date [DUE] which is the due date of payment. [PASTDUE] value = "PAST DUE" (the visible property is set to false on this field) What I am trying to do is have [pastdue] show when ASOF is greater than or equal to...

Hi, I have a 2 tables: tblREQ_LIST tblREQ_DETAIL Which I have a relationship set up for based on the REQ_ID. I want to be able to open the tblREQ_LIST and hit a + sign on the record and have it show me the related records in tblREQ_DETAIL. I've seen this in some of my other tables but have...

I have subfrmTIMESHEET_EXISTING which currently displays data which matches [employeeid] on the main form frmTIMESHEET. This is accomplished by setting Link Master Fields = cmbRESOURCE and Link Child Fields = EmployeeID. I would also like to limit the data displayed to that where...

Hi, I have a form frmTIMESHEET with a subform subfrmTIMESHEET. On frmTIMESHEET there are fields POPBEG and POPEND (both date fields). On subfrmTIMESHEET there is a field DAY (date field). What I would like is after DAY is updated, for access to check to see if the value of DAY false between...

Hi, I have two date fields pop_beg and pop_end. They both are formated at short date. I need to combine the two fields such that that on my report the two dates can be displayed in one field with the days of each at the beginning. For example: pop_beg value 03/01/2006 pop_end value...

Using Access 2003. I have a sub-form which I am trying to filter a combo box from an entry on the same form. Specifically: The user selects a projnum then the 2nd combo box is PONUM. I want the 2nd combo box to be filtered based on the projnum selected. The PONUM combo box source is a...

I get same error message as thread702-1161841 when I try to enter a new record in a sub-form. main form data source is tblSDCFSUMMARY with Key field of INVNUM. Sub-form data source is tblSDCFDETAIL with key field of ID. There is a 1 to many relationship between tblsSDCFSUMMARY and...