Search results

Thanks CEH and Missingling for your advices! I´ve tested a lot of adjustments to make it function, but the most important things to do was some basic adjustments of the database which I will show here: When you create and move a database or parts of it: Adjustment of Default folder Press...

I´ve copied an Access-database from one computor to another. I get different results when I use a form and search for data. On one computor I get data when I search for that, but not in the other. What can that depend on??

Yes I have lots of data, but I hesitate to make some inputs of that data until I can trust the database. It think it is easier to try and make experiments and see effects in the database if I use a limited amount of data. Just as you did in the database-proposal you presented for me. And I´m not...

I haven´t used Access for very long. But I find it interesting to explore and I´m shure that it will be useful in my lakestudies. I´m very glad for all your help but as you mentioned. It have to take some time. So when you have time I´m very glad for that. My email is b.kinsten@gmail.com.

The question about animals vanishing from a lake. As you said there is a problem to make a distinction between no observation and examined but not found. Perhabs I have to make a special table with a Yes/No field and a field with the date when you missed the animal for the first time. Perhabs I...

Hello David I have some more questions, In your database-proposal I wonder about one construction. When you related the tables tblChemical and tblSighting you used the fields LL and SL to relate to the table tblLakes. I don´t understand what happens when you use that relation instead of using...

Thank you David! You have really given me useful advices. I´m going on with changes in my database. I´m coming back to show my results.

Thank you. I´ve got it. I have earlier just used the columnar form in my subforms. I didn´t see the way the postselector moved. I had the "problem" that I didn´t get an overview of my inputs which, for example, made it easy to make the mistake to write the same information in two records or...

Thank you very much David for giving me your advices. It looks very interesting and I´m trying to explore it so I can understand how you have built it. One good thing was the design with subforms in tableform. One interesting property was the postselector in the subforms which accompanied the...

I´m still a beginner but I´ve made some progress now thanks to some of you in this forum. My central form linked to a question which is linked to a many to many table seems to function in certain aspects now. But it is still not ready for use. One problem is when I write new info in the...

Thank you very much for your help!! I´ve been on vacation for some days so I haven´t been looking at the Forum during that time. I´m not very used to access but I want to learn much more about it because I have sampled lots of data from lakes which I want to write into an Access-database. I´ve...

How can I design a central form with both selectfunction for certain tables and updatefunction for others? I have a many to manytable with foreign keys to connect several tables.

I wish to make a central form where I can read and write information into different tables. I have to use a junction table to link many to many relations to different tables. The central form is based on the junction table. If I browse through the list of names in a field in a table I would let...

I wish to have some advice about fixing problems with forms reading and writing junction table. I use a junction table to connect different tables as a central form for reading some fields and writing other fields belonging to different tables. 1. What decides whether you can write or just read...

Thanks! I hadn´t put in the undoicon in the quick startmenu. Basics which I shouldn´t do, but did. Big mistake!

Thanks for your advice. So if I had made many changes without saving I cannot go one step back and undo the last change like in a wordprocessor. I have to go back to my last saved version. Is that right?

How undo changes in formdesign. For example when I have moved boxes around and I change my mind. How can I undo this change and go back to the design I had before that change.

I´m trying do make a database for biological studies in waters. I have made some tables and want to make forms to read or write information into the tables. I´ve got much trouble to make the forms function. I have also a jointtable with several foreign keys. I thougt that it would be helpful...

I´m very lucky for any help in this topic, but it could be easier to see a solution when the database basicstructure is visual.

Thanks Atomic Shrimp! Your name suits very well for this topic! I can send you the database stucture perhabs in an email? How to go on with the forms? I´ve tried many forms, but they will not function very well. Is it a good way to use composite primary keys?