Search results

  1. H

    Combining multiple sub-records against each row in a report

    OK I've come up with a solution. Might not be the most elegant but will help me get this job. I've added 5 new fields to the products table - fault1_combined, fault2_combined etc. Then I've run separate queries against each record in the pieces table, concatenated the values and then inserted...
  2. H

    Combining multiple sub-records against each row in a report

    As the three fault1 types are individual records in the fault1 table, the difficulty comes in combining all of these into a single string to display against each piece. In PHP/MYSQL I just run an separate query in each 'cell', but I don't know how I'm able to do this in an Access report short...
  3. H

    Combining multiple sub-records against each row in a report

    It's too late to change the structure of the tables. Faults continue to be logged and I have a whole separate PHP/MYSQL/HTML data input system setup for use on our tablets. Fault1 means a fault within category type 1. A Category type 1 fault can be a knot, a slub, a spot or a stain. Category...
  4. H

    Combining multiple sub-records against each row in a report

    Fault3 doesn't need a type. That's not a mistake.
  5. H

    Combining multiple sub-records against each row in a report

    I've built a system to log faults against products. Each product can have 5 types of fault. Fault1, Fault2, Fault3, Fault4, Fault5. Each product can have multiple instances of each fault type and for each fault logged, the metrage is also logged. For instance: Product 1 can have a Fault1 at...
  6. H

    Using SelStart with a ComboBox

    Actually, removing the input mask doesn't technically sort it. It's just that without the input mask it's impossible for the cursor to be anywhere other than at the start.
  7. H

    Using SelStart with a ComboBox

    You're right. Removing the input mask sorts it. The input mask is just to stop my users having to type hyphens but I think it's a small price to pay to have the cursor in the correct place. Thanks guys. :)
  8. H

    Using SelStart with a ComboBox

    I've also tried your code and it makes no difference.
  9. H

    Using SelStart with a ComboBox

    I've tried the following in the On Enter event and it doesn't work for me. Access 2013. 'Move the cursor to the start of the cbo if empty If IsNull(Me.cbo_nsn) Or (Me.cbo_nsn = "") Then Me.cbo_nsn.SelStart = 0 End If I've even tried adding .Column(1) as my cbo_nsn field has the id hidden...
  10. H

    Using SelStart with a ComboBox

    I have a combo box formatted with an input mask of: ####\-##\-###\-####;0; When the user clicks in the combo box, usually the cursor ends up in the middle of the string and they have to backspace or press the Home key to return to the start of the field. I know that for a text field you can...
  11. H

    Continuous Forms - Different Properties For Each Row

    Sorry I don't think I explained myself properly. I'm not talking about calculations I'm talking about how the fields are presented on the form and actually, also in reports. Say I have an order with three items. I want items 1 and 3 to be displayed to 2 decimal places and item 2 to be...
  12. H

    Continuous Forms - Different Properties For Each Row

    I have a form containing a sub form. The main form is for orders, the sub-form contains items against the order and is set to continuous form view. We have a price field set to a double in the DB back-end that is generally displayed to 2 decimal places on the sub form. Very occasionally I'd...
  13. H

    255 character limit on query fields

    I have a query, the results of which are pasted into a spreadsheet template for a monthly KPI report that goes to one of our biggest customers. The problem is (and I know that this is old news) Access's 255 character limit on fields in a query. Even fields set to longtext or blob get cut off at...
  14. H

    acCmdSubformDatasheetView - command not available

    I came across this thread as I was struggling to get the acCmdSubformDatasheet command to work as I constantly got the errors: Run-time error '2046': the command or action 'Formview' isn't available now For anyone in the same situation, you need to ensure that on your Form Properties, under...
  15. H

    255 Character Limit on Query Fields

    Hello guys. I am having a problem with a query in that it truncates longtext fields to 255 characters. Having read up on this, it seems this is a restriction enforced by Access, for whatever reason. Does anyone know of a way around this? I have to use a query as opposed to a report as the...
  16. H

    Programmatically Change Form Views

    I came across this thread as I was struggling to get the acCmdSubformDatasheet command to work as I constantly got the errors: Run-time error '2046': the command or action 'Formview' isn't available now For anyone in the same situation, you need to ensure that on your Form Properties, under...
  17. H

    Detecting when Access, and not a specific form, has lost focus

    Thanks for your comprehensive response The_Doc_Man. It's never quite made any sense to me, either. But I have seen this behaviour happen on numerous occasions. Basically my user will be working on an Order or Quotation in Access and will have added items to it. She'll then switch to Excel to...
  18. H

    Detecting when Access, and not a specific form, has lost focus

    Also, how the hell can I change my stupid username on here? :D
  19. H

    Detecting when Access, and not a specific form, has lost focus

    Hello, I am using a Microsoft Access .mdb front end and a MySQL back end. I have a bound form containing a sub form. For one of my users, sometimes when she switches from Access to Excel and then back to Access a minute or two later, she gets a #DELETED error in the subform and one or more of...
  20. H

    Long Query Being Broken by Line Breaks

    The query is generated by the following code. As you can see I even tried reducing the length of the lines in the str_sql_select part of the string but that makes no difference as they're all concatenated. Dim str_sql_select As String Dim str_sql_from As String Dim str_sql_where As String Dim...
Top Bottom