Search results for query: *

The only thing that shows in the table is the 1st word of the comments field from the form which is "entered".

Thanks PHV, the comment field is bound to the field tracking notes. But the comments still do not show in the table.

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

Thank you both for your input! Your suggestion works wonderfully Robert!

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

thanks mstrmage1768! I figured out that the type of join or perhaps it is rather the cascade update/delete is selected that makes all the difference. when I changed the relationship to a simple outer join - it worked. thanks!

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

Tom - I tried to complete your first post - but being somewhat inexperienced at coding - I couldn't figure out how to create the Public Function (or where to create it). So I tried your change to the comparison, here is what I have: Private Sub DAY_BeforeUpdate(Cancel As Integer) If Not...

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

Thanks PHV, you have gotten me much closer. However, the message pops up no matter what value I enter in DAY. How can the code be changed to cause the message ONLY IF the value of DAY is not between or equal to POPBEG and POPEND? Thanks!

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

Is it possible that one of the items that your switchboard points to got deleted?

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

Did you select a field/expression as well as choosing a sort order? Then at bottom of SORTING AND GROUPING dialog box there is an option to have group header and one for group footer. If you select yes to either or both of these it will add sections to your report. This will sort your...

Thank you so much to everyone who assisted with this issue. The answer was in fact the issue talked about in: http://support.microsoft.com/?kbid=209099 as PHV suggested. The reason it didn't work the 1st time I tried it is because I was tyring to build query on the subform control source...

I've tried all suggestions: I removed the row source from PONUM and changed PROJNUM afterupdate event to: Me!PONUM.RowSource = "SELECT PO_NUM, AI, RemainingHRS, [Remaining$] FROM qryPORemaining WHERE PROJNUM='" & Me!PROJNUM & "' ORDER BY 1, 2" Alternatively I also tried using the...

One other thing. This filtering works fine when I just open subfmSDCF_Detail by it self. But does not work when I view the form as a subform on my main form.

MajP - Best I can tell - I have everything as the FAQ you mention, with the exception of the check to see if PROJNUM was input 1st. Here is my code: FORM: subfmSDCF_DETAIL Name: PROJNUM Control Source: PROJNUM Row Source Type: Table/Query row source: SELECT tblPROJECTS.PROJID FROM...