Search results for query: *

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

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

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

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

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

Hi, I am trying to get a popup window browser from my flash file. So far, I am able to use the getURL command and javascript in actionscript to open the new browser normally. However, when I embed the flash file into a webpage which resides on a different server (to avoid the ads), the popup...

Hi, Just want to check if it is possible to run windows xp from an external usb drive? I have managed to get windows setup to install on the hard disk, but on boot up, it hangs at the XP logo startup screen. I can't seem to find any confirm answer to this... If it is not possible, is there any...

Hi, I have different workbooks, some containing source data, and one for other users to view certain parts of the source data. I have charts from the source workbooks which I want to export over to the user interface workbook, but maintain the link. I tried to do a copy and paste, and keep the...

Hi, Not sure if this is the right forum... I currently have a MSI Nvidia FX5600 card which was working fine for the past few months. Recently, my hard disk crashed, and I reinstalled my operating system (windows 2000). However, I just found out that I have this problem whereby when I change my...

Hi, I am trying to install win 2000 on a new Sata HDD. At first, I tried to format the disk and install windows, but the installation failed twice, prompting setup was unable to copy a particular file over, and skipping the file would give me a blue screen. (Unfortunately, I did not take note...

Hi, I am currently trying to print text from a RichBox control by printing character by character. However, I am having problem printing underlined blanks, i.e., an underlined sentence has broken lines. I have tried to resolve this by drawing a line where an underlined space is required, but I...

Hi, I am trying to create a custom user control, which has a DateTime array as a property. When I compile the control and add the user control to a form, the DateTime array property is browsable and the DateTime Collection Editor appears, but when I add to the collection, it doesn't reflect on...

Hi, I have created a setup project, and also a vbscript to execute the file after installation. My problem is, how do I pass the installed directory path to the vbscript, and also, how should I read the argument from the script? At present, after adding the .vbs to the Commit node of the...

Hi, I'm trying to do some essbase retrieval for a certain workbook through vba. My problem here is that after retrieval has been done for each worksheet, the connection remains connected. There is this vba function "EssVDisconnect" which takes in a parameter sheetName. Would appreciate if...

Hi, Lately I have been encountering problems where when a workbook is opened, the macros are automatically disabled, i.e., there is no prompt to enable/disable the macros. The macro security is already set to medium. Even when I set to Low, the macros are still disabled. The only temporary...

Hi, I'm trying to run an vb.net .exe file from a network share, and it keeps prompting securityexception error. After some reading, I realised it's due to .net security, and after configuring at the user-end pc, the application works fine. Does this mean that to run the application, I have to...