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

    Display SQL statement into a text field on a report

    I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...
  2. vanuta

    Display SQL statement into a text field on a report

    I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...
  3. vanuta

    Display SQL statement into a text field on a report

    I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...
  4. vanuta

    Comparing to character fields

    I have two tables I'm working with: Table 1 looks like this: Vendor_Name InvNumber Store Number Inv_Amt Whirlpool Corp. 5001 450 2500.00 Cooper Tools 5002 609 3800.00 Cooper Tire 4500 501 8000.00 Amana 8011...
  5. vanuta

    Comparing two fields with different datatypes

    I have a table that looks like this: record vnd_nbr vnd_name srtinvnbr inv_dte srtinvamt 1 101535821 TRAVELITE 82498 11/31/1999 824.98 2 101535821 TRAVELITE 85666 12/1/1998 500.01 3 101535821 TRAVELITE 65577 5/8/2001 5820.01 4 101535821...
  6. vanuta

    Query out Monthly Payments

    I was wondering if their was a way to query out monthly payments from a table. The table would look like this: Vendor_Num Vendor_Name Invoice_Num Inv_Dte Inv_Amt 1 Tyco 10001 10/11/01 5000.00 1 Tyco 10010 11/11/01 6000.00 1 Tyco...
  7. vanuta

    Remove unlock workstation

    When a user leaves his NT Workstation idle for a certain amount of time a message appears telling the user to unlock his workstation. How can I stop this message from popping up?
  8. vanuta

    .UNL FILE EXTENSION

    I have a cd with files with a .unl file extension. I have to transfer these files into Microsoft Access or MS SQL Server, but I don't know how to go about doing it. Any suggestions would be welcome.
  9. vanuta

    Searching ListBox

    I have a listbox with 2 columns. One column contains numeric data and the other contains text. I have over 100 records in the listbox. Searching through the listbox can be a pain. I want them to be able to type in a textbox the value their looking for and have it automatically selected in...

Part and Inventory Search

Back
Top