Search results

Hmm, this works but I have a continuous subform so everytime I jump to the next record I need to unlock it first. Have tried to run the code on some other events but it resorts to the original problem.

Have an EDIT and LOCK button which allow editing of records and lock editing of records in a form. Editing is also locked when navigating to another record. Is there any way of adding a timer to the locking of edits? Ideally, if the EDIT button is clicked to allow editing is it possible to...

Parent form, have added it to the On Current event in the subform and it appears to be working now. Thanks for the pointer, I'd still have thought though that having it run in the parent form would have been enough. Anyhow......thanks for the reply.

Have an unbound combo box which by default is not visible. When the user clicks on an "EDIT" button the combo box becomes visible using the following bit fo code: Forms![Frm_Main]![Subform_Capacity].Form![Cmb_RangeSelector].Visible = TrueThe opposite happens if the record is changed (On...

Thanks Dave, Can you comment on my table layout and that I should not be running multiple subforms off the same "recordset" or "record source". My subforms appear to be running fine except for the non-updating issue but if I shouldn't be running them off the same record source then I need to...

Thanks Rabbie, besides the link to the above post in the Form forum how much more info would you like? Am happy to supply what I can. In terms of normalisation I believe I've done a fairly good job in cleaning the original flat table up into individual tables and creating relationships (3NF)...

Have posted a similar question over in the Forms forum but this may be more relevant to Tables: http://www.access-programmers.co.uk/forums/showpost.php?p=1018824&postcount=16 It would seem I should not be running multiple subforms over multiple tabs from the same record source. Does anyone...

I'm going to try and explain things a little clearer as populating the current DB with bogus data will take some time. I have two main tables which have a many-to-many relationship and are linked by a junction table (field names simplified): Tbl_Indoor IndoorModelNumber(PK) Tab1_Field2...

I could always keep my form layout more or less as is and split the "Album" table dependant on the tab information required. That way my subforms would all be running off different tables. Would I need accompanying seperate linking tables our could I use one main linking table, I'm guessing...

Yip! But then add tabs to the main form to group seperate items of the Artist and seperate subforms under those tabs to group Album items which may relate to the grouping tabs for the Artist. The Album subforms show different data but run off the same table/s. If I shouldn't be doing things...

Thanks Bob, I may have to send through a bogus dataset with the current table layout. For now though the following link provides an idea of my table relationship layout: http://www.databasedev.co.uk/many_to_many_example.html

Bob, There are 3 "main" tables, 1 primary, one secondary and they're linked via an ID link table. I have another 3 tables linked to the primary and secondary tables. Are you suggesting I run the main form off one query which includes all records? Ideally I'd like to have the main form show...

Bob, The main form has several tabs based on certain aspects of the record. As the main form is split into tabs we have related aspects within the subforms which are placed on their relevant tabs under different subforms. However they're all sourced from the same table but just split/grouped...

Thanks guys. RG, I'll try calling a requery Public Procedure and see how that works. Bob, I'm not including the main form table in any of my subform record sources. The subforms however are sharing record sources, or do you class two seperate queries based on the same table seperate? Thanks...

Realise this has been asked before but I'm struggling to get a subform to update it's recordset when a new record is added. Have one main form with sevral tabs and some of these tabs I've placed subforms. The three recordsets are linked by a one-many ID table from each of the two other tables...

Piia, Okay, just a suggestion based on how I'd probably go about this. Each publication and box has an ID or unique internal code. The publications table would contain all the ID's and any other relevant data for each and every publication. The box table would be similar and linked to the...

I cannot see how you register that a box or catalogue are booked out. I'd have thought you'd have a tickbox or yes/no field to tell the user if a publication is out. One other thing, you might want to run a compact and repair on your database, it'll shrink the size right down. You can find this...

The Combo Box Wizard allows the user to select "Find a record on my form based on the value I selected in my combo box".

Not sure of your table setup but if for example you had a tick box attached to each item and the item is ticked when it is checked out then you could run a SetValue action in a macro when if the box is checked out all the items within the box getting checked out, i.e. the tick box value's get...

Thanks RG and Dave, RG, your idea is what I had in mind initially. I'll give both a try and see which works best. Thanks again, Gareth