Search results for query: *

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...

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'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.

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...

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...

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

Whenever printing out the report, my users have to set printer paper size to legal as required (Access 97). In report design view, I used the method by going to Tools - Options, and then choose General tab to manually set print margins,etc. but to my knowledge, any modification to the design of...

I have a report which shows the OrderID,PIN#, DateCreated,etc... The report is grouped by PIN# bounded to TableA. But I only need the report to show 3 most recent records for each grouped PIN#(based on DateCreated). How am I going to do it? Please advise! Thanks! Jinglin

I have a report which shows the OrderID,PIN#, DateCreated,etc... The report is grouped by PIN#. But I only need the report to show 3 most recent records for each grouped PIN#(based on DateCreated). How am I going to do it? Please advise Thanks! Jinglin

I have a table in my SQL server database. I did the sql as follows, which returns nothing. Can you help me find out why? select count(distinct Logon_user) as countof from Login where ('9/1/2004'=convert(datetime,Date_Added,110)) Note: Date_Added field has a datetime type Thanks a lot! Jinglin

When my users are using the Access application, some of them might exit the application by clicking on the Close button on the top right. How can I disable this button and let the users exit the application gracefully? Thanks for your help

I have both versions installed on my machine.Since then I can never directly open any version's Access database. I have to go to Start,Program, then choose whatever version I need to open my access db. (I know this is the way to switch the Access Version) Anything that I can do make my life...

It's Friday!!! I'm not sure if there're any one who can help me out with this problem. Some of my users entered the data into the field (memo datatype) with lots of empty lines in between. such as: blablabla----the first line blablabla----Second line blablabla----third line So, is it...

I just took cystal report class. I have a report which has a link that willl lead me to a subreport when I click on the link. Is it possibe that I can have a link on the subreport which will take me back to the main report. I tried a couple of times by using hyperlink, but it's not working. Can...

There're two command buttons on my form called Previous Record, Next Record in order to navigate the records( I didn't use ADO or DAO recordsets). When I keep clicking on the buttons, I'll encounter an error msg saying that " You can't go to the specific record. You might be at the end of the...

I tried to export from the table of Access 97 database to Excel spreadsheet, but was stopped by a error msg saying: Error 3170 Couldn't find installable ISAM. What is ISAM? Can anyone tell me? I'm so puzzled. Thanks! Jinglin

Good morning, everyone! Can't believe it's Friday again! But I've encoutered two problems here. 1)I have a report which requires paper size Legal to print all contents on the report. My users don't like to do it manually. How can I hardcode to set paper size to Legal (by default it's Letter...

I have a text box on the form, which can only allow users enter numeric keys. I forget the codes. Can anyone help me out? Thanks!