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 TouchToneTommy 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: jwkolker
  • Content: Threads
  • Order by date
  1. jwkolker

    File Copy - File names from Table

    Hello - I have a table of file names that has fields like this path filename destination C:\JKWORK\USATools\jpgfiles 1234.jpg C:\upload C:\JKWORK\USATools\jpgfiles 5678.jpg C:\upload C:\JKWORK\USATools\jpgfiles a2b3_small.jpg...
  2. jwkolker

    Java Popup without <Head> tag reference

    Hello: Help please! I need to write a link to a page and popup a 550 x 350 window for an html page. I can not place anything in the <HEAD> portion of the HTML page since it is templated. I need a self-contained popup solution that will popup the page sized 550 x 350 and is a complete...
  3. jwkolker

    Crystal 8.5 to 7 - Select Criteria Conversion Problem

    Hello: I need to save down an 8.5 report to a 7 report (so that that 3rd party software's dll's can run the report)... At any rate the 8.5 report runs fine using this criteria but the 7 returns errors - are there any issues that can be fixed to have this run in 7 too? Code Follows...
  4. jwkolker

    HTML Mail - what's the trick?

    Hi there - I have a site that sends mail from a script called mail.pl The following let's a user know that a visitor has posted a message for them at the site. I want to cleanup the URL so that it says &quot;Click Here&quot; to pick up your message instead of the dreadfully long URL string -...
  5. jwkolker

    Remove periods and commas from Last Name Field

    Hello: I have a requirement to pass the FirstName, LastName, Middle Name, Suffix and Degree fields without periods or commas to a spreadsheet... I want to run a query to parse out the periods and the commas - here is an example of the data I need to cleanup Norman H. Liu Jr. M.D. First...
  6. jwkolker

    Create Table of List of All Attached Tables, Fields, datatypes &amp; size

    This is what I have: Mulitple ODBC connected SQL Server tables Access 2000 front end This is what I want to do: Want to write a module that will do the following: - Read the table and make a new table containing the following: Field 1 TableName Field 2 FieldName Field 3...
  7. jwkolker

    Rename many files one command at dos command prompt

    Hello: I have many files named like this TFW001234_jpg.jpg TFW001235_jpg.jpg TFW001236_jpg.jpg and so on... I want to change the whole lot of them to be TFW001234.jpg TFW001235.jpg TFW001236.jpg They all reside in the same directory and I am trying to us the dos command rename TFW*_jpg.jpg...
  8. jwkolker

    dBASE tagged for Deletion write log file?

    Hello: In dBASE 5 I am wanting to write a logfileddmmyyy.dbf for all records in a table that have been tagged for deletion during the business day before the night routine packs the table and actually removes the records. 1. Want to create a .prg that will recognize all records tagged for...
  9. jwkolker

    VBA FORM ACTIVE X - File Import dBASE III

    This code almost works only its pulling a type mismatch error - it is an activeX form that allows the user to browse to a file and then have the file name and path changed to a string and then used in transferdatabase routine - take a peek and recommend where I may have to tweeeek something...
  10. jwkolker

    Input mask for short date please

    Hi there - for some reason my install of 2000 doesnt have the full install and I am unable to use the inputmask wizard to set the input mask to short date - does anyone know the manaul settting? The examples in access are helpful but there is not one for short date - I need the WHOLE thing...
  11. jwkolker

    Copy files using VBA

    Hi: I often use the rename command in an msaccess module to move files but can't for the life of me remember how to copy files - I need to run a number of routines that depend on files being copied from various parts of the server to a local drive before the routines occur. What is the vba for...
  12. jwkolker

    Summarize Email Form Values before posting...

    Hi: How do I add an on submit summary page that will summarize the values entered on my html mail form and allow my user to go back to correct or submit to continue. I would prefer to not use cgi or perl - want a script that can be loaded from the page like java or a simple html option. Thank...
  13. jwkolker

    dBASE - replace PA with NJ in Text Field

    Hello: I am looking for a quick .prg that will change text within a field example: 1234 Your Street, YourTown, PA Want to change it to: 1234 Your Street, Yourtown, NJ... Want to step through all records in all fields and find a value and replace it. Please help me. Thanks. John Kolker...
  14. jwkolker

    Remove Carriage Returns from DBF

    We are trying to remove (replace) hard carriage returns from a field in a dbf. Does anyone have the code handy that will do that? JK John Kolker Programmer jwkolker@comcast.net
  15. jwkolker

    DSalvage Software - Anyother Programs Out There?

    Is anyone using any other tools to clean up dBASE corrupt tables? I am using DSalvage and it is very time-intensive. John Kolker John Kolker Programmer
  16. jwkolker

    Banner Rotator Script - Need Target=&quot;_blank&quot; inserted?

    Hello - this script works well but I can't for the life of me figure out where to insert target=&quot;_blank&quot; so that the url direct will pop a new window and the visitors won't leave my site after clicking on my advertisers banner... The link where this script works is...
  17. jwkolker

    Load different gif each time someone visits

    I am using dreamweaver - what I would like to do is load a different gif in the same place with each new visit. How do I do this? Any suggestions? Thanks. John Kolker John Kolker Programmer jwkolker@comcast.net
  18. jwkolker

    Hover Text Formating

    I want to change the look of hyperlink text so that the link is not underlined and when you hover over it i want it to be underlined and perhaps as different color. this is what I have now - how do i change text attributes? <STYLE TYPE=&quot;text/css&quot;> <!-- .fnh a:link { color...
  19. jwkolker

    TransferText Overwrite Existing Table Problem

    Hello: When I run this code - I am having to &quot;zap&quot; the contents of the table using a delete query - I want to set a parameter that will cause the transfertext command to simply overwrite the existing table simular to the way I would get prompted if I were to do it manually using the...
  20. jwkolker

    Scheduler Form / Module - any good ones out there?

    Does anyone know of a free demo of an access sceduler form / module that will allow me to set up processes each day at a certain time within my access .mdb? I already tried HAL and it has too many errors as well as being external. Please point me in the right direction. Thanks. JoKo John...

Part and Inventory Search

Back
Top