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

    Interactive Calendar Form wanted

    I have a database shell I've created with contacts, inventory, etc. information. I'd like to add an interactive calendar form if possible. I haven't found this information on the net to date, but have seen some access databases online with the capability. Does anyone have advice as to how to...
  2. SethP

    Need to find duplicates in Excel spreadsheet

    I have a spreadsheet that list several different pieces of data. The spreadsheet looks as follows: Cust Serial Date Amount Type 123 0656020652501 20060721 $115.82 P 123 0656020653011 20060724 ($40.12)X 123 0656020653011 20060721 $40.12 P 123 0656020658301 20060721 $10.18...
  3. SethP

    Importing large text file into Access table

    I am attempting to import a large text file, created using JCL, into Access for manipulation. When I open a new database, and attempt to import a new table I receive an error message stating, "The Microsoft Jet database engine could not find the object '(path.txt)'. Make sure the object exists...
  4. SethP

    Hot Keys in Oracle 11i

    Is anyone aware of how Hot Keys can be created in Oracle 11i. It sounds simple enough, but I can find the answer. Thanks!
  5. SethP

    Converting Julian Date

    I have several tables, that when imported from our AS400 system, convert the date as Julian values. I would like to add a formula to a query that converts the Julian format into a legible date format. Any suggestions? Here's an example - TM_DATE_EXPIRED_JULIAN_1 = 110365 The true date is 12/31/10
  6. SethP

    Query a number series ending in "010"

    I am trying to create a query that will find numbers starting with a certain location zone, and ending with a certain location zone. Data- 925-266-161 912-274-010 925-176-010 I need the query to gather data that starts 903-913 and ends in 010, like 903-xxx-010 to 913-xxx-010. Then the query...
  7. SethP

    Need a calculation to return a positive number

    I need to create a calculation that will return a positive number. I have a form that compares two fields: actual inventory counts and original inventory counts. I would like to take the difference of the two fields and divide that number by the actual inventory count to receieve a percentage of...
  8. SethP

    Restrince tab control from moving to a subform

    Hi all- I have a subform in my database that pulls information from an inventory system. This subform should not be changed by the user of the general form, but is viewed by them for reference. Is is possible, for data entry, to set up the tab order such that it does not tab into the subform, it...
  9. SethP

    Sum IF or Vlookup

    I wansn't sure what to name this thread as I am not sure how to solve the problem. Here is what my spreadsheet looks like: Column: C E 1-2-00 $16.50 2-4-01 $11.25 6-10-02 $10.00 etc. I have several rows of data and I need the formula add the dollar amount...

Part and Inventory Search

Back
Top