Search results

I would suggest going to somewhere like InfiniteSkills.com and do some videos first - :)

You used to be able to create an executable of the db. That hides everthing...

Seems if you had 'or' and someone put in a can the you should only put in cans from that point forward - ?

How is the code getting into the second table?

You have to make sure the criteria string resolves into something sql will accept. Example: OrdersCount = DCount("[ShippedDate]", "Orders", "[ShipCountry] = '" & strCountry & "' AND [ShippedDate] > #" & dteShipDate & "#")

Access has to take the entries in the criteria lines and form them into what it thinks is the correct sql statement when you close the form. These are the results you see when you open it back up. The only work around is to really get you head around how the and/or stuff works within rows and...

Seem you could use a couple embedded IIF()s - ?

Sounds like a reasonable plan. I would do it with a function - :)

My first guess would be your library references changed. You can search the forum to read up on the topic...

For starters, it looks like you could normalize the exposure table tblIncident ID pk date etc tblExposures ID PK IncidentID fk ExposureID fk tblExposureTypes ID pk Each Incident can have multiple Exposures and each Exposure has an Exposure Type Hope this makes sense...

Unless you have this developed and in production with a lot of data in it I would suggest you re-think your data model, 5 po flds in one table is bad juju...

In the context that you are using it there may not be an advantage. But I some cases it could be usefull to have it available at the db level. Like in case after you went to form 2 there may be an option to pull a third form or perform some operation that used the record id. In your case it...

Storing QoH or calculating it on demand is an on going debate...

To start with seems you're a bit gullable to think their praying to God really lead them to the decision to go to war. It was a damage control thing... In any case faith is not inherently evil, it's how it's applied. Apply extremism to most anything and unexpected and sometimes bad things can...

You got me...

Is this unreasonable 'faith', just faith in some things or just selected things which is unreasonable?

Seems it is not the faith in itself at the root of the evils but the miss-application of the principles of the faith?

Are you the original Rich?

Ugh... The worst part is they probably want their data from the old, poorly designed database to work with the new stuff...

Agreed good starting points. But: a. You can normalize too much sometimes. A lot depends on the deployment. b. Somebody (read between the lines) needs to walk the business process(s) and understand and collect the business requirements, making it a point to not even mention a computer or database.