Recent content by Andren

Dear world forum! I finalized my Access-db with a lot of help from you in Access 2000. Thanks! When I now want to make a MDE-database ,Access denies that without explanation. Trying to convert my work to Access97 I am also denied that, due to an error #3017 ("One field is to long"). I am...

Thanks for answering - I really need any suport now. However Following your advice I get a Run Time Error (438) saying "Object does not support this property or method". In my Query I have a criterion in the JoinClass.Class_ID - field saying: [Forms]![ASID]![Subjects] (where "ASID" is the Main...

Dear all. I'm stuck again - despite all help that I got. To review: Now I have five tables in a many-to-many fashion: Writers: (Names etc) Titles: (Titles etc) Classification: Classifications (yes/no-fields) Main: (various information ) Join: (writersID,TitlesID,ClassID,MainID) I have...

Thanks

I'm not as stupid as I thought - I am worse ... Hmmm ... This was hard to admit. It seams that I lack some very basic understanding of Access/database developement and the like. However - I admit it and feel SO stupid - after all good support I got from all of you. As you know by now - I am...

Hi all. I am STILL struggeling with my litterature database. It is now structured in a "one-to-many" fashion,containing a "Main" table and many other little tables (T1,T2...Tn). In the Main table I have "ID" as uniqe identifier for each reccord. It also contains link-fields for each T-table...

My flat file is no longe flat - it's deep Thanks Pat ! I worked all day and tried to normalise my flat structure and it worked quit well. I was afraid for all sub-forms but they did not mess with me either - like they did before. I think this Forum is extraordinary. I am almost 60. One year...

Still.... I am still having a question in mind... This "database" will in a few years contain thousands of reccords about litterature (books,papers,dissertaitions, reviews, drafts etc etc) about research done by the help of a semi-structured interview called Addiction Severity Index (ASI) in...

Many-to-Many (problems...) Thanks Pat ! After retirenement I'll learn how to play Bridge :) / Anders

dcx693 Thanks for answering. 1. Yes it does what itshould 2. No , I can't antecipate any changes needed in the next coming decades (and by then I will be dead - so what the he.... :)) OK - Sorry for beeing selfish ...but I am tired of it by now. / Anders

Dear all! I first wish you all a happy and prosperiuos New Year. Not just in coding. Over the last year I tried to build a research database for specialized litterature. Despite my dumb questions I got great help from many of you. However - I failed to make a working normalized many-to many...

Hi again! Your advice was much helpful and I am ashamed to keep asking, but I really want to be able to in report form pick out the combination of symtoms that arechecked in the search form. you said: ----------------------------------------------------------------------------------- If you...

Dear EMP !! Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You have tought me in the most pedagogical way ever how to do this. You have enlightend my day ! I am happy. I am young again. Birds are singing. You are a genious. Such a simple and straightfoeward solution. AND...

Thank You Dear EMP Thank you. I'll try to evaluate your suggestion tomorrow and let you know the result. Best wishes: Anders