Search results for query: *

Hi, Is it possible to add fields into a SELECT query in SQL based on whether the field contains data? For example I dont want to display the field 'telephonenumber' unless there is a telephone number set. Thanks

Hi, Due to bad table design (not my design either i am quick to point out!) i am having trouble with a select query. Records are stored in the table as follows: Histid Eventtype 2 Notes: This is a test note. 2 Type: Free Format The notes in eventype on the...

Hello All I have a vb program which prints displayed webpages using the following code - WebBrowser.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER On a couple of computers the program displays the script error 'res://ieframe.dll/preview.js' With the option to continue running script...

Hello I am using the below code to try and get the last modified date of a web page/file but all i get back is nothing. Inet1.OpenURL("www.microsoft.com") msgbox Inet1.GetHeader("Last-modified") This does work when i use 'Content-length' as the GetHeader. I can't explain it and after...

Hello I have created a datareport which displays results from a recordset. At the moment Yes/No fields are being displayed as -1/0 values. Is there anyway to format these results to display Yes/No before being displayed on the report? I am currently displaying the results by...

Hi, I am running a select query that identifies added riders on our system. It produces the fields policynumber, name and dob. When there is more than one added rider i get 2 rows which have the same policynumber and different name and dob. What i would like to do is assign a number to each row...

Hello All We are using Microsoft Excel 2003. When the user clicks on a cell the mouse is then stuck highlighting cells where ever the mouse moves. This can not be released by anything apart from closing excel from the menu bar or task manager. Thanx for your help.

Hi, I am having an incredibly frustrating problem on a windows XP machine and would appreciate it if anybody could give me some advice on how to get round it. I have 2 network cards installed on the machine, they both appear in device manager and state they are working properly. When i boot...

Hi, I am having trouble creating a report in SQL. I have a table with client data in it which links to a table with telephone numbers for clients. Each client could have 3 different types of number, work, mobile or home. At present my report returns 3 rows of data for a client with 3 numbers...

Hi, I am passing a parameter value to a stored procedure and i would like to check whether this parameter value exists in a particular column of a particular table. I plan on returning different messages depending on whether it exists. Does anyone know how i can acheive this? Many Thanks

Hi, Does anyone out there know if i can stop group policy from applying to a particular computer and if so how do i go about it? Many thanks

I wonder if anyone can help. I have 2 tables, table 1 and table 2. In table 1 i have the following columns: TransactionId Insurer Net Comms In table 2 i have: TransactionId Fee I have added a column named Fee to table 1 and would like to update it with the value from the Fee column in table 2...

Hi, I am trying to create a temp table in SQL Server 2000 from an existing table. The existing table has the following structure: Transaction_ID Tran_Breakdown_ID Amount 0001 Net £25 0001 Tax_IPT £1.50 0001...

I am trying to run a report to find transactions created the previous day. I am using the following criteria: where createddate = CONVERT(CHAR(11),getdate()-1) Created date is a date time field and when i run this query it only returns transactions processed dead on midnight. Any ideas how i...

Hello All I'm trying to grab the Headers and Footers of Word documents and Save them as pictures. I have been trying out a bit of coding that i found on this wonderful forum. The code i have been trying is: Dim myWord As Word.Application Dim myDoc As Word.Document Set myWord...

Hello I'm automating inserting backgrounds into web pages, so far i have been able to insert the following into the htm file and it works: <body background="word.bmp"> The problem i have is that it repeats, what i don't need. The positioning is fine i just need it to show once. And i need the...

Hello I spent weeks designing a programme to save word documents to HTML and then storing them on the web for viewing. I got it sorted and then in my happiest hour, i found a major problem that nearly persuaded me to throw myself out of my 3rd floor window. The problem is that some of the...

Hello I am using inet to transfer files onto out web server but i have come to a sticky point to transferring a folder. I thought it would be the same as the PUT function but this doesn't work. Does anybody have any idea of what needs to be done? Thanx for your time.

Hello I am trying to copy a file to a web server with the INET component. The following is the code i am using: With Inet1 .AccessType = icDirect .Protocol = icFTP .URL = "https://www.somewhere.co.uk" .UserName = "Username" .Password = "password"...

Hello I have been trying for ages to have a typed in query to be stored for later use then variables to be included. For example: SELECT * FROM table WHERE {List} = '{SEARCH}' I have made an application which allows users to write there own queries without the need to use access. The query...