Recent content by AndyC88

  1. AndyC88

    Crosstab Query - Dynamic Column Sorting

    What I found was that when I pasted the concatenated string into the column header property and viewed the query, it worked as intended. When you go back into the query editor it then throws an error (something like exceeded the 1024 character limit) but it does work if you don’t go back into...
  2. AndyC88

    Crosstab Query - Dynamic Column Sorting

    I think that's the solution that was used here but I couldn't get it to work / follow the code to apply to my db.
  3. AndyC88

    Crosstab Query - Dynamic Column Sorting

    Sorry arnelGP - I don't follow? There are multiple column headings?
  4. AndyC88

    Crosstab Query - Dynamic Column Sorting

    Hi all, I have a Crosstab Query with a large number of columns (~100) which require to be in a custom order. I have achieved this by sorting and concatenating the column headers into a string within an unbound text box ("Equipment53","Equipment54","Equipment55","Equipment56" etc...) and...
  5. AndyC88

    The Most Powerful form Filter and Requires almost No Code

    MajP, Arnelgp, thanks for your work - this looks really useful. How does this work with the modules? Is it a case of simply copying this into a new database or do you have to alter the code? Many thanks!
  6. AndyC88

    Multiple types of filtering on form - cascading combo boxes refining a list box selection?

    Interesting - why would it not be a good approach? So, what I've done so far is insert the form in yellow as a subform - which is then linked via the parent / child properties to the list box. This seems to work OK. Would this be a good way forward, and what would be the best method of...
  7. AndyC88

    Multiple types of filtering on form - cascading combo boxes refining a list box selection?

    Hello all, I've attached a mock-up of how I'd like a form to work on an access project I'm working on. (complete newbie - no programming experience!) Yellow box on the left displays a variety of information with regards to employee (more than what is shown). I'd like to find the most...
  8. AndyC88

    Append Query when creating new record?

    That's absolutely perfect - had a look at the VB code and that's far beyond my capability. Hope you don't mind if I incorporate this?
  9. AndyC88

    Append Query when creating new record?

    Arnelgp - thanks for your example. I'm probably missing something very obvious here, but in your example, when the record is changed on your employees form it resets the check boxes. They don't seem to be getting "added" anywhere?
  10. AndyC88

    Append Query when creating new record?

    I've triple checked - Syntax is definitely correct. It's strange - I created a new form based on the same table, and it works perfectly. Odd.
  11. AndyC88

    Append Query when creating new record?

    Thanks The_Doc_Man. It may sound peculiar but nearly every staff member has a different combination of requirements. If I created the EmpType - there'd nearly be as many as there were employees. There's also no requirement to track the equipment. I'm not sure it's great database design, but...
  12. AndyC88

    Append Query when creating new record?

    Again - thank you all for the replies. So - I think there's an issue somewhere which has had me banging my head against the wall. Every time I tried to run the query - after specifying the correct employee ID in the expression in the query, it pop up asking "enter parameter value" - even...
  13. AndyC88

    Append Query when creating new record?

    Thanks for the quick reply Ranman256 - any chance you could expand a bit further? I'm new to access and I have no background in IT... As I understand it, you mean that the EmployeeID is generated and saved when I create a new employee, but how do I specify this, and wouldn't this mean I need...
  14. AndyC88

    Append Query when creating new record?

    Afternoon all, I have a table (TblEquipmentRequirements) with the following fields: EquipmentRequirementID (PK) EmployeeID (FK) EquipmentID (FK) Required (check box - YES /NO, not strictly necessary but required for UI/UX) When I create a new record for a new employee, I'm trying to use an...
  15. AndyC88

    Using a button to filter a sub-form - doesn't work when using main form.

    Thanks Gasman, I watched the video but that's using combo boxes to filter a query. My form is just based on tables - not sure I can get it to do the same? The control it wants should be the EquipmentCategoryID - so that it filters from a list of ~130 down into a more manageable list. It works...
Top Bottom