Search results for query: *

I have the following requirements for a stored procedure: It must call a pre-existing stored procedure and pass it a ntext or image object. I have tried the following: Dynamic SQL on a temp table (can't add the text to the string) TEXTPTR (can't convert byte[] back to string) Calling Stored...

Hi, This is a long one, but high-level design question, so I could really use your help. I am developing a web application that enables users to add content to the site. However, depending on roles, their content will have to be approved. I have the following schema: Table_Pages (general...

I have the following functions that enable a page to "remember" choices in navigation (like Windows Explorer and the little plus/minus signs) from page to page. So, if you close a navigation subsection on pageA, and then click on over to pageB, the page remembers you had that section...

Back in the day, I used KPT Vector Effects. This product has appeared to vanish. Does anyone have a great recommendation for creating 3d vector art, either as a plug-in for Illustrator 10, or as a stand alone application that exports to eps. Thanks, f

I have an associative, mulitdimensial array abbreviated here that looks like: var equations = new Array(); equations["Acre"] = ["Meter\u00b2" , "4.046 * Math.pow(10,3)"]; equations["Joule"] = ["Calorie (thermochemical)", "Electron...

Okay, I've got a problem that's driving me crazy. I have an Excel spreadsheet that will be used by people to summarize data. In one column, there are only a handful of choices that could be entered. Therefore, I set up a Data Validation for that column. I created a sheet called Validation, and...

This seems like such a stupid question, but I've looked everywhere and can't find the answer... I have the following code: strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & Server.Mappath("./guestbook.mdb") & ";" But I want to...

I'll need to put SQL commands in a field in front of every record (so that this can be put into another table) like: SELECT 'imagio' As TEST, CL.LMFProjectID, Event, B FROM (... Which is a change on the solution by dalchri on thread701-291171. However, I don't know how to escape out in...

I have some data in a table that has to be reformatted (even into an Excel spreadsheet would be ok) so it can be used in another SQL query to enter it into a new database. Right now, it looks to be a lot of manual data entry, but I'm wondering if something like a crosstab or a group by cube...

I have some data in a table that has to be reformatted (even into an Excel spreadsheet would be ok) so it can be used in another SQL to enter it into a new database. Right now, it looks to be a lot of manual data entry, but I'm wondering if something like a crosstab or a group by cube, might...

A candy bar to anyone that can help me with this one, because I have no idea how to accomplish this. The code so far: SELECT Count(L.ProjectID) AS [Count], L.ProjectID, L.ProductID, L.ProductDescription, L.MNEMONIC, C.ProjectKey, C.Product FROM [L. Data] AS L LEFT JOIN [C.] AS C ON L.ProjectID...

Hi All. I tried posting this to the Access Reports Forum but didn't get a response. Anyone here have a good idea how to accomplish this? Thanks. I have a report that has the labels in a group heading but the containers in the details section. This way, I'm not repeating the Labels with every...

I have a report that has the labels in a group heading but the containers in the details section. This way, I'm not repeating the Labels with every record. The records returned in can vary from null to Many. I have the Labels set up to not be visible when null using: If not isnull([Field])...

Hello all, I'm attempting to write a query that shows when there are multiple ProjectKeys assigned to one ProjectID. This needs to be fixed down the road, but first I must identify them. Some ProjectIDs don't have a ProjectKey at all, and that's okay for now, but I don't want them to show up in...