Recent content by MattCollins

Ok due to user error (and my own fault for not archiving an old database) we now have two databases which have had data entered into with the same table structure. The table structure we have at the moment is with the related field in []: Propertytbl[Propertycode] is related to...

Sorry, but how would i go about doing this?

Thank you very much Len...much appreciated!

Hi, i have a table that has contact information in. It has contact name, number etc and company. Quite alot have the same company. I was hoping to split the table into two, a company and contact table which are linked. I've been thinking about this and not too sure how to go about it. Anyone...

I have two tables, a Property table and a System table. They are linked so that there are many Systems linked to one Property. Each System has a risk score and these vary within each property. My Property table has a Property risk score field and in here i would like the maximum System risk...

Ok this is hard to explain but i have 2 tiers of information in my report. Property and then Systems related to those properties. Ok so far so good. Each property has a score. I have sorted and grouped on this first. Each property also has a system which also has a score. At the moment all my...

Hi, i have had this problem as well. The way i have sorted this in the past (and this may be the wrong way) is to compact and repair the database, then go to the table with the affected field. This should now have a row of ###### in it instead of #deleted. You can now delete that record and...

Been a while now but still getting this everynow and then. The only way to get rid of the #deleted is to compact and repair and then go into the tables to delete the record. Anyone else experienced this, have any ideas?

Its ok, i've managed to do it by creating a recordset and moving through it adding the name field to the text boxes as i went.

I don't think the wizard would help, what i mean is that i have 10 records in the table and i would like my 10 text boxes to display the 10 name fields.

There are other controls on the form unfortunately.

Is there anyway to name text boxes in an array format? i.e. Text(1,23) Or if not is there anyway to use VB to cycle through the text boxes i.e i = 1 Loop until i = 25 Text(i) = codehere i = i + 1 Exit Loop Matt

What i'm trying to do is fill several unbound text boxes on a form. I have an "Employeetbl" with "Employeename" and a "Projecttbl" with "Projectname". what i want to do is have about 10 text boxes from left to right on my form. Then fill these with all the employee names from my "Employeetbl"...

Hi all, I'm just starting on a new project to create a scheduling database for a small company (about 20 people). What i aim to do is to edit calander entries (Month view) and view calander entries hopefully using a control that looks as much like Outlook as possible again this would hopefully...

Sorted Ok figured out the problem, the standard code that Access puts in for buttons seems to have changed in 2003 from 2000 lol