Search results for query: *

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

Try this: in design view of the report, click Sorting and Grouping icon from tool bar, from there you can sort the field [FinishDate] either by asc or desc.

I know we can disable the database by going to Tool, Startup uncheck Display Database Window and uncheck Use Access Special Keys. But if I hold Shift key when I am opening the database, the database window will still show up. How can I make the database not showing up--no matter what! Thanks in...

Thanks for info. Actually in the form_load event, I used: docmd.setWarnings false and in the form_unload event: docmd.setwarnings true 'in order to reset it back to on and they worked.

I went to Tools, Options and then choose Edit/Find tab. I unchecked the mark for the Action Queries in the area of Confirm section. But when my actions are run, an alert message still pops up? Can you tell me why? Thanks!! Jinglin

Thank you very much!