Search results

  1. A

    I don't understand this error message

    "The method you tried to invoke on an object failed" *You may have specified too many or too few arguments for a property or method of an object. Check the component's documentation for information on the properties and methods it makes available for Automation operations *There may not be...
  2. A

    query more than one table

    OK I already know the answer - yes I can query more than one table because I have done it before. But now as soon as I add the second table, I get no results in the query. I know there should be some results. what am I missing? thanks
  3. A

    Error Message???

    The method you tried to invoke on an object failed. *You may have specified too many or too few arguemtns for a property or method or an object. Check the component's documentation for information o the properties and methods it makes availalbe fo Automation operations *There may not be enough...
  4. A

    Automatic field input

    I need to keep track of our contact with Agents. I want to make a new record everytime I contact the agent but I don't want to have to fill out all the fields everytime because once I make the initial contact, most of the information will be the same. Is there a way to duplicate a record and...
  5. A

    return a date range

    What forumla do I use to return entries one week on either side of today's date: thanks
  6. A

    report based on date span

    what formula do I put in a query to get entries on week on either side of todays date? thanks
  7. A

    Help with sum formula in query

    I have a table the tracks training hours for associates. Training credits are earned in 1,2,and 3 hour blocks I want to know the names of associates that have completed at least 16 hours. How do I do that? thanks
  8. A

    format issue - i think

    i am using this formula: expr2: DateDiff("yyyy",[hiredate],Now())+1 it returns the correct number for example the first record is 1/15/1900. The 15 is correct but why is it giving it to me in this date format? thanks
  9. A

    Query question

    I need to pull names from a list to report leave taken but I need to list all the names on the report whether they have taken any leave or not any suggestions?
  10. A

    "text begins with" filter

    I want a button or shortcut to use the "text begins with" filter on a form. How can I put such an icon or shortcut in my tool bar across the top? thanks
  11. A

    type mismatch - can't sort

    I input info into a combo box in a form. The info is a number that I then use to populate other fields in the form based on that number. When I try to sort based on that number I get a type mismatch error. Why is that? I would really like to be able to sort based on this field but I can't...
  12. A

    update field not working

    I have a form with a combo box based on a table. When I enter a code in the combo box, I want the system to update other unbound text boxes with the other information in the table. I have it working in one form but not the other and I can't figure out what the difference is. The combo box is...
Back
Top Bottom