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

    Search for existance of certain files in tree of subdirectories

    Hi, i need to perform the following task. I have a tree of directories that contain files. I need to check that each subdirectory contains a complete set of files. If something is missing i need to report that directory. ----AAA 1234.txt 1234.dat 1245.exe 1234.sig ----BBB...
  2. njitter

    Only report last record of two linked tables

    I have the following linked tables: I would like to display only the latest record in the Detailed Info table together with the Guidelines information (record with the newest Entry Date) How to get this record? --- Happy Happy Joy Joy
  3. njitter

    Selecting latest date from joined table

    Hi, i have the following tables: tblStandard_Information and tblReview_Information. These have been joined with a key. I have created a query to display some fields - view this image: http://img137.imageshack.us/img137/8995/tablenc9.png. SQL view: SELECT tblStandard_Information.Product_Name...
  4. njitter

    [php] Forcing page in iframe

    Hi, i wonder if the following code can be converted to PHP. I have the following html/javascript code: ::index.htm:: <html> <head> <title>Index</title> </head> <body> <script language="javascript"> // writes in the iframe contPage = (location.search.substring(1))? location.search.substring(1)...
    • njitter
    • Thread
    • Replies: 0
    • Forum: PHP
  5. njitter

    Excel VBA - Sending Outlook mail with Notify

    Hello, i'm sending an email from outlook with the following code: Sub MailTempWorkbook() Dim WB1 As Workbook Dim WB2 As Workbook Dim WBname As String Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp =...
  6. njitter

    Late binding of MSWORD object in VB6

    Hello, i'm using a VB6 program developed by an external company. It works fine in our company. We are using MS Word 2002. We want to deploy this software at another site. Unfortunately they are using MS Word 2003. The compiled program is not working because the reference to MSWORD 10 library...
  7. njitter

    Generating Unique ID in form of AB-YY-xxxx

    Hello, i would like to generate an unique ID in the form of CS-06-0001 (where CS is a prefix, 06 is the current year and 0001 is a counter). I had this working in a 97 database but for some reason that code doesn't work anymore in Access 2002 (not my own code). It uses a table with two...
  8. njitter

    [Word VBA] Adding Footer with Pagenumber / Printdate to Document

    Hello, i'm trying to add a Footer containg Pagenumber/Total pages and Printdate to a document when it is created. I want the Printdate to be left-aligned and the Pagenumber/Totalpages to be right-aligned. Excel has .Leftfooter and .Rightfooter but these don't work in Word :( Could someone...
  9. njitter

    Report with several counts

    Hello, i need to create a summary report for the following database: The report needs to look like this: I have never done such a report before. Can someone explain to me how to setup such a report? --- It's never too late to do the Right thing
  10. njitter

    Creating a Complex filter

    Hello, i'm creating a front-end for a report. This involves a complex filter. The user wants to be able to select one or many from the departments, along with some date and type filters. The filter is built with a simple function: Function addcriteria(ByVal strExistingCriteria As String...
  11. njitter

    How to display modification date of XLS file on server

    Hi, i would like to create a page that links to a XLS file on the webserver. I would like to show the modification date of the XLS file on this page. Something like this: file.xls (last modified at 1 januari 2005). I think i will have to use PHP to get this modification date. Could someone...
    • njitter
    • Thread
    • Replies: 1
    • Forum: PHP
  12. njitter

    Report with Filter Form -&gt; Filter with LIKE statement

    Hi, i have got a report that has a Form before it to set a filter. In this report is the following code: Status_Info_3 = "" Chapter_Filter = "" If (Forms!ReportSelector.ChapterSelect1.Column(1) <> Empty) Then Chapter_Filter = "[Q7A_Chapter] Like '" &...
  13. njitter

    Retrieve Database filename

    Hello, this is probably something easy but i could not find it in the forum. I want to create a simple MDB file that shows the filename of this MDB file on a form. So, if the file is called dummy.mdb it should show on the form: Filename: DUMMY.MDB It would also be nice if it could show the...
  14. njitter

    Filtering a record lookup combobox

    Hello, i've created a Record Lookup combobox by using the Wizard. This has the following event code: Sub Combo512_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Job] = '" & Me![Combo512] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark End...
  15. njitter

    Setting focus to Main form when inserting new record

    Hello, Main form : Form_Guidelines_Main Linked Sub form : Form_Guidelines_Sub I would like to move the cursor (setfocus) to the control called Guidance on the Main form when i insert a new record. Any hints?? Njit --- It's never too late to do the Right thing
  16. njitter

    Setting record sort order in subform

    Hello, i have got a form with a linked subform. I would like to have the subform display it's records in reverse order (by ID). I have been unable to set the sort on this subform :( Search did not come up with a solution.. --- It's never too late to do the Right thing
  17. njitter

    Suggestions needed: modifying order of lines in dataset

    Hello, i would like to have some suggestions on how to do this interface-wise. I have a dataset in a text-file. It contains definitions for function keys. I'll try to make clear what we want to do. Old order New order --------- --------- 1...
  18. njitter

    Passing a parameter to a ASP to create another URL

    Hello, i'm using an application to pass a parameter to a Crystal Reports file The problem is that the application that creates this string has a limit on the length of the string. I would like to create a ASP file (show.asp) that will take the ID (BAG0001) as a parameter and refresh the page...
  19. njitter

    Confirm before Update

    Hello, i have a form with a Boolean Box on it. I want the user to confirm the change of the value before updating the database. I have this now: Private Sub History_BeforeUpdate(Cancel As Integer) If MsgBox(&quot;Change History status?&quot;, vbOKCancel, &quot;History&quot;)= vbCancel Then...
  20. njitter

    Crystal Reports 8.5: Displaying ORACLE Long Field

    Hello, i'm using Crystal Reports 8.5 SP1 to connect to a Oracle 8i database with ODBC. I want to show a Long Field on a report. Crystal Reports assigns a field type of Memo to the field. When i preview the report it does not show any data. I can look at the field in Oracle (with Quest...

Part and Inventory Search

Back
Top