Search results

Yup, that makes perfect sense. 20 records with 3-4 fields each sounds a lot easier to keep up with/record than the option I was considering. I would like to also include a way of saying that a person who has done a certain job role can inherently do certain tasks. I have a "Roles" table that...

Hi, I'm working on a database to store details of current employees and I'm a little stumped for the best way to approach part of it. For each person who works for our company, we would like to store details of which tasks they are trained to do. The list of tasks is quite long, possibly...

Lovely, will have a play around with that. I never knew those arrows were there to serve any purpose other than to irritate me until I've arranged all tables to eliminate them crossing... lol Every time I think I'm getting a handle on Access it reminds me how little I know :)

I changed the last JOIN from INNER to LEFT and that seems to have done the trick. Now returning all 66 staff instead of just the 4 with shift data. Thanks both for taking the time to reply. Is there somewhere in design view where I can specify the join type, or does it have to be done in...

Hi, Here is the full SQL for the query. SELECT tblStaff.staffName, tblTeamLeader.teamLeaderName, tblDept.deptName, tblRoles.roleName, tblStaff.shiftPattern, tblStandardShifts.shiftDescription...

Hi, I'm having some trouble getting a query to work as desired and hope somebody can help out. I am setting up a database to hold staff details, and would like a query to show each member of staff's total hours and FTE. Staff name etc is in tblStaff Staff shift details are in tblShifts...

Of course... I had a feeling it would prove to be a stupid question one way or another. Thanks for your help

Hi, Tried searching/googling for this but can't find anything relevant... I have a couple of questions about datasheets. 1. I'd like to use a datasheet for some data entry. The bulk of my data entry will be through 'proper' forms but there are a couple of places in my app where using a...

I tried CJ's approach first and that seems to have worked. I removed the link, did compact and repair on both sides of the database and re-linked. I used the linked table manager to switch from my desktop copy, to the live data and back again without any shenanigans. Thanks again to both of you.

Thanks for the suggestions guys. I'm away from work until Monday but I'll give them a go when I'm back and post back here. Cheers

No, nothing refers to it at all. I just set up the table and insert records to it from an excel sheet. I'm capturing some data about changes made to the sheet but not reporting on them just yet. I turned off name auto correct in both front/back end but still no joy.

I'm far from an expert, I'm lurking around waiting for an answer to my own question at the moment. However, I just this morning had a similar issue to you which I have solved using an append query and a delete query. Some reading here should get you on the right track...

Hi all, Having a wee issue that I hope is simple for somebody more experienced with this Access monster... I have a database that is used in our office. It is split with the backend stored on a network share. I need to make some updates, and to do maintenance I usually make a copy of the...

Does anybody have any experience with this?

So I was playing around with a table linked to an email folder and realised that deleting the record in Access will delete the associated email, but seemingly only if the folder is not open in Outlook at the time. So I need to refine my question to: Can I reliably delete an email from within...

Hi, My manager wants to be able to implement a kind of punch card system for managing staff time. I'm thinking we could make a database that links to a folder in Outlook. Staff will be able to send an email to the inbox saying that they are, for example, going on a break at 10:50, and then...

That's done the trick up to a point, I still get duplicates on my final query due to having data in for more than one day, but I see now how you would tackle that, and what you meant by stacking queries. I'll carry on tinkering, don't waste your weekend trying to clean up my mess :) I'll...

Hi again, The query you posted works great for some scenarios - but not so well on days where I put in more than one break. In those cases it counts the logged in time twice. I've tinkered with some things but haven't managed to get it working how I need it to so far. It's clear that I need...

Thanks for taking another look at that - I left work just after I posted my last message so I didn't check back for replies until now. I'll have another stab at it later on and come back to you either way. Cheers

Quick (hopefully) question if you wouldn't mind. I'm just tinkering with how I'd get an FTE figure and I've got a bit of a hitch. I've set the tables up as you described and added the relationships. I've added a person to the TeamListing table, added shift details for a Monday, and added a 20...