Recent content by stephenk1973

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