Search results

Bob Thanks That did the trick. I will play with this since I also need to have different qualification scores related to different types of qualifications (in a separate table). If I can't figure it out myself, I will ask for more help.

My database tracks individuals qualifications. These qualifying scores relate to Unqualified, Expert, Advanced etc. What I want to do is add a entry into my roster table which will have the qualification score. I then want to have the score and actual qualification (Advanced, Expert, etc) in a...

Doc Thanks for clearing that up. I will play with the info you gave me and see what I can come up with

Doc I think I understand where you went with your tables. I don't quite know (or see perhaps is better) where you put the song titles (is it in tblCD or tbl Attribute??). I like the idea of the attributes, If I understand it correctly, I could use it to state the type of media (LP, CD, Cass...

All I am in the process of creating a database for my music collection. This will consist of both officially released music (LPs or CDs) as well as "unofficially" released live concerts (taper friendly bands like the Grateful Dead) from groups that allow you to record and trade their concerts...

Stef This works for the user. Thanks for the assistance The brewmeister

Stef No thats not quite it I have posted my database. Open up the testform form, enter 0591129231 as the serial number. You can see that there is a status box. After viewing/editing I want to be able to enter another serial number (from hard copy records) to view edit another piece of...

All I have an inventory form. What I have created is a select query to open a form after asking for the serial number. This works easily, what I am confused about is after viewing or editing information based on 1 item, how can I open the enter serial number message box again without closing...

daveUK Thanks for the help the Brewmeister

I have become frustrated. attached is my database. It is an inventory The frmNewEquipment should be used to add new records to the inventory. I have it set up from a query, with the combo boxes set to populate text boxes (such as point of contact info from the location of the equipment). I also...

Thanks Max I didn't see that part when I first got here. I think it will have what I am looking for The brewmeister

Hey all I have a inventory form, with POC's (the stuff is located all over the place) What I am trying to is create a combo box with the last names of the POCs and the remaining info automatically fill in the text boxes. I have tried the DLookup and it hasn't worked. The POCs are in a...