Search results

  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...
  16. AndyC88

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

    I've read that macros aren't the best method - but I have zero experience writing any kind of code so it's all I can use at present... will take a look now.
  17. AndyC88

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

    Afternoon all, I've got the following issue - I have a list of equipment requirements for each individual - and I want to be able to filter them based on their EquipmentCategoryID. Using the buttons, it works as expected when the form is opened by itself. However, when I try and use the...
  18. AndyC88

    [beginner] - Migrating personnel management system from EXCEL to ACCESS.

    Pat, thank you for that explanation. It is absolutely to facilitate data entry, and also their values may change / get added / deleted over time so I assumed it's easy to do this via a linked table than go through and edit each record individually? Thanks for the tips on the naming conventions...
  19. AndyC88

    [beginner] - Migrating personnel management system from EXCEL to ACCESS.

    Apologies ... trying to fix everything at once and not taking it step by step - I'm also awful at explaining myself 🙃 To try and explain a bit better - the end result is getting the data out of the system in a way which can be displayed meaningfully. As this is the end result, I will create a...
  20. AndyC88

    [beginner] - Migrating personnel management system from EXCEL to ACCESS.

    Yes - exactly this! Not deliberately being secretive or anything.
Top Bottom