Search results for query: *

Hi all, I have been struggling with this for a while without success. I need to deploy an access application and moving awayfrom the Ms Access Package Wizard. To be able to create the shortcut target with the right path, I need to check which version of access is installed. I set up a launch...

Hi all, I am using raiserror with nowait for the first time but I am not having the expected behaviour. i.e. if I run the following, I should have the first message immediatley and the second one after 5 secs, but both messages are appearing at the end of the procedure run (as if NOwait is...

Hi all, I am using Access 2003 and need to produce a TOC for a few reports which are about 50 to 100 pages long in the following format Report: ---Main report showing Title/executive summary /new page ---Subreport which contains TOC /new page ---Body of main report There have been quite a...

Hi all, Have been investigating/searching on this without success and hope that someone can help I have a report with different groups/subgroups and want to change the numbering of the subgroups to something different to the numerical format available (1, 2, 4, 4). For example for the first...

Hi all, I have been working on an access 2003 application which is almost ready for deployment. I have been testing the deployment up to now on two virtual machines with access 2003 and 2007 already installed. In the msi package, I am also deploying the runtime. Will be grateful if those two...

Hi all, I have a query which calculates the 'health' status of a system e.g. Red: 15% Yellow: 35% Green: 50% This is used to plot a pie chart. I manually changed the Pie Slices color to match the health description. I.e. The Red Slice will be Red, etc. When changes are made to the system...

Hi all, Was wandering if someone could take me out of my misery. have been struggling with this for a few hours without success. I have to calculate the percentage of tasks completed by category. For a task to be considered as completed it has to meet the following criterias: 1. Task is...

Hi all, I have been struggling to do this and hope someone can help. I have 3 tables which is of concern 1. Building (buildingID, BuildingName, NotActive) 2. Floors (FloorID, BuildingID, Floorlevel) 3. Checklist (floorid, checklistid, checklist, Comments, Review) I created a treeview in...

Hi all, i have a substring in the format: <name>john</name><lastname>Smith</lastname><left>true</left><datejoined>00-00-00</datejoined><member>true</member> i am trying to change part of the substring within the <datejoined>00-00-00</datejoined> to another value from a join with another table...

Hi all, I am trying to use a collation query to find out any discrepencies within dbs/colums E.g query below gives me: SQL_Latin1_General_CP1_CI_AS SELECT DATABASEPROPERTYEX(DB_name(), 'Collation') collation; then I try the query below on the same database: select collation from test where...

Hi all, I have been trying without success to convert a varchar containing date and time(e.g 200702220255320000) into the datetime format 21 with the 'Syntax error converting datetime from character string.' declare @dt char(23) set @dt = '20070222025532000' Select Convert(DateTime, @dt) the...

Hi there, wandering if anyone can help, i need to combine several columns in sql but can't get around it. The '+' is actually adding the values and I tried convert the date to char or varchar but keep having: Syntax error converting the varchar value '04/02/2004' to a column of data type int...