Recent content by jinglin

It just won't work no matter how I tried. I think Rick is right. Our company does use McAffee antivirus for our computer. Thank you all for your help Jinglin

Every computer in our computer encounters this problem, when we want to show a message box to the users. We’d write a line like this: Messagebox.show (“User name has to be entered.”) All we got is a blank message box without anything on it. Besides, the combobox and listbox won’t show any list...

You're right. It's a problem of data source. We gave the permissions to the user for accessing the SQL server on the LAN, but physically they're not mapped to it(no client-side SQL server installed even). We tried one user in our location (giving her permissions, but no SQL server installed...

We developed an intranet application with SQL server as storage of data. When I click on the button called Mail Merge on the page, it will open up my word document called MailMerge.dot, so I can view those merged letters and print out them as I wish. Everything works exactly what I expect, but...

I thought so too. I should get more details from the guy who has the problem. Thanks!

Do you know how to fix it---I mean where to start. My super asked the user to update his IE to ver.6. you think it might be OK? thanks!

I'm new to ColdFusion. In my cfm file I used the following codes to open up Word, and it worked fine. var doc = new ActiveXObject("Word.Application"); // creates the word object doc.Visible=true; // display Word window doc.Documents.Open("//myPath/mailMerge.dot"); // specify path to...

I know if we use count(*), which will give us a total count. But what if I want to count a specific field including null values in the field. How should I do it? Thanks for your help.

you're right, Leslie. Access 97 doesn't have such a functionality. If I did as ontheFly told me in SQL server, it worked fine: SELECT count([ID]) AS TotalIDs FROM (select distinct [ID] from myTable) Thanks for your help.

but how can I combine those two queries into one statement? Here, it doesn't work for me with two queries. Thanks anyway.

I did as you wrote me as following: SELECT count([ID]) AS TotalIDs FROM (select distinct [ID] from myTable); but I got a syntax error saying: Syntax error in From clause. Thanks!

but how can I show two queries in a text box which has to be shown on the report. Is there one SQL statement to solve the problem? Thanks!

for my Access database(97. I have a field called ID, which has multiple values: 0-007 0-007 1-123 1-123 5-456 5-456 I need to get the total distinct counts of ID for my report(here I should get 3) so I run a SQL statment: select count(distinct [ID])from myTable; But all I got is a syntax...

I tried to avoid the alert message showing up when I wanted to delete my query, so I went to Tools,Options, and choose Edit/Find tag, on which I unchecked all check boxes for the Confirm group, but somehow, when I ran the deletions, the reminding message still showed up. Can anyone tell me why...

the following code will copy your table to another database, the path of your database location varies: DoCmd.TransferDatabase acExport, "Microsoft Access", "c:/YourFolder/YourdatabaseName.mdb", acTable, "YourtableName", "YourtableName