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!

  • Congratulations strongm 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: *

  • Users: Tarnish
  • Content: Threads
  • Order by date
  1. Tarnish

    empty string in access null error in sql server

    Not really sure where I should ask this, and I'm sure the answer is already on the forums somewhere, but... I am converting ms access 2003 split f.e./b.e. to ms access 2010 f.e./ms sql 2012 b.e. I'm deploying to win7/64 bit desktops running 32-bit office 2010. I've run into a number of issues...
  2. Tarnish

    Case Statement in View in SQL Server Management Studio/sql server 2012

    Hi, I'm new to sql server and I'm using sql server management studio to help me convert some queries for use on sql server 2012 in the form of views. I'm trying to use functions to create some columns in the view, and none of them seem to work properly. Specifically, this fails: CASE...
  3. Tarnish

    Parsing xml document into table

    Hi all, I'm looping through a folder and pulling xml files (one at a time, obviously) into a variable in a procedure in vba. I've tried importing the xml files but each file produces multiple tables and the tables simply don't work well together. I've also tried applying a transformation file...
  4. Tarnish

    Create table from search of files in folder

    Hi all, I need to setup something where I can go to a folder, loop through the files with a certain extension, and search them for a specific url. When I find the url I need to be able to return the filename it's in. The folder is known, as is the file extension. I've looped through a folder...
  5. Tarnish

    Eliminate records with older dates but same value for other field

    Hi all, I'm rusty with Access but if I could just get an idea how to proceed I think I could figure it back out. I have a table of data I've imported from an excel spreadsheet. There is no primary key (other than one I added during the import that I don't think helps here). The table is...
  6. Tarnish

    Hyperlink Display Text

    Hi all! My Access is rusty and this seems like it should be simple.... I have a hyperlink field on a form, which is based on a query with a field that contains local file addresses (one per record, of course). When you click on the field in the form (datasheet), it opens the document at the...
  7. Tarnish

    Getting Custom Master Page into Sharepoint 2010

    Hi all, My organization has just bought Sharepoint Server 2010 and setup a development environment. I have zero experience with Sharepoint. I've gone into a site and created a couple of pages and added some things like links, comments functionality, etc.....all basically canned solutions that...
  8. Tarnish

    HTTP::Date - Only first two functions exported by default

    Hi all, I'm trying to use the HTTP::Date module which I believe is a part of the libwww-perl package. I believe I've properly installed the libwww-perl, and I've tested a little code using one of the functions from HTTP::Date and it seems to work. However, the function I tested was one of the...
  9. Tarnish

    WWW:Mechanize or HTML:TokeParser or what?

    Hi all, I'm not proficient with Perl at all, but I have a wide array of other programming experience... I'm trying to scrape a web page. Specifically, I'm trying to scrape data from a table with two columns. The first column holds one date per row (ex. 9/14/2009). The second column holds a...
  10. Tarnish

    xslt build onclick event?

    Hi all, I need to use xslt to build an onclick event for a link. I have an xml file that contains a bunch of variables (in one node) that I need to feed into a function. Anyone know how to do that? Thanks, T
  11. Tarnish

    Link javascript file in xml file?

    Can external javascript files be attached to an xml file like xsl and css files can? Thanks, T
  12. Tarnish

    Noob xslt question

    Hi all, I'm new to xml/xslt. I'm trying to use a small amount of xml in an existing web page. The web page is NOT dynamic. I'd think I could use regular xhtml/css for most of the page, but then include some xml (formatted with xslt) for the specific areas I need that data. Can someone...
  13. Tarnish

    Reusing FSO object variables

    Hi all, This is probably a dumb question, but is there any reason why I can't 're-set' a variable after I'm completely done with using it in it's prior context? For example, let's say I have these lines (leaving aside variable declarations): Set obj2FSO =...
  14. Tarnish

    Permissions property values

    Hi all, I'm trying to write some code that will ultimately allow me to check the current database permissions on the forms against a table storing values for the same, and modify the current values so they matched the stored ones, if necessary. It's not that uncommon for me to push an update...
  15. Tarnish

    subform delete using record selector raise event?

    Hi all, Does deleting a record by clicking on a record selector and hitting 'delete' on the keyboard raise any events? I tried the 'on delete' event of the subform the record is in and it didn't seem to work. Thanks, T
  16. Tarnish

    Cascade updates

    Hi all, I've got some old apps with cascade updates set in many of the relationships. Nearly all of them (maybe all of them) are autonumber primary keys that aren't seen by users, and certainly aren't exposed to users for editing. That would seem to mean that the cascade updates is never...
  17. Tarnish

    Pivot Chart/Crosstab Query/Other?

    Hi all, How can I get years to appear as separate lines in a line graph in a pivot chart? I have a date in records that is the date the record was opened. I have multiple forms displayed as pivot charts in separate subreport controls on a report. One of the pivot charts currently charts the...
  18. Tarnish

    Apache 2.2.8 enabling ssi/shtml

    Hi all, I'm kind of new to apache administration. I've recently added 2.2.8 to my notebook for use with web development but I've run into some config (I think) problems. When I try to test a page with the extension .shtml the page just loads as text. I think I am also not setup to handle...
  19. Tarnish

    Parsing string in php

    HI all, I need to parse the end of a string that is a windows file location. So the string looks like /www/sitename/index.php I want to get the index.php out of the string (and all strings like it). Someone point me to a link or something? I've just started to work with php/mysql so every...
  20. Tarnish

    Run external application when jbutton clicked?

    Hi all, I'm new to java. I need to start an external application when a jButton is pressed. I have the button, it's event listner, and the actionPerformed method that will run code based on which button is pressed. Now all I need is the actual code to run to get an external app to open! Can...

Part and Inventory Search

Back
Top