Hi, I sell clothing, I need to count the number of times an item style is listed, ignoring the size, and then copy and paste the data into the fields below. Here is an example. The data is in 5 fields Item # Style Brand Color Size 5275 Ziggy Electric Navy/Tan S 5276 Ziggy Electric Navy/Tan M 5277 Ziggy...

Hello all, my website's forums built on asp.net give me a problem recently. When new users add a new post, the post does not contain the user's id and it gives an error on the website. Now, I have identified the 2 posts that give me the error. Both have as user id=0 This is the mistake. When...

I'm trying to run eseutil on our exchange 2003 server in order to determine if there's an issue between the exchange database & Goldmine CMS software. When I tried to run: C:\Program Files\Exchsrvr\bin>eseutil /k "d:\exchsrvr\mdbdata\priv1.edb" I recieved the following error...

I have SQL 2005. Until recently I cound import and export data easily. Now I get this error: SSIS dataflow task could not be created. Verify that DTSPipeline.dll is available and registered.... DTSPipeline.dll exists.

Hi there, I am facing a challenge to decide which tech is good for passing data between two windows applications (for Win2k). - ActiveX automation or DDE? It would be greatly appreciated if someone gives me an ActiveX (or DDE?) sample/Link to a simple sample to show how the server and client apps are...

I'm a newbie to Microsoft Access, eventhough I know how to create tables, etc. I don't know how to start creating dynamic forms using the Data Access Page feature as I was enquired to build an online web based system using MS Access. I was wondering on where I can find online guide to Data Access...

Hey guys, I am using this code to convert the encrypted data into string CryptBinaryToString((BYTE *)pBufPtr,len,1,msg2,&lul_buflen); The msg2 looks like "KBeMW9yLvHwMow5dKCXO3ddKLzIGQTmbtNVmmFF2FmT9/f39q6urq6urq6vu/u7+" and I am using the following functions to convert the string to...

Is there an easy way to convert rows of data across multiple columns into a single column of data? I need to calculate values for and then create a text loadfile that can be imported into another application. Here's an example of the original spreadsheet: ALPHA01 |ALPHA02 |ALPHA03 |ALPHA04 | BETA01...

I have an access database that is used as a "one-stop-shop" if you will for all resources that my team uses. One thing that I want to do is have each user store their username and password for a specific website in the database. Then create a link on a form that they can click on, and they...

I am trying to use custom paging and sorting with an object datasource, so far so good until I try to filter it down by a guid, then I get the following error: The data types nvarchar and uniqueidentifier are incompatible in the add operator. Here's my SP code: set ANSI_NULLS ON set QUOTED_IDENTIFIER...