Search results

A combination of both. I have attached a document that is basically the questionnaire itself for you to look at.

For Mike: Half-way in between - it will be a mix of new and existing "patients" or partiicipants in our case but it will not be as fast moving as a doctors surgery. Some times we have 60 incoming calls in a week, others we are lucky if we get 10. Are the people with who appts will be made...

Hi Mike I hav written some things in the other post. Stitcho I have something that may be useful

I think you should take that down if it is real peoples data

Thise controls look interesting but I cant afford 600 dollars I just need something simple. I actually have an example but I dont know how to fit in into my plans Basically we have a set up where people contact us for a study. We log each call including name, phone number of the person and...

Anyone have any ideas?

I just posted a topic on this as well - I cant find any examples. Ill be watching this thread with interest.

DOes anyone have any examples that they are willing to post or links about how to build an appointment book in Access? I have tried google but I cant seem to find useful links. Thanks.

You actually made an important point about 15 and 16 - we should be dealing with whole numbers in this particular case however when I am asking participants to fill in info who the heck knows? They never follow instructions anyway. In general though I was following the scoring code for the...

Thanks, There is a good article from Miicrosoft - I will check it out.

I wasnt able to recreate the issue and have since changed my database to use single -->standard --> 2 decimal numbers in the form. THis seems to have sorted the problem out. It just drove me crazy when I could clearly see that the equation was one of the most simple ever created and it still...

I recently changed the code to a case statement which recoded a value into a new field i.e. Case = 1 Me.Field2 = 2 and so on... However the old data would not reflect this change as the Me.Field2 value had already been created. Short of opening each form, changing a number closing it and...

I have a simple query based on two fields that says Component4 total = no of hours sleep/no of hours in bed * 100 where no of hours sleep = 9 no of hours in bed = 10 therefore component 4 total should = 90 instead it equals 89.999999 How can this be? For all the other records the answer is...

Okay I know this is overboard but I just want to make sure I am doing it properly. If my scoring is: <= 15 minutes = 0 16-30 minutes = 1 31-60 minutes = 2 > 60 minutes = 3 Then the code would be: Case Is > 60 Me.Q2PSQIRC = 3 Case Is >= 31 Me.Q2PSQIRC = 2 Case Is >= 16 Me.Q2PSQIRC = 1...

So if I used my example above with component 4 etc.. my case statements wont select value if it is 84.5 - and I should use the nest case >=75 and <85 <- this way it would pick up all values of 75, 76...84 including decimals of 84.

Okay just wanted to check. I think I am better using off < = > symbols so I can be sure what I am asking than on relying on to..

Did it work? Wooho that was my first good/helpful piece of advice on this board to do with VBA :) although I am sure someone here is sure to tell me I am full of it. See one, do one, teach one :)

Whole numbers or decimels for the second number? THe other reason I ask is because I have a select case statement that says: Case Is > 85 Component4Score = 0 Case 75 To 84 Component4Score = 1 Case 65 To 74 Component4Score = 2 Case Is < 65...

Im not nearly as experienced as anyone here but Ill tell you one thing I have learnt very quickly - never code as if you are trying to meet the needs of your most experienced user - but for your least experienced user. They are always going to do something you never could imagine could even be...

I am wondering why access does not follow its own code all of the time? For example I have passworded forms following the tutorial on the Microsoft site. It mostly works when the participants fills in the wrong password we will get an error message box and when they cancel the password...