Search results

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! Thanks! Deep inside me (very very deep) I knew this, but I was unsure. You relieved my tension about this matter. Thanks again. / Anders

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

And if I want to use combo-boxes? This was very helpful. You made me understand something that I did not understood before. However - instead of textboxes I want five combo-boxes so that users could shoose any combination of five items (key-words) and base the search on that combination. I...

Well - I could not open it either. Thanks anyway! / Anders

Re: search Well. I got the same message. and do not know what to do. / Anders

OK Lloyd! Thanks for answering. But how do I "set the extra criteria within the design of the query" ? I have five keywords. I think that I want users to look-up five different key-words by combo-boxes (or whatever is best). Each key-word is contained in its own table that could be included in...

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

Yeap ! You are right - an I checked that - redusing the jumping behavior a bit, but not completly. Maybee there is also something wrong with the tab-order between combo-boxes in the Tabbed Control itself. I have to check that efter holidays. For others to learn something from: I had one page...

Tabbed rabbit Hi FUGA and Col ! Thanks for answering. Fuga asked if the tabbed control moved or the entire focus changed and Col asked me to be more precise. So pressing one tab (page) makes the control "go down" half way so you only can see half of it. Pressing the next tab makes it pop up...

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

Thanks Rob and Casey for your answers. I will post my code, and this is what puzzles me; I have a lot of controls on my subpage and I manage to populate my tables and queries through the form - when I look at the code there are however no references like Casey suggested - and still it works ...

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

Multiple search criteria Harry! Your advice was most helpful. HOWEVER - I have encountered a seccond problem. You see, the codes that i put in my database (and that I want to combine inte multiple search criteria) are coming from several stand alone look-up tables with three columns. Since I am...

THIS problem solved Yeap ! It was the settings of the forms that were wrong. Stupid,stuped me.... Thanks a lot for your answers... / Anders