Search results for query: *

Dear all PROs, I'm using Access 97 to link a Oracle database. This Oracle database have 10 fields and i just want to link 5 fields into my Access database. Did Access can do that? I've try to use NEW > Link Table but it link all of the 10 field.

Dear Jane, Thank you for your support. I've deleted the key SGST and the Access back to normal now.

Moreover, I'm using Access 97.

Dear all, I've press the "Sorting & Grouping" button but the dialog box didn't shown up, why?

Dear Dreamboat, I'm using MS-Word 97 w/ MS-Outlook 97. Thanks:)

Dear Dreamboat, WordMail is a build-in function that the MS-Outlook (NOT Outlook Express) can use the Microsoft Word as a Email editor. I've checked the "Internet options" that the default email program is MS-Outlook. More detail, when I click "Mail Recipient using...

Dear All PROs, When I use Explorer, select a file and right click the mouse > Send To > Mail Recipient using Microsoft Outlook, the MS-Outlook shown "Can't create the item". What can I do? P.S. I'm using WordMail in MS-Outlook.

Dear all, I've a Excel 97 file content some of the numeric data, I try to type a "0" in the cell, it will not shown anything, but in the formula bar u will see a "0" inside; when I type any other numeric and alphabet it shown the exact string. I've try to format the cell /...

How to make a button for enable/disable the "automatic calculation" in the MS-Excel icon bar?

Again, if i want to use the SQL designer in Crystal Report, i can connect to orcale server directly through crystal dictionary and crystal report, however, i cant use SQL designer to draw data from Orcale server....Why??? any suggestion???THX!!!

In my current situation, there are 2 columns of data that one is staff no., another is effective date...each staff no. will have more than 2 effective dates...now i want to select the latest effective date of each staff no. that for example... staff no. effectivedate 00001...

How can I round up (or down) a number in SQL? i.e. round up 12.56 to 12.6 or round down 12.54 to 12.5. i'm try to use "round" function in Access 97 but not sucessful and use "round" in Access 2000 it work! I don't know why....