Recent content by CRBMartin

ok I think its offical... I suck Been trying all day to get my db to display the laptop held be a specific user I just cant get my head around the problem I have to leave work now but will be back to the grind in the morning If anyone can shed some light on my issue before then I will be...

ok thanks... I will try this but all topics there seem to be new to me so it will be a bit of an adventure I will keep you posted on my progress

Table Laptop holder Serial Number : TEXT FK Current location: Text date Taken: Date/time Agreed return Date : date Time Open Return : yes/no Date Returned: date/time Further info: text Laptop control form complete: yes/no Name: text : combo box look up to internal user list Contact details...

laptop db has 63 entries under laptop details and there are 120 occurences of loans in the laptopholder table I have the following tables: Laptop details Laptop holder Maintenance A drives CD drives Printers Internal user list Software relationships in place: Laptop details to laptop...

relationships yes I have 1 laptopdetails to many laptopholders I can post a list of my other tables/feilds/queries/forms/relationships etc if that will help or did my mad ramblings on my last post make some sort of sense

Just enter a new field on your table and use OLE as data type then in use the user selects the field goes to insert and then inserts an object which can be a new file or an existing file

Display record on form by serching subform table I have a laptop database that tracks laptops and current laptopholders the database is written in access 97 I have organised this in to a number of tables primarily Laptop and laptopholder I have a form that is based on Laptop I have a sub form...