Recent content by VygonDBA

Yup this is what I'm after, perfect thanks. Some redesign is in order me thinks! Thanks again.

I agree but that's unfortunately what I'm left with and I'm not allowed to redesign it "because it works"!

Hi all, I have a conundrum that's driving me mad! I have a categories table with 4 categories that are user selectable on the front end form (P, INCR, SP & VUK), I then have 4 tables that define various failure modes applicable to the categories (tables named FailureModeP, FailureModeINCR...

Many thanks, I had a feeling I'd be looking at either a left or right join!! I'll give it a go. Thanks again. M

Hi all, I wonder if someone could help please as I'm stumped? I'm trying to produce a query that shows all records of patients that have a 'non-active' status (stored in the 'Patient Details' table) and haven't had any deliveries after 31/10/2011 (date stored in the 'Deliveries' table)...

Sounds good, I'll give it a go, hopefully it'll get around the problem. Many thanks for your help again.

Thanks for your quick reply. Yes, I've enabled referential integrity and cascade delete between the relevant tables. Something I forgot to mention(!) is that the delete needs to be based on an inner join between two tables, one that holds patient details and the other that holds delivery...

Hi all, I'm trying to delete data (no archiving required) from 5 tables that all have a one-to-many relationship between them and keep getting the following error: "Could not delete from specified tables". I've tried everything I can think of including the following: * Set unique records...

I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users...

That's the basis of it, thanks for your response. :D

***Update:- Just cracked this one by using T-SQL, if anyone needs the solution please just let me know, thanks.*** Hi all, I'm trying to create a query in Access 2010 based on a warranty_expiry field (data type: Date/Time) that will give me all the records where the warranty is due to expire...

Hi, figured it was time I actually joined the forum seeing as I've tended to get alot of the solutions to my Access problems from here! I'm entirly self-taught on all things Access, I'm actually a SQL DBA by day and a free-lance web designer by night (well evenings and weekends really hence...