Search results for query: *

Works, much appreciated.

Am trying to write a stored procedure.. Sort of.... SELECT CASE @prmFlag WHEN 'O' THEN (select @prmTDate = @prmTDateOpen ) WHEN 'C' THEN (select @prmTDate = @prmTDateClose ) END Does not like the select ( or set) All advice much appreciated. Kind regards Stephen

Please ignore..all sorted ....need the access program path at the start...amazing how as soon a you post you work things out.

I have upgraded a db to 2003, some users are using access runtime, they do no longer seem to hit the security workgroup. The shortcut they are using is.... \\Server\MARKET.mdb /wrkgrp \\Server2\Security.mdw Is there another tweak i need to complete? Thanks Stephen

Zero is a type..Full code.... Dim dbs As Database Dim rst As DAO.Recordset ' Calculate the total net holding accross all funds and currencies Set dbs = DBEngine(0)(0) Set rst = dbs.OpenRecordset("select sum([HOLDING]+[Movement]) as TotalHolding from [Stiff Table] where [Stiff Table].Fund like...

I have upgrade a an Access 97 db top 2003, one of the functions returns a 3420 error execute, falling over when closing the record set. Code is quite basic Dim db as database Dim rst as DA0.recordset set db=dbEngine(0)(0) set rst = db.OpenRecordSet("select.....") rst.movefirst 'Do some...

I have a cross tab query for which i cannot be sure what the column header will be. Can i add form field dynamically? Thanks Stephen

I have a form whose record source is based on the following query..... SELECT * FROM Archive WHERE CONTAINS (*, '"Winston"') The text, in this case 'Winston' come from a text field in the search form. How do i deal with increased complexity in the search criteria? Has anyone an example vb...

I have a java scitpt to open a window on the click of a image button, but when clicked the new window opens but the original screen refreshes. How can i stop this. Code as below. Thanks Stepehn Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As...

I have a text file on which i would like to get rid off anything after a certain phrase. Basically it a import for a database and the last import is no longer required. My text file is of the format.... *tab_imp1 001 002 003 *tab_imp2 003 004 006 I do not want to do the second imports so i...

I was wondering if there a way of having permissions set when creating the link as part of the link command?

Sorry to maybe ask an obvious questions but i only touch on UNIX once in the blue moon. I have a created a symbollic link between two directories, however the permissions on the target directory does not give read permissions to the owner of the destination directory. What ways are there around...

I'd like to display them as thumbnails.

I have a direcoty of images. How can i can i create a list of these images as a datasource for a thumbnail page? I have tried creating a object datasource and corresponding buisness object but to be fair i'm not sure if this is the correct method...... Namespace PubsClasses Public Class...

Cheers, have a solution though i back tracked a little. I had to build my datasourse as some of the parametes being passed to the stored procedure need a bit of formating ( check box list with multiple values), any how i end up formatting these into non-visible text boxes and linked the stored...

Have tried the buffer and clear but no positive out come. I think my issue is in the binding, the button is on a master page i'm tring to make quite i generic export, when the datasource is built it doesn't know what to bind back to so returns nothing good. Your code calls...

I have a stored procedure which i use to populate a gridview. Some of the gridview columns have visible set false but on export i make them visible by looping through all the columns. My export button is on the master page, code, .... Dim gd As New GridView gd =...

I have tried to create my first custom validation on a text box using funciton on the net. The text box is to be passed to a stored procedure. Validation always returns false, i'm not sure if the funciton is being called at all. Validation occurs when you press 'enter', and it always seem to...

i added the following to me web.config, weather the value is 2 or 2000 the page still times out after 30 seconds. <httpRuntime executionTimeout="200"/> The page in in a master page, could this confuse it? Thanks Stephen

I'm running a stored procedure on my SQL Server, it takes a minute or two depending on the passed parameters. When i attach my .Net page the page always times out after 30seconds, but in may sting i (think) i have set the timeout to 200s. web.config as below.... Where should i be setting the...