Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MAINOH

    update table with memo field from form

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

    update table with memo field from form

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

    update table with memo field from form

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

    complex date criteria for query

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

    complex date criteria for query

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

    Importing an Excel File

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

    Conditional Formatting Help

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

    Displaying related table in parent table

    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!
  9. MAINOH

    Displaying related table in parent table

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

    pop message for subform

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

    subform criteria

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

    pop message for subform

    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!
  13. MAINOH

    pop message for subform

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

    Switchboard Manager

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

    help with date fields

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

    another question

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

    Filter combo box

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

    Filter combo box

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

    Filter combo box

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

    Filter combo box

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

Part and Inventory Search

Back
Top