Posted on 2003-03-25
I hope someone can help me with my problem. Below is a Table from a DB I am trying to access.
On my form I have an input box and a search button. I also have 6 boxes to show the results.
DB Name = shares.mdb
DB Table = Portfolio
ShareID ShareCode SharePrice EPS DPS EPSGrowth PERatio SHF
1 SKC 866 50 44 17 16 113
2 WHS 540 31 15 16 17 61
What I want to be able to do is:
Perform an SQL quary when the search button is clicked taking the ShareCode from the user and putting it into the statement: SELECT * FROM Portfolio WHERE ShareCode = [Enter Share Code];
Write each result to a sepearte edit field e.g. EPS value in edit2 box and DPS value in edit2 box.
Update a field if the user changes a value e.g. EPS value change on form, update DB EPS field.
Where are results from quaries stored? How do you access fields in the search result? Question one will probably answer this one.
I am easy as to what components to use, never done this before so any suggestions would be great.