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

    Help with removing duplicates in Query

    Base a report on that query and hide the dupes there, not in the query. --Lilliabeth
  2. Lilliabeth

    Unusual calendar needed: 8 days on, 6 days off, Repeat

    How can I make a Project plan reflect our company's schedule of 8 days on then 6 days off, 8 days on then 6 days off, etc.? Also a "day" = 10 hours. Thank you. --Lilliabeth
  3. Lilliabeth

    Composite Keys: Good or Bad?

    Composite primary keys complicate things later, when building the front end. Even a simple combo box is made more complicated. We have a rule against composite PKs where I work. Unique index the fields, but use an autonumber as the join field. --Lilliabeth
  4. Lilliabeth

    Hey all. Here's my problem: I ha

    No apology necessary. Glad to hear you figured it out. It is always better that way! Glad to have been helpful. --Lilliabeth
  5. Lilliabeth

    Hey all. Here's my problem: I ha

    This is a simple one-to-many relationship and requires a standard form with subform. --Lilliabeth
  6. Lilliabeth

    Hey all. Here's my problem: I ha

    In the table, set the Append Only property of the Memo field to Yes. This won't record who made changes, but will record a running history of the contents of the field and when it was changed. To see the running history, right-click in the memo field for the record you're interested in, and...
  7. Lilliabeth

    Hey all. Here's my problem: I ha

    Add the textbox controls for the fields just like you do other fields in your table. Rename each textbox so they match the names referenced in the code... txtCreatedDate, txtCreatedBy, txtLastModifiedDate, txtLastModifiedBy. Set tab stop property to No for these textboxes. I always set Back...
  8. Lilliabeth

    Hey all. Here's my problem: I ha

    Memo IDs are not linked to PatientIDs. The memo table has 3 fields: MemoID, Memofield, and PatientID. PatientID is linked to PatientID. The primary key in the memo table is MemoID. To automatically record who and when a record was created and last modified, you can add these fields to the...
  9. Lilliabeth

    Hey all. Here's my problem: I ha

    tblPatients PatientID -pk FirstName LastName etc tblMemo MemoID -pk MemoField PatientID (this is known as the Foreign Key) In the Relationships window, join PatientID to PatientID --Lilliabeth
  10. Lilliabeth

    Access 2010 group by report want to have > hours header

    When you click 'Add a Group', Access 2010 offers you a list of fields so you can choose a field to group by. --Lilliabeth
  11. Lilliabeth

    Access 2010 group by report want to have > hours header

    Display the Group and Sort pane. Click Add a Group. At the bottom of the field list will be "expression". Choose expression and type Hours>50. The result will be two groups, one where Hours>50 is True, and one where it is False. --Lilliabeth
  12. Lilliabeth

    Access 2007 - passing function variable to query wihtout using VBA

    I'm not sure I understand... do you have a field in a table that should be populated with the concatenation of LastName, FirstName, and EmpNumber? Is this what you are trying to do? --Lilliabeth
  13. Lilliabeth

    Access 2007 - add buttons to form but they are not visible in form view?

    Make sure the Display When property is set to Always --Lilliabeth
  14. Lilliabeth

    Excel Attachment Hanging in Microsoft Outlook

    Empty the Temporary Outlook Files folder http://www.howto-outlook.com/faq/securetemp.htm --Lilliabeth
  15. Lilliabeth

    Open embedded objects in protected document

    Notice in the Restrict Formatting and Editing task pane that launches when you turn on protection, beneath No changes (Read only) is the word Exceptions. Select your object's icon and check the box labelled Everyone. Then turn on Protection. --Lilliabeth
  16. Lilliabeth

    Displaying data on a subform

    If it were me, I would consider making ItemID on the subform be a combo box that included these fields as columns, each with a width of 0. Then make textboxes that refer to this property, like this =[ItemID].[column](3) --Lilliabeth
  17. Lilliabeth

    Excel formula based on three ranges

    oops. I didnt account for a score <63. Here is the corrected formula =IF(A1<63,A1,IF(A1>78,A1+75,IF(A1>70,A1+55,A1+35))) I prefer lookup tables too, but I'm not always sure a poster will. It helps to know though that this aspect of scoring in Kismet has been the same for several decades...
  18. Lilliabeth

    Excel formula based on three ranges

    =IF(A1<71,A1+35,IF(A1>78,A1+75,A1+55)) --Lilliabeth
  19. Lilliabeth

    Countif with &quot;between&quot; criterium

    If the 3-min intervals are in cols F and G (begin times in F, and end in G), then: =COUNTIFS($A$1:$A$30,"<="&G1,$B$1:$B$30,">="&F1) The COUNTIFS is relatively new; Microsoft added it in version 2007, so this won't work if you have a very old version of Excel. --Lilliabeth
  20. Lilliabeth

    Form email button to automatically attach a report containing Ole logo.

    Have you tried the macro action EmailDatabaseObject? Output format should be: PDF Format (*.pdf) Leave other fields blank except for Edit Message - leave it Yes --Lilliabeth

Part and Inventory Search

Back
Top