Search results for query: *

Hello, Our website is designed as follows: There is a header.php file, a footer.php file and there are several content files, like personel.php which use the templates for the header and footer. In the header.php file is all the javascript. We would like to implement an image popup when our...

Hello, I have a query which shows several campaigns with their belonging information. What I try to do is to display the grouped campaigns which start with the same 3 charactersers. Each campaign has a main id. These 3 characters can be different per main id. Example of the fields which...

Hello, I use the below query to display the count for the records which where entered the last 30 minutes. The problem I have is that it doesn't go over the night. We enter records from 21.00 hours until 09.00 hour the next day. When I use this code it doesn't go to the day before. For example...

Hello, We have an office with 50 workstations. We use a file/print server for the users documents and other files. Our users can login at every workstation. Because of that on each workstation are a lot of directories for each user in the C:\Documents and Settings\ directory. I would like a...

Hello, We use a script for generating shortcuts on the client desktops. On a few clients we have installed extra software which is not on the other clients. Now, on the clients where the additional software is not installed, comes up shortcuts which are useless. Is it possible to check if the...

Hello, We have an Excel file with, for each week, a different sheet. In each sheet are names of employees in it in a colomn. The names (unfortunately) can change each week. After each name is a figure telling how many vacation hours they have build up that week and a figure telling how many...

Hello, I hope this is the right forum to ask the following. I am looking for a solution which can do the following: - upload all files in a certain directory on a scheduled time - move the succesfully uploaded files to a newly created folder in the following format "uploadedYYYYMMDD" (example...

Hello, I have serveral queries in Access: UPDATE nawt SET field1 = '4' WHERE CODE='4'; UPDATE nawt SET field1 = '8' WHERE CODE='8'; UPDATE nawt SET field1 = '1' WHERE CODE='1'; UPDATE nawt SET field1 = '10' WHERE CODE='10'; UPDATE nawt SET field1 = '3' WHERE CODE='3'; UPDATE nawt SET field1 =...

Hello, I have a field Login (string) containing login times (hhmmss) and a field Logout (string) with logout times (hhmmss) off users. It can happen a person logs in more than 1 time a day. So for one day it can be: Login 095510 095834 123404 Logout 095723 100312 165602 I would like to only...

Hello, We have 2 databases Ident and Log In the Ident dbase is a field Ident, which is a number. In the Log dbase is a field Log_Ident, which is a string. It cannot be linked when adding the dbases to the report, is there a work around for this? Kind regards, Age

I have a field VOICENAME which can contain a wav file name like "todaysdate.WAV". It can happen that there is no filename available, all those empty filenames must print out the field NONAME and the extension .bad, it must show up like "agentname.bad" I have created the formula below to check...

Hello, I hope this is the correct forum to post this question. We have a login script where the below is being run: WriteValue("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run","Norman ZANDA","c:\norman\bin\ZLH.EXE /LOAD /NOSPLASH","REG_SZ") When the script is run on an...

Hello, I have a report with 2 groups; 1 for the date and one for certain statusses. It now looks like this: 12042005 not interested 3 wrong number 5 ----- a lot of other statusses ----- contract 1 year 3 contract 2 years 2 flex contract 5...

I have a report where sometimes a lot data is in a certain field like: name address city remark1 remark2 remark3 remark4 ---till remark100 But sometimes there are only 2 remarks present, like: name address city remark1 remark2 When I designed the report I adjusted the height off the field so...

Hello, I have in my report a group on a qualification field. When looking at the report there is: callback 28/02/2005 at 10.15 callback 28/02/2005 at 10.17 callback 28/02/2005 at 10.19 callback 28/02/2005 at 10.20 callback 28/02/2005 at 10.21 callback 28/02/2005 at 10.22 callback 28/02/2005 at...

Is it somehow possible to find out how my current Apache (version 2.0.40) is compiled/installed? I want to upgrade to the latest version and was hoping there might be something like php has with phpinfo() which displays the current config. I looked at...

We would like to use Crystal Reports also for reporting. CMS is on a Sun machine. Has anyone been able to connect to the dbase? If so, please tell me how you did it. Kind regards, Age de Jong

(posted it in Other Topics, but I guess it belongs here) I have a report whichs generate data about past day's. I want to sort the report in weeks and I use a function @groupbyweek: {STARTDATE}-dayofweek({hdvdn.STARTDATE})+2 to tell Monday is the start date. The output I get is as follows...

I have a report whichs generate data about past day's. I want to sort the report in weeks and I use a function @groupbyweek: {STARTDATE}-dayofweek({hdvdn.STARTDATE})+2 to tell Monday is the start date. The output I get is as follows: 28 october - 27-10-2002 120 - 28-10-2002 040 - 29-10-2002...

We want to report the average call handle time for our call center. The standard average function works fine for all the values, but it also uses 0 for the average calculation. For example: mo 120 (seconds) tu 145 we 160 th 116 fr 217 sa 61 su 0 (no calls received) Crystal says (correctly)...