Search results for query: *

Thanks for the reply. I need to extract the information in XML format and I am not sure how I can hide the field. I would like to automate it as much as possible.

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

That works an absolute treat! Many thanks for the quick response. Justin

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 HarleyQuinn Yes printing directly from IE8 works fine. I have also disabled Script Debugging Internet Explorer and Other in Internet Options but still does the same. Thanks for your help so far

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 have just tried the code again and it miraculously worked. Didn't change the code at all. Sorry to waste your time Thank you anyway.

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

Sorry. Just figured out how to do it. Changed the Dataformat of the field on the datareport to Boolean. Thanks for your time.

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

Figured it - needed to use the PARTITION BY as well as ORDER BY clause. Ta

Thanks ArunPrithviraj for the quick response. I have tried that it does not quite come up with the result i am looking for. That adds the row number so the records are numbered 1 to 118 (the select query returns 118 rows). I want the number to be reset everytime the policy number changes.

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 Gonna start dishing out some stars. The problem was with the mouse. I have just been told that the mouse's wheel wasn't working, so i changed the mouse but the same was still happening. That was until i clicked the wheel. Now everything is fine. Thank you for the help from everyone.

Hello All Nope they don't have a little red button on their mouse. The problem started happening wither their current mouse so they couldn't of turmed the function on with another mouse and changed it over. HELP!?!?!?

Thanks GlennUK but the XLSTART folder is empty. Im starting to think there might be no solution to this problem and have to store it in the xfiles.

Hello All Thank you for all your help. In response to your ideas, am sorry but none has worked. xlhelp - I have tried changing the mouse driver from a HID to a USB driver. Also uninstalled and reinstalled in device manager and installed a new mouse, ps2 and usb. cckens - No Ctrl key is stuck...

Hello anotherhiggins The fault is more like your first example but when the mouse is moved the highlighting moves with it. Clicking of the mouse doesn't work, the mouse won't release the highlighting of the cells.

Hello Thank you for all your help so far. I have tried all these ideas and nothing is working. I have even tried reinstalling office. In response to Helenp1983, logging in as a different user has the same result. I read somewhere on Tek-tips about Ghosting, but i am not too sure about this...

Hello Yes i have changed the mouse with the same result. In other programs there isn't a problem, just excel. Help??