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

Hi, I know it is a very long time since this post but I solved a similar problem today (9th April 2008). If this is still an issue I can tell you what I did. Sandy

Have a look at http://support.microsoft.com/kb/306397 for using sql to query Excel. As I recall from a previous existance a few years ago this worked very well in classic asp pages and might work here. Just a thought. Sandy

See http://msdn2.microsoft.com/en-us/library/aa211471.aspx Sandy

Try Const conFilePath = "j:\OSCHD\ACCESS\pam\" Sandy

Hi Skip, just to let you know that I finally fixed the problem. There seems to have been a control character in a database field which caused the XML interface to crash. Sandy

Hi Skip, thanks to your help I think that the Excel list box is working OK. There is something defined either in the workbook code or the ASP page generating the XML which doesn't like numbers in excess of 2000 (or similar) which I will now have to find. Many thanks for your assistance. Sandy

Hi Skip these are the references I can find Private XResp As MSXML.DOMDocument If XResp Is Nothing Then Set XResp = New MSXML.DOMDocument XResp.async = False End If For j = 1 To 6 XReq.documentElement.setAttribute WSheet.Cells(HeadingRow, j).Value, CellX.Offset(0, j - 1).Value...

Hi Skip thanks for the continued help. this is the code I think you need Dim ENode As IXMLDOMElement Dim XN As MSXML.IXMLDOMElement The project references include Microsoft XML, version 2.0 Sandy

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

Thanks Chip, I wasn't sure where to put this. I'll look into it and get the rest of the information. As far as I can tell it uses XML from an ASP page to communicate with the db so it may take me a little while as fixing this is in adition to my normal work. Many thnaks Sandy

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

Thanks for looking Ca8msm, the code for the datagrid is: <asp:datagrid id=DataGrid1 runat="server" Width="256px" AutoGenerateColumns="False" DataKeyField="ID" DataMember="SOURCE_DATA" DataSource="<%# DsRealThing1 %>"> <Columns> <asp:BoundColumn DataField="ID" SortExpression="ID"...

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

Aah I see. Many thanks I will give it a go. Sandy

Thanks SQLDenis, THat's given me an idea for something else I have to do. I was hoping to create something I could run everynight to update (drop and recreate) a table in a database. THis seems to be something which works in ASP or VB? Sandy

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

Just because you are paranoid it doesn't mean that they are not out ot get you! Sandy