Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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