Search results for query: *

Hi people, I have a list of records as follows 0007 16/01/2003 3 Surv 0008 10/07/2003 5 Surv 0012 10/01/2005 3 Surv 0015 10/05/2005 3 Surv What i have been asked to do is compare that last surveillance with the last but one surveillance. So what i want is a formula i can use or something...

Hi, I have a bit of a dilema, i think it should be really easy but i just can't seem to get my head around it. I have a table VISIT_HEADER and this holds information about the VISIT i.e Charge Days and the Visit Type. Then i have an ASSESSOR_BOOKINGS table which holds the dates of the Visit...

I use this formula in my report NumberVar lPartDays; StringVar sDayAss; StringVar sTemp; sTemp:="ppppp"; If sDayAss = {TBLASSESSOR.STRKNOWNAS} then lPartDays:=0 else lPartDays:={@WorkDays}; sDayAss := {TBLASSESSOR.STRKNOWNAS}; lPartDays This Formula is supposed only give me...

Hi, I have the following code Dim dsShoppingBasket As DataSet Dim dtDelegates As DataTable Dim dsCompiled As New DataSet Dim dtShoppingBasket As New DataTable dsShoppingBasket = Session("dsShoppingBasket") dtDelegates = Session("dtDelegates")...

Hi all, I am having a bit of a nightmare i am creating controls at runtime in a panel, in another panel and then inside a table. The only way i can figure out how to access these dynamically created controls is with this massive loop/if structure. Does anyone know of an easier method. For...

Hi all, I am having a bit of a nightmare i am creating controls at runtime in a panel, in another panel and then inside a table. The only way i can figure out how to access these dynamically created controls is with this massive loop/if structure. Does anyone know of an easier method. For...

Hi All, Can i use LEN in ORACLE SQL. If so does the data have to be of string type? If yes is there a convert to string function. I have numeric values in a field e.g. 8, 88, 888, 8888 and i would like to know how long they are. Many thanks for help in advance Deleco Deleco

Hi, I have 100 machines that i look after on my network and i want to be able to find out what software they have installed at any paricular time. So for example i want a server application and i give it the machine name/ip address and it returns all the software installed on that machine in...

Hi, I would like to use an in-line IF statment my oracle SQL it does not appear to work is there any other way of doing this IIF([FieldName]='Expert', 1, 0) I am using the Crystal Reports Command feature this allows me to USE SQL to narrow the amount of records soming back. Apparently the...

Hi, I would like to use a Command to narrow down my record selection. This is OK but i would like to use an in-line IF statment in the command as follows IIF([FieldName]='Expert', 1, 0) Has anyone done anything like this before as i do not seem to be able to make it work. I am accessing an...

Hi All, Im a bit stuck and need help with a formula, let me explain. Below is the data GH Dean Full Time D Gardner D Carpenter D Carpenter D Carpenter D Plumber What i need is to set a formula to put in the group header, if in any of the details there is Carpenter then i want...

Hi all, I am using the Crystal Reports ActiveX viewer in my VB project. I am trying to view a report and the ActiveX viewer keeps hanging and showing as Not Responding in the Task Manager. I have left the report running all day and it still does not display. If i run the report in Crystal...

Hi all, I am using the Crystal Reports ActiveX viewer in my VB project. I am trying to view a report and the ActiveX viewer keeps hanging and showing as Not Responding in the Task Manager. I have left the report running all day and it still does not display. If i run the report in Crystal...

Hi, Not sure if this is posible but... Is anyone aware of a way to open a Form when a user double clicks on a table in a word document. Regards Deleco

Hi All, I have a bit of a dilema. I need to create a report which shows a persons downtime. There is a diary table but this only holds the dates that appointments are booked for. Has anyone got any ideas Any help would be appreciated Deleco

Hi i have a little problem i would like some help with. I have been asked to create a report of customers that have all 3 specific codes. The report will consist of two tables Customer and CustomerCode which has a one to many link between Customer and CustomerCode. I can easily create a...

Hi All, I have a database which contains RTF (rich text format) syntax in a field. I would like to take this RTF text and put it into a Word document and see what the RTF should look like not the Syntax it self. For Example Some bold text - Correct format RTF Syntax stored in DB for text...

Hi Can anyone help, I don't want a user to enter data into a table in word when they try and type in the table i want to prompt the user with a form to enter the data, does anyone know a way of doing this. Thanks for any help in advance. Deleco

Hello, I have recently been made aware of a built-in sub in Word VBA called NextCell which allows me as a coder to overwrite what Word does when a user moves to the Next Cell of a Table. This was very useful for me as i could stop a table growing. Does anyone know if there are any other...

Hi, I have a problem i need to produce a report which adds up the amount of days worked from a diary system. The problem is that the total amount of days for an event is held in a table linked to the actual diary bookings table. Therefore there maybe multiple diary bookings which add up to the...