Recent content by zkarj

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

Aye carumba! Turned on. Lots of renames done now. But it did miss some stuff.

OK, I found a "Find and Replace" shareware plugin which has worked OK for the table names. It was a little tricky because it does not distinguish between different uses of the same names (table, field, caption, record source etc). However it is going to be next to impossible to rename the...

Thanks QTNM. That's pretty much what I did. The offending field was "". I replaced it with ' ' and it works. The "Allow zero length" property is the default "No". I'm still annoyed that Access won't tell you which fields are in error. It either needs to give better errors or get some real...

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

Further detail Perhaps to illustrate most clearly, here is the actual query I wrote which does the job in the ugly fashion. INSERT INTO tblRelease (Project, Phase, Application, Version, Date, DateVariance, Time, Reference, Description, Impact...

Thanks RG. However, I think I have not explained my requirement clearly enough. I am a programmer, just not a VB programmer, so I think I understand what your code does. It appears to use only a single file to source and add records. In my case, I want to source records from one table and...

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

OK, I just stumbled across the answer. WHERE (DateAdd("d",tblRelease.DateVariance,tblRelease.Date)>=DateValue([Enter Effective Date])) The problem being that Access was trying to help me when it saw the simpler version by implicitly doing the DateValue() but couldn't cope with the expression.

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

OK, after much playing, this works: SELECT AI.Application, AI.Server, AI.Instance, AI.Status, AU1.Project, AU1.Role, AY1.Activity, AU2.Project, AU2.Role, AY2.Activity, AU1.[Application Instance ID] FROM ((([Application Use] AS AU1 INNER JOIN [Application Use] AS AU2 ON AU1.[Application Instance...

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

Defeated I think I will admit defeat. I created a form but still need to read through the examples to make it work. Although I suspect I will now need to create additional (and somewhat pointless) forms for entries to other tables, simply so the users have a consistent place to go for data...

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