Search results

Hi Arnel, I have implemented your sample into my database and this works great on single monitors however I am experiencing difficulties with users who have dual monitor setups ( Laptop and separate display) Some of the forms overhang onto the other display etc, Have you any ideas or is this...

Here we go Thanks

Good Morning All, I have some filters in a form that are chosen before the report in created with a button, For clarification to the end users means the filtered field does not directly appear in the 'Detail' section of the report I created a text box with the control source set as the filtered...

I can't see anything amiss

Yes I agree just wish I could work out what I have done

the primary key, the field name is ID Number

Hi All, My database seems to have developed an issue. When I am adding new records using an emulated spiltform the record goes into the split form at the bottom (expected behaviour) but when I requery/or close re open the form all the records I have entered today appear first despite the PK...

Thankyou !

Hi All, I have a form which generates a report based on combobox selection, I need to be able to filter based on the entry in 1 field which is to be selected with a option control. I have set this up with queries but not sure how to best handle the multiple options? At the minute for the...

Thankyou! As suggested this worked for me Me.Filter = "SubjectID = '" & Me.Subject & "'" Me.FilterOn = True Set Me.fsubArchivedClasses.Form.Recordset = Me.Recordset

Thanks I hadn't added a clear button to the sample database. I am trying trying to achieve is a filter that will ONLY allow the user to edit via the main form textboxes not the subform (This works in the sample databbase until the filter is applied, once the subform has been filtered when you...

Please see attached sampleDB, notice that when a filter is selected on subjectID you can edit in the subform and also that the selected record fields do not get returned to their corresponding textboxes? Any ideas Cheers

Hi, I have created a form which emulates a split form following the example database found here https://www.access-programmers.co.uk/forums/threads/how-to-emulate-split-form.293854/post-1536716 Is there a way to implement filters? I have tried [Forms]![Form]![SubForm].Form.filter =...

Solved - my query that runs the report did not have the correct relationship between the two tables Cheers

Good Morning, Although this worked fine on my test database I have now tried to implement it into my live database and I am facing the following problem: I think the relationship between the two tables is causing an issue as in tblToolsForAssemblies and tblAssemblies as the data in Assembly...

Thanks for the detailed explanation all working great! Cheers

Edit - That was my fault I had one of my fields set as short text! Yes I have just had a look all works as I need, but when I try to make the changes in my database I get 'Relationship must be on the same number of fields with the same types of data' error. Also I see you added a query, Can...

Thanks for the reply Sorry could you possibly elaborate? Do you mean with an additional table? Please see attached screen grab Cheers

Hi All, I have used this attached example that was created by MajP. The issue I have is that I need to be able to create a new record in the form with the same Assembly NumberSpec and AssemblySAPNumber. Currently when I create a new record and type in the same Assembly NumberSpec (For example...

Yes thanks a lot for your time all solved now