Search results

I've posted in general because I really don't know what approach is best for this requirement. I can't even come up with a meaningful, yet succinct title. Here's the problem. I have tables: tblApplication - defines an application (name) tblServer - defines a server tblInstance - defines a...

I have an append query which fails due to validation rules. There are no field validation rules, only enforced table relationships. There is an autonumber field which I am omitting from the INSERT and SELECT clauses in the hopes that it will take its next value. How do I determine which...

While there are lots of detailed issues discussed and resolved here, my problem is at a much higher level. Here's what I want to do. I want to generate records in a file based on the user entering some 9 different values. The first two values will be used to get records from file A (they are...

This is driving me crazy! What am I missing? Here's my query: SELECT tblRelease.ID, tblRelease.Application, tblRelease.Date, DateAdd("d",tblRelease.DateVariance,tblRelease.Date) AS ToDate, tblRelease.Time, tblRelease.Description FROM tblRelease WHERE...

A while ago I inherited a database which I have been slowly improving through normalisation and adding of new data. Now I have it pretty close to what I want except for one thing. A number of the tables (there are 18 in total) and many of the fields are inappropriately named. I would like to...

Firstly, I was surprised that Access does not seem to allow mutliple joins without nesting. I've used other SQL engines which allow a discrete set of joins to be specified. Anyway, I think this makes it harder, but it should still be doable. I have the following tables and relationships that...

Before I start, I know there is much about "Cascading Combos" in the forums, but I'd rather not go that way. I have a table of Servers (only field is Server ID) and a table of Domains (Server ID, Domain ID). This is one-to-many, as each server will have multiple domains within it. I also have...