Search results for query: *

Experts, I am just starting with SSRS and am encountering a problem which is causing me some grief. I want to be able to pass the logon id as a parameter to reports. I want to hide this for obvious reasons. Iam using the following code in an attempt to pick up the manually input parameter values...

I have inherited a Excel workbook which has a listbox populated by a query on a database table. Recently the number of records returned has exceeded 60. The following code is used to red the selected items. For i = 0 To LBSubjects.ListCount - 1 If LBSubjects.Selected(i) Then keystr =...

I have inherited a Excel workbook which has a listbox populated by a query on a database table. Recently the number of records returned has exceeded 60. The following code is used to red the selected items. For i = 0 To LBSubjects.ListCount - 1 If LBSubjects.Selected(i) Then keystr =...

Hi, I have a problem which I am sure will be easy to solve but I just cant see the solution. I have a small questionnaire in an ASP.NET application which consists of 5 questions with a radio button group of 4 mutually exclusive answers which I want to store in a database. Currently everything...

Hi, I am moving on from ASP to ASP.NET and need some advice. I have an application where I have to perform a very similar task on two datasets. I have a page which does what I want on one of the tables and would now like to repeat the process on the other. In good old ASP I would just copy the...

I am sure this has been answered before but I can't find the answer. I have a simple requirement to list all the files and their locations within a master folder. There can be quite a few levels of subfolder all of which must be examined. I don't need to import the contents, just get the list...

I have a simple problem. I need to test to see if WORD is already open on a client machine. Is this possible using Javascript? Many thanks Sandy

There are probably several answers to this question but as I am unsure of what to look for I can't find anything suitable. Having converted a couple of MS Access databases to run on SQL Server I have been given the job of setting something up in SQL Server. The key part of this will be to load...

There is probably a very simple solution to this. I have a small Access sytem which gathers data from various sources and creates a table of composite data. After checking manually the table is exported to a text file for use in a system off site. TO be compatible with the receiving system the...

Hi, You have never let me down in the past so I am sure someone knows the answer to this. We have a multisite operationand to save loading the network with videos we have been using the SERVER VARIABLE REMOTE_HOST to select a local server as the source of a streaming video setting the source to...

Hi, I have an Access Db which started life in version 2 and is now in Access97. I want to convert this to an Access Project with the data stored on SQLServer. I have a problem in that a number of the access queries use both custom and built in functions to calculate return values. Is there an...

I have a requirement to open an html format document which is not on my Intranet server using code. The reason for this is we have multiple sites and want people to open the document on a local sever to keep network traffic down. I can do this using the following link on a page <a...

Hi We have a problem with MS query on an Oracle database which has worked for a number of years in Office 98 and now fails in XP. The situation is we have a manager who has a workbook with a large number of sheets each with a query on an Oracle database. Each of these extracts is refreshed daily...

I have a simple problem, but can't find an answer. I have a series of plain text files most lines of which have leading spaces (there are varying numbers of leading spaces). I need to be able to read in the data a complete line at a time into a table and include the leading spaces. I have...

I have been asked a question regarding the following problem. A department have set up a number of linked spreadsheets which include the server name in the link. Due to upgrading and rationalisation the server locations are being changed. Refreshing all these links is going to be a major task...

Does anyone know if there is a limit to the number of characters in a cell which will wrap. I have been handed a spreadsheet which has cells with a large amount of text and wrapping enable. After about 1200 characters the wrapping stops on the last line of text. I can't find any reference to a...

I have a couple of fairly simple applications which allow users to add and update records. These are user specific so there is problem with two people modifying the same record simultaneously with all the problems that entails. I have been wondering, if we expand this, how do I prevent two...