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...
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...
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.
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.
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...
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 :)
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.