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 SkipVought 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
- Order by date
-
File Copy - File names from Table
ok - I am going to use your form method - do I point the path filename and destination to the table as the datasource? JK John Kolker Programmer- jwkolker
- Post #5
- Forum: Microsoft: Access Other topics
-
File Copy - File names from Table
wow - that is great. Thanks very much. John Kolker Programmer jwkolker@comcast.net- jwkolker
- Post #3
- Forum: Microsoft: Access Other topics
-
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...- jwkolker
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
Size windows?
ok - i figured it out - this script works just fine without having to write anything in the <HEAD> portion of my html page: <script language="javascript"> var newwindow; function poptastic(url) { newwindow=window.open(url,'name','height=350,width=550'); if (window.focus) {newwindow.focus()} }...- jwkolker
- Post #22
- Forum: HTML, XHTML & CSS
-
Size windows?
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...- jwkolker
- Post #19
- Forum: HTML, XHTML & CSS
-
Java Popup without <Head> tag reference
I want to pop a new window. JK John Kolker Programmer jwkolker@comcast.net- jwkolker
- Post #3
- Forum: Javascript
-
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...- jwkolker
- Thread
- Replies: 3
- Forum: Javascript
-
Crystal 8.5 to 7 - Select Criteria Conversion Problem
Version 7 is still struggling with the new version of code above - it thinks that criteria is missing. Please look at it for any obvious causes - thanks for the sample. John John Kolker Programmer jwkolker@comcast.net- jwkolker
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal 8.5 to 7 - Select Criteria Conversion Problem
Hello - guys - could you make the tweek to the code so that I can "see" it - I really don't know what to do with the and if statement. John Kolker John Kolker Programmer jwkolker@comcast.net- jwkolker
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- jwkolker
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Remove periods and commas from Last Name Field
Hey Duane - thank you very much - this is what I ended up using and it worked like a charm - take a look - Function GarbageInExtra(pvarText As Variant) As Variant 'gets rid of everything except numerals Dim intChars As Integer Dim varGarbageOut As Variant Dim strJunkChars As...- jwkolker
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
HTML Mail - what's the trick?
Do you know a good source to learn more about using MIME::Lite and Net::SMTP to do all sorts of great HTML Mail manipulations, including alternative types for those who can not read html mail? I have not idea how to do html mail - can't I just configure the script in mail.pl to be html? JK... -
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 "Click Here" to pick up your message instead of the dreadfully long URL string -... -
Remove periods and commas from Last Name Field
Hi all - this is really beating me up - I have many tables have values within fields that have dashes or commas or periods that do not belong - let's use an example - In the table Candidates I have telephone numbers with xxx-xxx-xxxx in field Phone and I want to run a query or create a module to...- jwkolker
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Remove a character from a string
Hi all - this is really beating me up - I have many tables have values within fields that have dashes or commas or periods that do not belong - let's use an example - In the table Candidates I have telephone numbers with xxx-xxx-xxxx in field Phone and I want to run a query or create a module to...- jwkolker
- Post #5
- Forum: Microsoft: Access Other topics
-
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...- jwkolker
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
Create Table of List of All Attached Tables, Fields, datatypes & size
Ok it is checkmarked (was checkmarked) Microsoft DAO 3.6 What do I put in the declarations and what do I put in the sub to acheive what I referenced in my last message? John Kolker Programmer jwkolker@comcast.net- jwkolker
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Create Table of List of All Attached Tables, Fields, datatypes & size
hi Rdodge - the DAO code is a no go for me - the other issue is the Dim tbl as Table, fld as Field Access does not like them as object types Perhaps you could toss together a soup to nuts sub for me that I could load as a module in access where we use the table name "JohnsTable"...- jwkolker
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Create Table of List of All Attached Tables, Fields, datatypes & size
That's a great tool - thank you - but unfortunately I wanted to write the values to a table TableName FieldName Datatype Size How do I tweek this code to do that? Dim tbl as Table, fld as Field Dim tName as String, fName as String, fType as String, fSize as String For each tbl in...- jwkolker
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Create Table of List of All Attached Tables, Fields, datatypes & 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...- jwkolker
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
