Recent content by Donury236

Thank you. This is, I think, the answer I was looking for!

I have all the data. Its all cleaned so that it has the correct matching fields to Access so that it populates all the fields. I have spreadsheets that have the contact details and the asset details matched up already. The Access asset maintenance template has 2 tables : contacts & Assets...

Apologies. I though it was clear when I mentioned it after mentioning the equipment, that a client (or Contact as access has named the table In the template) could have more than one peice of this equipment. But then you. Guys understand access and I do not.. So My issue isn't an issue...

I do apologise if I make a hash of explaining this I have made a few changes to the asset management template and its basically what we need to track assets at work. I have approx 1220 clients and 1600 items of equipment. Some clients will have more than one peice/type. I currently have...

With the category, we have things like mobile hoists, ceiling track, stairlifts, closomats, Biobidets. So for mobile hoists, we could have a type like an Oxford 180, and they are only supplied by Brand Invacare under the category of mobile hoists. But if that can all go in one table that would...

Can I run this past, anyone, with the knowledge? I am still trying to figure this out as IT has said NAY to a database as new CRM is coming soon (18months is soon apparently!!). 1 client can have many different pieces of Equipment. 1 category can have many brands 1 brand can have many types 1...

Thankfully its the Cooncil IT guys as that's who we are in the partnership. They apparently like to tinker with things. I've not had much time to look at anything to do with it lately as we are on emergency procedures at work. Hoping to soon though as I am getting even more irate at having to...

No idea. As far as we are all aware they have not even started looking at prospective solutions. Given that we work in conjunction with NHS this is something that I think might be on the back burner for the moment as we are in 'emergency mode'. Though management have a time frame of 12 months...

Apologies...I am just so used to shortening it all. Not that anyone needs to use them...LAHSCP(Local authority health and social care partnership), CES360 (the MSOFT program we use for equipment issuing....its a but like an online shop), GDPR (The data protection regulations), LA (Local...

Apologies. Those fields are what is the header for the spreadsheet currently, and in the format that the external company needs the data. When I say pull the data I mean that I would like to be able to take the existing data, rearrange the it to match the database fields that it will populate...

CJ, Input initially I would want it to save time and just pull the data from existing excel spreadsheets. During use it would be data that would be manually inputted by myself and who ever else uses the database, ideally in a Form format. I have looked at some templates and there is a...

I am very new to access and I am still trying to work out if it is what is right for what I think I need. I apologise if this rambles - I have just spent the last 8 hours updating files. Background: My role is administration of stairlifts and hoists for a LAHSCP. We use CES360 but it is not...

FAB, I shall have a read. I have to use the data in the sheets for a variety of 'things' but it's mainly - List of clients and then a list of the equipment. And I need to log service dates (due and done) when installed and when removed. I want to be able to track from the client-side what...

So, me. I work for a local authority social care partnership in Scotland. Currently I do the admin for servicing and install/removal for hoists, CT hoists, stairlifts and special bathroom equipment that we issue. Outside of that I and my partner are parents to 2 humans and have amassed 3...