Recent content by Shusha

Hi Mark, Sorry for being a nuisance. I dont quite understnad , so can you lease help me. This is my scenario. I have a field called AgeNow which is in yrs and mths. Lets say the Yrs is 2 and the Mths is 8 I want the system to roundup and say the age at test was 3. another ex: if the Yrs is 1...

Hi Mark, Can u pls help me with this? The field name I have is AgeF and I wld like this field to ROUNDUP to the highest rather than down. How wld i code it in the above given example of yours : Private function RoundUp(vrRoundedNumber as variant) as variant if vrRoundedNumber /...

Hi Larry, Thank you very much for spending time on my question. I still dont get it..I am going to give you an example here and maybe you can help me out. The questionnaire is a genetic profiling of a client with 440 questions in it - done once for the client there is a client table with...

Hi there, I am in a real fix as to how-to solve this problem. If u cld point me in th eright direction or help me wld appreciate it very much. I have this humungous form with over 400 questions. the previous developer has split this questionaire into 2 seperate tables with one table being the...

Hi john, I agree. Never wait for them to catch up.. I have always been ahead of the game and it is worth it. But there are times when one gets stuck and there is no one I can turn to for anything as I support all of the systems.. this access project was one of a kind.. an assessment database...

Hi John, If i was religious , i wld have said God Bless you. But religious I am not.. So I give you a star and maybe a few more stars for pointing me in the right direction. I am mainframe programmer and what u suggested is akin to what we do there. If the program is too large, break it in...

Hi John, All of the counters are part of the Module.. so it is declared within the module. can u please elaborate on what u mean by: "Assuming that Counters are defined outside of the procedure " I have taken over this db from someone who has done the coding etc. also, i am not that familiar...

Hi there, I certainly can use some help here. Pls let me know if any of you had this problem and how u solved it.. a big thanks comes your way. We have this huge questionaire of containing over 400 questions and the answers for some depend on cumultive totals of afew and likewise. I have this...

Hi leslie, I am sorry i took time replying as my hubby and i were involved in a bad accident and i had to attend to ins. etc. hence my delay in thanking u for ur invaluabe help. lelsie, thks for pointing me to that site. it was informative and helpful. I did print it out and read the whole...

Hi there, I have a problem where i cld use some help. Scenario: There is a questionnaire that has over 400 fields. a composite of a few fields , lets say from Q1 to Q10 may be used to get a total field. there is code attached to this calc.. and it goes on for all the questionaire. Many...

Paul, I have been pounding my head away for the last couple of hrs.. and nothing seemed to work.. and your suggestion was great. Thks so much .. it has saved me a lot of unhappy hrs.. Usha

When i turn the auto track option ON, it tells me "Property value is too large">> so i am two conflicting messages.. i know this msg means somethign wrong with defining field size?? am i right?? usha

Savil, A lot of the projects tables are large size.. i do not see any performance deteoration as the fields are fairly compact size.d most of them are y/n fields, and the numeric ones are anywhere in the range of 0 - 999.. also, i have had large sized tables.. some of the fields here are...

Hi Savil .. there are 235 fields in thsi table. it is a research questionaire.. thks So i have not gone past the 255 fields.. help!!!!!!!!!!!! Usha

HI there, The person who designed the db, I am currently working with, has a table that comes up with this message when I try to save it "Errors encountered while saving". She had added some fields to the existing table and kept working on it.. and now when i try to save it, it comes...