Search results

  1. S

    Linking Report to Form in Access 2003

    I want to be able to open report with button that only shows the report to the current form record.
  2. S

    Word document Event Procedure error

    Getting an error when attempting to use data from access in word document. The error says "Word was unable to read this document. It may be corrupt. Try one or more of the following: Open and repair the file. Open the file with the Text Recovery converter." The document doesn't have an issue...
  3. S

    Multiple Functions in one field

    I need to be able to create a multiple function that will return 3 different outcomes for example: if column A =1 than return value "Help" or if column A=2 return value "Stop" or if Column A=3 return value "More". Is this still a iff statement or do I use another function? If so, how do I...
  4. S

    Checkbox

    I have a child table that has childtableID, ParenttableID and checkbox(yes/no). There are muliple records that have the same ParenttableID. I want to validate the checkbox to only allows one checked(yes) box per ParenttableID. Can someone help me:confused:
  5. S

    Day of the week

    Is there some way I can determine what day of the week a date falls on within a query? Also, is there a way I can count how many wednsdays (for example) there is in a date range with in a query or is this a expression that only can be done with VBA, a form or a report? :eek:
  6. S

    How to write query iff statement with datediff function

    I need to write a statement that does the following: If closed date is empty than subtract date opened from today’s date if not subtract closed date from opened date.
Back
Top Bottom