Search results for query: *

RhythmAddict112, I might not be completely helpful to you as I cannot simulate your problem. What I could suggest to you is this: ListItems are members of RadioButtonList. Try accessing them using a foreach (C#) or For Each (VB.NET) loop or try obtaining a reference to IEnumerator interface...

what you should be able to do is to use yourListItem.Attributes.Add("onClick", "what ever needs to be done");

Hi, I have a multiple resultset returned by the stored procedure (4 select statements returning different scalar values). When I call SqlCommand's ExecuteReader on the following piece of code: cn = new System.Data.SqlClient.SqlConnection(ConnectionString); cn.Open(); SqlCommand cmd = new...

When you create a view, derived table or subquery, you cannot put ORDER BY unless you put TOP in the query, eg. USE pubs GO CREATE VIEW test AS SELECT * FROM authors ORDER BY au_id This causes an error message 1003. I was not able to find the right explanation about this, and I very rarely use...

I don't think you can rename the server. What you can do is to register another server and then using DTS package, transfer your tables, SP's and so on into the new one.

I think that locks should not be the problem because the minimum value is 5000 locks. There is no way that upsizing wizard can use more than that, and if it does than it is a problem with the upsizing wizard. Access 2K upsizing wizard works just fine. Instead of all the fuss why not just using...

Would you guys be kind to tell us the procedure (step by step) and explain what you did oneach screen. I've just upsized one database and it worked great. It displat report at the end to tell you what it did. I would like to simulate the same problem. One more thing which Access version are you...

Wouldn't it be easier to create separate text boxes and when the user clicks the button it enters it into the database and shows it in the combo box. Combo box are as far as I know selection only. You could however have the user double click the combo box and then enter the information. The...

I've just tested MS Access (actually Access 2K) and there is a split function. IF it is NOT in 97, I do apologize. But it works just fine in 2000.

Use Split function which creates a one-dimensional array

It's not the SQL Server. It is Microsoft Management Console (MMC) that caused the problem. You might have to re-install it. See if there is anything on Microsoft's site about MMC.

Zip Disk had this utility which could make a disk non-removable. I don't know if you have that on Jaz (it makes sense to have it). Make you disk non-removable, if you need to restart the computer restart it and then do the backup. When you go to backup, add another device and it should show your...

You might as well create a DTS package to do it. It will keep all the indexes, triggers and other things, but in order to do this you must have exactly the same SQL Servers, e.g. you cannot transfer from Enterprise into Desktop but you can do it Desktop > Enterprise.

You could also register the component with REGSVR32.EXE which is located in your WINNT\SYSTEM32 Locate you OCX or DLL file and drag and drop.

I am not sure what you but below is how I understood you. Are you accessing SQL Server or some other database? If you are using SQL Server than in order to get list of all the table in your list box you would say SELECT [name] FROM myDatabase..sysobjects WHERE xtype= 'U' AND status >= 0 ORDER...

shyamMelwani this is all fine for two or three records. But when you want to create a pivot table with bigger number of rows, this would be very complicated procedure. In way it is pity that SQL Server does not have pivot table ability like the one in Access.

In Access 2000 create Access Project and you will have both Views and Stored Procedures. Office 2000 comes with a cutdown version of SQL Server 7.0 and you use Access as an Enterprise Manager

This is just to share it with you. I am using Access 2000 and when I am using reports to join two fields I get an error #Error. The problem seems to be that the NAME of the control matches one of the names (fields) from the table/query. Eg.<br> <br> Lets say we drag a field called Lastname to...

You might want to use Len function to determin the length of the string, then use Mid function to check when the next character appears after space and then Left(UCase(MyString),1). <br> <br> I'll show you something I've done just to give you ageneral overview, but you'll have to modify the code...

You can also place DISTINCT in SQL text window:<br> SELECT DISTINCT (the rest goes here), but if you are doing counting then<br> SELECT COUNT(DISTINCT *) .......