Search results

Hi all, My first (and almost certainly last! :ROFLMAO:) database will soon be going 'live' where I work after many weeks (/months) of trial, error and pain... The database tracks personnel, equipment and training data for my organisation. One of my forms allows a user to select multiple...

Hi all, I've just noticed something which has really started to bug me; it seems access creates a very thin transparent border on the inside of list boxes used on a form. When the border is small, it's not really noticeable but no I've noticed it I can't unsee it! I've attached a sample image...

Hi All! This is probably really simple - but I feel like I've got a fundamental misunderstanding of how this is meant to work. I have a table with several fields; three of which are "supervisor" fields. Issue: When I try to delete a member of staff, ALL related records are deleted, rather...

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

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

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

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

Good afternoon everyone, this forum seems like a really great place to ask for some guidance, so I'll begin...! To give some background, the way my employer manages it's personnel (for certain tasks) is pretty dire. A lot of it is managed using excel, and even though we use MS Sharepoint, the...

Hello everyone! Just wanted to say hi and introduce myself. I’m Andy, completely new to access and any sort of programming. I came across your forum while looking for a few access related queries (no pun intended!) I’ve embarked on a project to try and get the company I work for to manage...