Recent content by Wolfgang

Hi, I was wondering if anyone could give me a pointer or two on how to design a Training DB. I have done the following: Created table with list of venues, captured trainers where they live (or train) etc, what I am stuck with now is how to create a new table that links the venue to the...

Dear Jon, Cool, thanks for the speady reply! It worked like a dream:)

Hi, My query is as follows; Dim dbs As Database, rst As Recordset, rst1 As Recordset, iCount As Integer, iCount1 As Integer ' Return reference to current database. Set dbs = CurrentDb ' Open table-type Recordset object. Set rst = dbs.OpenRecordset("Bug") Set rst1 =...

Thanks for the help!

Hi, I have a number of combo boxes (Linked to tables) I would like an unbound text box to display the summary of the selections in the various combo boxes. EG: Category: Hardware Sub Category: AGP Video Adaptor The values displayed in the text box are : 1 2 , where 1 is the category_ID for...

Hi, I have a number of combo boxes (Linked to tables) with categories and sub categories in them; I would like an unbound text box to display the summary of the selections in the various combo boxes. EG: Category: Hardware Sub Category: AGP Video Adaptor The values displayed in the text box...

I am writing an access program. The program is designed to capture all the events (Telephone, contact or work done) by a company or individual to a database. This database will then be able to “track” the contact with that event. I have created 2 tables, one called matters (this table contains...

Hi, I am writing an access program. The program is designed to capture all the events (Telephone, contact or work done) by a company or individual to a database. This database will then be able to “track” the event. I have created 2 tables one called matters (this table contains all the...