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 Mike Lewis 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: *

  1. FreshFish

    Legacy SyDOS Puma 105 - looking for drivers

    Not much luck with those. I did however find the original computer it was hooked up to in company storage! Now it a matter of finding something to read the PM5 (pagemaker 5) files I need in the absence of that program or its updates...
  2. FreshFish

    Legacy SyDOS Puma 105 - looking for drivers

    Hello, I have been tasked with retrieving some rather important files that were saved on an OLD SyDOS Puma 105. I'm going to try to make it run using a DOS emulator but the floppy that has the original drivers on it was lost. I tried looking online but the only place I found that even...
  3. FreshFish

    Union Query Blues

    Very useful. With the number of parts the DB will eventually have that will save alot of time. I had to get rid of the ' that was in the "*" wildcards as it wasn't returning anything with them in.
  4. FreshFish

    Union Query Blues

    I used... WHERE [Currency]="Dollars" AND [PartName] LIKE [Enter Part Name:] & "*" ...and it seems to work alright. There aren't many records in the DB yet though.
  5. FreshFish

    Union Query Blues

    Alright its working and I have used the same formula for Other queries. New question is how I would incorporate wildcards into the PARAMETER. So that if someone was searching for a "hydraulic drive" they would only need to input "hydr" and they would get the proper return...
  6. FreshFish

    Union Query Blues

    Ah! Thank you. This is starting to make sense now. I also had to modify my [Euros to Dollars] as it was passing through [Currency] ="Dollars" and giving me 2 results for those fields. Duh. Much Obliged :)
  7. FreshFish

    Union Query Blues

    I've muddled through trying to put together a query that takes info from a table and another query so that I can input a Part# and have in spit back all the vendors and prices in US Dollars. SELECT [PartName], [Part#], [Vendor], [In US Dollars] AS [Price/Unit] FROM [Euros to Dollars] UNION...
  8. FreshFish

    Multitable + Querie, Querie

    Halibut actually. That helped alot! Thanks!
  9. FreshFish

    Multitable + Querie, Querie

    Hello, New to working with access but was charged with creating a database and tools to research part prices for manufacturing. I have made 2 tables which contain our parts with names and part numbers (key field) and the price we get the parts for from Europe (in Euros). The other table has...

Part and Inventory Search

Back
Top