Search results

Is that not bias? I made the point that i am not biased in my decision making in the "real" world. I have tried within the confines of this thread to provide some support and references for an idea as a basis for discussion. Not as a target. If you read what i have written i tried to present a...

Here is an article from a respected journal on the problems that specialization can confer. I am saying that once an animal or plant or business becomes too specialized it is at the mercy of the environment. What i am saying is that specialization confers a disadvatage in times of change...

Not implicitly but the use of intelligent design in context defines God as the intelligent designer. It is a religious dogma after all. The socratic method is the testing to destruction of an hypothesis by reasoned discussion. I didn't think you actually destroyed it so much as dismissed it...

Ah but the programmer is not God. The programmer is inside the eco-system. The programmer reacts to changes in the eco-system which are so complex as to be random. The programme is perhaps like a symbiotic larval stage of a the programming creature. The programmer produces the larval programme...

I tend to disagree on this point. Programmes fit the evolutionary model almost perfectly. Example. A programme is written to do a task. In order for it to work it requires an environment. The environment is in two forms. Firstly the computer platform i.e. the motherboard, processor, memory...

No offence intended. :)

Hi, I use a few sites with this facility and i don't particularly like it. I've seen a number of flame wars start simply because two people posted the same solution to a problem at the same time and only one was accredited with points. I've seen people copy replies verbatim from early posts to...

Hi Pat Thanks for the reply. I've done some research recently on this subject and it seemed to me that their was real lack of clarity in a lot of what i read. For example many people who discussed implementing a design in Access appeared to be talking about methods that i've read about for...

Hi, I don’t want this to descend into an argument over the use of natural or surrogate keys. If you put a search into Google you can find hundreds of such discussions, it’s been done to death. I’m actually interested in the way(s) in which Access allows you to implement surrogate keys – most...

OK i can see the problem. Your where clause is not working against the table you are selecting from. you need to replace sewerform with the table name "SELECT [SEWER SERVICE LATERALS].[PIN] FROM [SEWER SERVICE LATERALS] WHERE ((([SEWER SERVICE LATERALS].[PIN])='" & Me![ADDRESS3] & "'))"

Hi, Changing the SQL string to include the correct bracketing should cure it. Also be aware that you are passing the parameter as a string by using the single quotes around Me![ADDRESS3]. That's fine if PIN is text however if it is Numeric lose the single quotes ' sqlswr = "SELECT...

Hi, Try compiling/re-compiling your code modules and forms. I've encountered this problem when there have been errors with the code or broken references - make sure you have used option explicit at the top of any code module. HTH TS

Hi Kraj. Yep an excellent idea. I have been thinking about a similar thing for systems analysis for some time. The flip side of problems with table design and normalization is the information [for want of a better word] being analysed doesn't necessarily reflect the real world system the DB is...

Hi, The "long and narrow" approach the Sergeant outlined is -i believe- the logical way if you are developing surveys regularly. It may even be the preferable way regardless. However with regards to "short and wide" way in which i have done mine i made use of pivot tables/graphs in Excel linked...

Good first question. :) I've done a couple and generally take this approach, though there are limitations due to the 255 field limit for tables i.e. if you have more than 255 questions i'd think twice about doing it this way. I start with a questionnaire/survey table. If a question is yes/no...

Thanks Jon :D

Hi As an example if you enter a H into cell A2 and create this formula in another cell outside of the selected range A1:A3 - otherwise you get a circular reference error - it will count 1. Add another H to A3 and you'll get 2 and so on. =COUNTIF(A1:A3,"H") HTH TS

Hi, The easiest way is to rename the groups. click on the cell with the group name i.e. Qtr1 and it should appear in the forumula bar where you can then change it. Start with Qtr1 and call it Qtr - to avoid a clash as this will become Qtr4 - then rename Qtr2 as Qtr1 : Qtr3 as Qtr2 : Qtr4 as...

No worries.

Hi Colin, The usual problem is the date format for the column is incorrect for a 1 or 2cells and that prevents it from grouping. 99 times our 100 you'll never be able to find the cell that's wrong. The simplest solution is to format a blank cell in the format you want then copy the cell. Then...