Recent content by ryDen

Hi, I can get to the url just fine via IE. Weird thing is when I edit the web query, or make a web query, it all turns up fine in the "preview" window from the "Edit Query" dialog. And when I do an import, the query starts refreshing in the worksheet, and the error comes up again. I'll try...

Hi, A friend of mine had an excel spreadsheet had included a web query from his company intranet site. It was working until he was upgraded from Office XP to Office 2003. Now, when he tries to refresh the query, it prompts the message "The file could not be accessed. Try the following...", and...

Hi, I have a report which I want to export to Excel. This report also includes some subreports. However, it seems that during the export, some of the fields are clipped, i.e., limited to about 255 words. How can I resolve this? Thanks in advance. Regards, Russ

Hi, I am creating a HTA with a Listview control in it. Is it possible to have different back colours for each listview row based on a criteria? If so, how do I go about it? Otherwise, is there other controls that can do this? I tried with a listbox, but while I can get the different back...

It's an activex control, not the standard HTML control. It is part of Microsoft Controls, usually used in VB, but as it is more appealing in layout, I used it for my HTA to present a list of items, which users can select and view more detailed information on the selected items.

Hi, I am creating a HTA with a Listview control in it. Is it possible to have different back colours for each listview row based on a criteria? If so, how do I go about it? Otherwise, is there other controls that can do this? I tried with a listbox, but while I can get the different back...

Well, after experimenting, it seems that having the css and using javascript "print" function screws up when printing more than one page. Would be nice if someone could explain why though... Thanks anyway.

Hi, I'm trying to print the contents of a datagrid. I want the format of the datagrid to remain, but it is done by css. The following code works for a small datagrid, but not for large datagrid, i.e., the contents go into more than 1 page when print manually: Response.Clear()...

Oops, my mistake. That does it. Thanks.

Hi, I am starting to program in Java. The problem is when I install the SDK using the windows installer, and add the bin path to the PATH environment, it seems fine. Running "java -version" in command prompt shows the java version. However, when I do a "import java.io;", the compiler cannot...

Sorry, I tried on another machine with a user account also on domain 1 and it also has the permissioning problem, so, shouldn't be domain problem. Apparently, it seems that remote impersonation doesn't work...

Hi, thanks for your reply. 1) Authentication mode is windows (<authentication mode="Windows" />) 2) Anonymous access is unchecked in IIS 3) Relevant security permissions is already given - only a certain AD groups can access the folder. 4) Shared permission is given to Everyone (Full Control)...

Hi, I am trying to do a intranet web application. I have already configured IIS to Integrated Windows Authentication only, and set web.config to windows auth mode. I have also added <identity impersonate="true" />. However, when I try to connect to an Access database on a shared network folder...

Hi, I am trying to export the result of an access query to excel. I have read somewhere that the TransferSpreadsheet method is faster, but it seems that the filesize of the resulting workbook is smaller when I use OutputTo. However, I have no clue what is the difference between these two...

Hi, I am currently doing a web database application. To retrieve the user's sid and full name, I have created a separate class to do the functions under a different project. Later, I imported the dll as a reference to use it. The application is able to run locally on both the development and...