Recent content by Emma

I have a form that is used as a holding table for records which, once checked, are appended to a final table and then deleted from the holding table. This is done using the following code on a button, which simply runs the append and delete queries. (the queries run on a filter which sorts out...

Hi I have a main form "Tender" linked to a subform "Project" - which shows single records at a time. The user has navigation keys to move through all Projects related to a single Tender in the main form. The parent-child relationship is between a field "Tender" - However I also have a second...

Thankyou Pat! That is really so simple and yet has solved a really annoying problem! Many thanks! Emma

Many thanks, I shall take a look! Emma

Hi again! I am trying to create a report that runs from a crosstab query, though it has just occurred to me that at the moment, there are less columns in my report than there potentially could be. The crosstab query the table is based on uses a lookup field to create the columns and at the...

Does anybody know how you can change the colour of a tabbed form,so that the background of the tabs changes? Many thanks Emma

Just incase anyone out there reads this thread, the problem has now been solved, with thanks to RPBertS's help! Rather than putting this code on the form_close event, I put it on the Object forms AfterUpdate event. When I closed this form (which was a dialog ontop of my Jobs form), the value of...

I tried the code but nothing happened! I entered it as: forms!frm_job!sfm_ojbectno!object_no = object_no.value on the OnClose event of the object for, so that the once the object form closes, the object_no field in the subform on the Job form would be updated. However, it has since occured to...

Hi! I have a main form (job)with a subform (object-job)for objects related to jobs - objects are selected from a combo which looks to the main object table. On the subform, I have a button which opens the objects form which opens as a dialog box keeping the focus until it is closed, so that any...

Cheers Talismanic! With a bit of amending, I got the code working and now have a nice number system! Can I also ask a further question relating to the problem of using a year and autonumbered field to generate a unique identifier? Is there any way that on each new year the autonumbering...

I have a database with three fields: year, autonumber field and object type. My client wants me to create a unique record number to be used as the primary key using the year field and the autonumber field, so for example: year autonumber object primarykey 2001 1 pot...

I have a database with three fields: year, autonumber field and object type. My client wants me to create a unique record number to be used as the primary key using the year field and the autonumber field, so for example: year autonumber object primarykey 2001 1 pot...

Thanks for your reply! I think what I was wondering whether I could set this property (forecolor) for the whole record, rather than just one field? So not only would the Object_no field be set to a particular colour, but also all the fields in that record? Is there some sort of global command...

If I use a combo box to go to a particular reocord in on a list of records, how do I change the colour of that records text so that it stands out from the rest of the records? My code for the combo is: Sub Combo44_AfterUpdate() Detail.Visible = True ' Find the record that matches the...

Many thanks to you both, my problem is now sorted! Regards, Emma