Search results

Hi, My main form has ContactID as PK. I have a TabCtl 'TabCtlPrimary' on the main form: i) Page 0 "pgOfficeLocations" has a sub form container "sfrmLocations" The sub form within it is a continuous form "sfrmLocations" It's PK is "LocationID" . The child/parent relationship with the...

@ Static. First signs are very promising - thank you so much, you have made my day!

Hi again, I'm probably being dense here but as the control source of the existing unbound text box is the function itself how would I create a control and have it bound to a table and also pass the arguments to the function? I thought the way to do that would be to insert the function result...

Please excuse the absence of reply, I managed to break a toe last week which had put me in a decidedly poor mood. I concede I don't fully understand the example you kindly provided which is a problem of itself if I need to try to work out how to develop the idea and incorporate it myself into...

As suggested I've uploaded a pared down version with just the forms and tables relevant to the original question. In the right portion of the form that launches there are tow command buttons Basic search and Global Currently they both launch the same search form (the global search is the one...

Hi and thanks for the responses The tags are as you say stored in a table along with the tag PK and the FK for the subform2 record in view. I'm using a qry including the tag table and the parent table (and the two tables in between) to uncover the parent PK 'ContactID' ,using the qry also...

Hi Cronk Yes I do appreciate that this method is against best practice both in terms of normaiisation and in effect storing a calculated value. The issue is my coding skills just aren't up to writing routines that will allow me to create a multi criteria search against to concatenate output...

I have a function of Allen Brownes http://allenbrowne.com/func-concat.html that creates a concatenated string from user entry in a sub sub form, that string describes (by means of the various tags) the key content of the main record and its sub forms. The concatenated string needs to be saved...

Thanks for the links. I'm afraid the code examples are far more advanced than my current level of understanding and whilst I don't doubt it would, if I could implement it, be a much more elegant solution than I could come up with I think I would be better sticking to a solution I can maintain...

Hi all, I have no idea if this is possible or how complex it may become if it is possible. The idea is to build a tag cloud from from a number of different records which would then appear in a single memo field on a parent form. the Sub1 form has a control Tagtxt which a user populates...

After some more experimenting and using the Expression builder just to get the syntax I seem to have got it sorted If Nz(Forms![AddressEdit]![sfrmIssueAddressHeader].Form![IssueSummary], "") = "" Then Forms![AddressEdit]![sfrmIssueAddressDetails].Visible = False Else...

[SOLVED]:referencing subform Control from within a second synchronised subfrom I have a main form frmAddressEdit and two linked subforms (listed below) on that main form. The two subforms are synchronized by an unbound text box on the main form. sfrmIssueHeader is a continuous form and...

Sorry plog I hadn't seen your post, I didn't refresh page. reading now...

Hi, I should have phrased the question differently on reflection. I am happy with how to normalize the tables so the issue really isn't about the final structure. What I am struggling with is how to make the initial table relationship, i.e provide the newly created table with the relevant...

I am working from an existing database which is just two table. The main table has a massive amount of redundancy and duplication and needs splitting into, at first glance, 5 tables. After I have run my various make table queries and added a Primary Key and FK field to the new tables how do I...

All I am doing is changing view from AcForm to AcDatasheet from a subform. I can't replicate it when I build a simple Form/Subform (on a navigation form) so have had to strip out all but the form causing the issue in the database I'm actually building in the hope someone can see the issue...

Thank you both. This will be a good entry for me into DAO I think and I have now got the code working with your suggestion Pat. I had also completely overlooked the DCount function, I'm completely sold on the simplicity of it.

I have a form which filters records by a number of different query. The query is selected from a combo box on the main form and this works fine. What I would like to do is prevent the recordsource from being changed to a query where there are no matched records. I've being playing with some...

Resurrecting this older thread as maybe of use to others who like myself are just starting out with VBA. I have been using Bob's excellent FE-Updater across the network and it works brilliantly so first of all my thanks to him to making this available. My tip (and I appreciate this is...

Just in case anyone was looking. I now realise I can't use a calculated filed as part of the where clause. I will be creating a second query based on the first, as I write I am wondering if the recordset will still be updateable as this now 2nd query will be the record source of a form? Will...