Search results

  1. D

    alarm box when open hyperlink

    When I open a hperlink, which link to a WORD file on web, there is an alarm box saying "opening http://...... .doc Some files can contain viruses or otherwise be harmful to your computer. ......." I have to press OK button to view the file. How to hide this alarm box?
  2. D

    anybody know a SQL statement reference book?

    Thank you so much...
  3. D

    anybody know a SQL statement reference book?

    Currently I don't have any books about SQL statement. is there anybody could give me a suggestion?
  4. D

    To record Employee transfer date OR to record employee title?

    Table2 record the relation between Employee and Site. One Employee could have many different days in one site, and I want to caculate the total days for each title. The problem is if employee change title, the caculation should keep the past record with old title and new record with new title. I...
  5. D

    To record Employee transfer date OR to record employee title?

    Table1 - Employee ... EmployeeID Name Title ... ... 1 ZZ engineer ... ... 2 LL engineer ... Table2 - Site ... EmployeeID Location Date ... ... 1 BJ xxxx ... ... 1 TJ xxxx ... ... 2 BJ xxxx ... ... 2 SH xxxx ... Query1 - Employee & Site Location Title Count BJ Engineer 2 TJ Engineer 1 SH...
  6. D

    increase the limitation of ControlTip Text?

    Thank you... Thank you :)
  7. D

    increase the limitation of ControlTip Text?

    Thank you ... The text is automatically create depends on the information in table... Is there a way to cast the text into lenth 255?
  8. D

    increase the limitation of ControlTip Text?

    I have a control tip text has length 289, is there a way to increase the limitation of control tip text.
  9. D

    How to begin to use Page class in a Form?

    How to see different Pages in a form?
  10. D

    IIf(year="2007",PuraseDate > #1-1-2007#,"*")

    Table1: PurchaseDate Field1 Field2 ... 2007-1-10 XXX XXX ... 2007-2-8 XXX XXX ... 2007-3-22 XXX XXX ... 2008-11-10 XXX XXX ... 2006-1-1 XXX XXX ... 2005-8-16 XXX XXX ... Form1: ComboBoxPurchaseYear(use to choose year. Value List "2006 and before";"2007";"2008". AfterUpdate...
  11. D

    IIf(year="2007",PuraseDate > #1-1-2007#,"*")

    the ">" seems not work
  12. D

    report page setup

    I define one report in PAGE SETUP / PAGE as Landscape, but when I reopen the ACCESS file and open the report it is automatically diplay as Portrait. The strange thing is if I cloase the report and reopen it, it is displayed as Landscape. I'm crazy about this... HELP....
  13. D

    see detail

    Thank u very much! the example is good enough.
  14. D

    see detail

    TABLE 1 projectName REV Budget aaa 0 1.0 aaa 1 2.0 bbb 2 3.0 ccc 1 4.0 bbb 2 5.0 ddd 1 6.0 eee 1 7.0 aaa 2 8.0 TABLE2 projectName Type aaa M bbb N ccc M ddd M eee N For the above two tables, I want to use query to get the capacity sum of higher revision of project for each Type. like the...
Back
Top Bottom