Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jontout

    Splitting String in SQL Query

    Thanks both. The end user(s) are aware that they will need to use a colon or they won't get an output and they're ok with that. I'm more used to doing this sort of thing within the front end, it seemed a bit more clunky to have it included in a sql statement, but it seems to run without any...
  2. jontout

    Splitting String in SQL Query

    Hi all. I've written the following code to enable the storage of 2 values in one form field using a colon as the delimiter - rather than redesign the form which we don't have access to do. select policy_key, substr(pol_notes,1, (instr(pol_notes, ':')-1)) netret...
  3. jontout

    Cannot turn off hyperlinks in Word 2007

    Are all new URL & Email address plain text after making your AutoCorrect changes? Have you cleared the tickbox in the AutoFormat tab as well? Cheers, Jon
  4. jontout

    Getting Other Columns From a Combo Box's Data Source

    Hi Auguy, I have a similar feature on a form, the combo box uses a Data Bound Item, with the Data source set to an existing table adapter against the User table. The Display Member is the Username and the Value member is the Primary Key of the table being queried. I have the left the Selected...
  5. jontout

    move data from one database to another

    Not an overly tecnical response, but considering you're using Access - I'd use Windows copy and paste to create the archive and manually purge any historical data, then compact and repair?
  6. jontout

    IIF Ignores Divide By Zero in Report Viewer

    [code] =IIF(SUM(Fields!LIVE_NET_RETAINED.Value) <> 0, sum(Fields!LIVE_NET_RETAINED.Value) / IIF(SUM(Fields!LIVE_NET_RETAINED.Value) <> 0, (SUM(Fields!VARCONV.Value)), 42), 0)code] Thanks Andy - I'd played with a nested IIF about an hour before, based on something else I'd found and dropped...
  7. jontout

    Using VB to talk to ADSI - Write to Users

    something along the lines of... objUser.Put "homeDirectory", "\\Server\HomeDir\SAMAccountName" objUser.Put "homeDrive", "H:"
  8. jontout

    IIF Ignores Divide By Zero in Report Viewer

    Hi all, I'm having a rare old time with a feature of Report Viewer, passing details from a SQL query via Oracle - these don't appear to be an issue as not other parts of my report are failing, however this line in a report viewer cell is causing no end of grief...
  9. jontout

    Setting up printer problems

    Are there compatible Vista drivers available for your printer? If not, you could try installing 7zip which will allow you to view the contents of the .exe file and potentially drag them to your desktop to help with the installaion.
  10. jontout

    Rollback IE8

    I tried to remove IE8 when I upgraded to Win7 and got nowhere fast. Also tried Chome, IE9 and then put on the latest stable release of FireFox, which uses less CPU than either of the other browsers I tried. While it doesn't fix the issue, it does make it go away!
  11. jontout

    How to create an app that will silent install

    Morning all. Not sure if anyone's asked this before, I certainly can't find a similar post on here. I've created an app in VS2010 which uses Report Viewer and needs to have this installed seperately - we have other software which uses RV, so I'm not bothered about including it in the build...
  12. jontout

    Select Into

    Thank for the tips Dagon.
  13. jontout

    Select Into

    Hi Carp / Mufasa, Sorry, typo on my part - the sql is actually WHERE TRUNC(LOG_CRT_DATE) =TO_DATE ('18-FEB-2011 00:00:00', 'DD-MON-YYYY HH24:MI:SS'); Not really sure what I'm expecting to recieve in the dataset, nor am I overly 'aware' of what the datatype DATE should store. All of the data...
  14. jontout

    Select Into

    Thanks Dragon, that worked a treat, and thanks for the note with the Date criteria, hadn't really realised that before! The date format in the database I'm working with shows dates as DD-MMM-TT, so 22-FEB-11 would show for today. Thanks again. Cheers, Jon
  15. jontout

    Select Into

    Hi everyone. I've been staring at this piece of code for a couple of hours now, and I can't see a reason as to why this would fail. I've based the code on something I've used on other platforms, but I'm still fairly new to Oracle... SELECT LOG_KEY, LOG_USER_CDE, LOG_SHORT_DESC, LOG_CRT_DATE...
  16. jontout

    User Login Name in User Field

    If you don't need to rely on username & password (if your users have already logged into a networked workstation) you could use http://stackoverflow.com/questions/677112/how-to-get-logged-in-users-name-in-access-vba to pull the UID from their login details?
  17. jontout

    Loud Office environment - Sidetone Adjustment

    We've recently upgraded to IP office - Avaya 9620 & 9630's, have similar problems with ambient noise and it turned out that the headsets that we previously used (Plantronics CS351) are incompatible with the new kit. A good test of this was to have the other person hit the mute button on the...
  18. jontout

    Antivirus for Nokia

    AVG Mobile Security 1.24 for Symbian
  19. jontout

    runtime error 2004

    I'd should probably also add, that if I had time I'd be inclined to export the data to Excel check the integrity and import back into freshly created, identical databases...
  20. jontout

    runtime error 2004

    You'd open the main table in design mode, and assuming you have an AutoNumber field as the Primary Key, you would remove the PK from that field, change it to a number - save the table - then add a new AutoNumber field as PK and remove the original field. I can't think of a tool that does this...

Part and Inventory Search

Back
Top