Search results

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...

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...

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...

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! I'm sorry to bother you again - abou a topic that is dealt with many times in this forum as well as in others. I have been reading many posts about multiple search by the help of check boxes - and I have tried to apply some solutions - but with little progress, because I only understand a...

Hi all! I wonder - after having no answers after rerading a lot - How do you use check-boxes as selection criteria for a search - say in the output for a report or a form? Do I make myself clear? Thanks. / Anders

I have created a small database, just containing one table. Now I want to make a MDE-version. But Access refuses!! Was not able to do that - it says without excuses or explanation! Why? Can anyone give me an explanation? / Anders

I have a problem with my relations.... I have set upp a data structure where I have ome main parent table ("Cassification") and several child tables ("Authors", "Subject" etc etc). The "many-tables" are joined to the parent table via ´"LittNr". that is a primary key (autonumber). In every...

Thanks! Deep inside me (very very deep) I knew this, but I was unsure. You relieved my tension about this matter. Thanks again. / Anders

I have a silly question. (Silly - because I should by now know...) Anyway. I have had problems with forms built upon a query consisting of several tables. One of these (the Master) have a one to many relationship with other tables. If I on the form (built from the query) start to put in data...

Hello! I'm stuck again. I have a database with several tables. They are joined on keys on a many-to-one relationship. I.e I have a parent table (having many related children tables). All children are related to the parent table using the same ke(= KeyNr). Building a form from the query I can put...

Hi all - and Happy New Year! I feel a little bit embarrased to ask this but I'll do it anyway. It is about "joins". I have constructed a lot of tables (one-to-many) that are properly joined. Then I have based a query on them. Then I made an input form based on the query. I could put in two...

Hello ! I put a tabbed control on a form and made four pages on it with four to five combo-boxes on each. In design mode it "stays put" when walking through the pages. In form view (viewing mode) it jumps up and down in the most irritating manner - depending on what page I press. It does not...

Hi ! I'm still struggeling woth my librarian database. Have learnt a lot from all discussions in this forum and elsewhere. Apparently however - I haven't learned enough. So populating my tabbed pages with combo-boxes related to quearys based on various tables I wanted to put in some data...

Hello! I have a combo-box on a form based on a lock-up table. Depending of user choise a corresponding number is then passed to a table for storage. This works just fine. BUT - when I decided to make this form a subform on a tabbed page (I did so by just dragging my form onto the tabbed page) my...

Hi ! Maybe the WCVHNAP (World Community of Very Helpful and Nice Access Programmers) can help me with these two questions that softly are killing me. It is like this - I want to do selections (for viewving and for producing reports). What I have is a Query-table (based on multiple tables). In...

Hi all ! Still struggeling with my litterature database - solving some problems sometimes, running inte new ones now and then - i keep myself busy. I want my application to have dual interfaces - one for english speaking people and one for swedish speaking people. In order to show data about...

by the help of the Access World Community I am on my way putting up a librarian datbase covering special research litterature about drug addicts. Since I want researchers and practitionairs from all over the world to have access to this "knowledge database" I have constructed forms in both...

Hi ! The more answers I get - the more questions is popping up... Anyway - by the help of the Access World Community I am on my way putting up a librarian datbase covering special research litterature about drug addicts. Since I want researchers and practitionairs from all over the world to...