Search results

  1. A

    Filter name in report

    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...
  2. A

    Subform record order?

    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...
  3. A

    Solved Report filtering

    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...
  4. A

    Solved Filter on emulated subform

    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 =...
  5. A

    Solved Subform unwanted behaviour

    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...
  6. A

    Solved Combobox with multicolumn

    Hi All I have a combobox with 3 columns (Bound Column 1) from tblAssemblies, the issue I am facing is in tblAssemblies the first two fields are allowed to contain the same data but are differentiated by field 3. The user selects an entry from the drop down, but if they select an entry of which...
  7. A

    Check if multiple text boxes are empty

    Good morning, I am trying to create a code that checks on click if a textbox is empty and if it is it assigns a back colour and makes a textbox(* symbol) visible and then checks if the next textbox and performs the same routine until all have been checked. the end goal being if any are empty...
  8. A

    Check bound textbox for duplicates

    Hi All I have a bound text box (Assembly_NumberSpec) and field (AssemblyNumberSpec) in tblAssemblies. What I need to happen is after the user has enter data into (Assembly_NumberSpec) to check for any duplicates and in (AssemblyNumberSpec) in tblAssemblies If duplicates are found I need to...
  9. A

    Ignore certain words in textbox

    Hi All, I have a search text box in my forms and frequently have end users enter irrelevant information into the text whilst trying to search which results in no matches found. Can someone help with some code to remove certain words(That I can specify from within the code) from the text box...
  10. A

    Search in continuous form problem

    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 This works fine however when I am trying to implement a search function with the following code I...
  11. A

    Solved Records go to new isn't available

    Evening All, I have an issue when I run some VBA code that only happens in a certain order. When i run Application.RunCommand acCmdDeleteRecord this deletes the record as expected however the problem I have is after this if I try and run Me.ID.Enabled = True Me.Location.Enabled = True...
  12. A

    Table updates

    Hi All, I have a tblTools with over 2000 records and 10 fields, 2 of these fields are Machine and Tool Type. Can some explain the bestway to handle changes to the two fields so that it It will update all the records automatically? I.e Of the 2000 records around 800 of the Machine field is 20...
  13. A

    Custom sort order management

    Hi All, I have a tbltools that has 12 fields in total of which 2 fields (Machine & Tool Type) that I need to apply a custom sort order to in the user report, so I have have added two sort fields to the table (Sort Order Machine & Sort Order Tool Type) this approach works fine but I need to...
  14. A

    Conditional Formatting based on another table

    Hi All, I have a text box within a report that I would like to apply a bold formatting if it matches a record within another table (tblConditionalFormattingBold), Can anyone advise if this is possible? Thanks
  15. A

    Creating multiple records from one form

    Hi All, I have two tables in my database [tbltools] which has 10 fields (tools1 to tools10) and [tbltoolgroups] which has 7 fields (toolgroups1 to toolgroups7) I am in the process of creating a form that the end user can use to define a tool group (will be stored in [tbltoolgroups]) The basic...
  16. A

    Hi!

    Hi All, Just getting started with Access, I’ve certainly encountered some difficulties but can also see that Access is a lot better suited to deal with my work requirements than excel. I look forward to learning to improving my general understanding and troubleshooting with your help Thanks Ash
Top Bottom