Recent content by DenizBerkel

Hi Paul, Thank you for your reply. In the form FormFind I want to make choices from the combo boxes and regarding to those values I want a list in the list box under the combo boxes. For some reason it does not work... Thank you for your time again...

I have made a simple record finder form into a simple database. But it is not working. Can you check why it isn't working? Thank you very much...

Thank you so much. I got rid of them now:)

Some of the tables' names are as below: MSysAccessStorage MSysComplexColumns MSysRelationships MSysResources

I have greyed out objects in my Access database. I didn't create them and don't know what they are. I tried to delete them but couldn't. Why did they come to my database -or they were already there but now they are appeared- and how can I get rid of them? Thank you very much...

Hopefully this time I could uploaded it correctly... When you look at the GeneralData form there are two fields that I don't want them to be chanced for every record. Because the provider will be the same for maybe 10-15 records. So does the funding stream. How can I keep them fixed unless...

thank you for your reply gemma. i attached my database to make it easier. in the database when you open general data form funding stream and provider fields needed to be fixed unless changed. i used after update event procedure code: Private Sub Combo35_AfterUpdate()...

Thank you Alan. Since I don't have any code knowledge that code you wrote is quite complicated to me. Which parts of the code should stay fixed and which parts should I change to make it suit my database? And where should I write this code? Thank you very much...

Hi, I've been creating a database. I prepared forms to enter records. In these forms there are many fields. I want some fields to stay fixed while going up to next record unless changed. How can I do this? Thank you...

Hi, I have a table with questions and answers. I want the answers to be selected from a drop down menu. The problem is that for each question the answer options are different. That means I need to prepare different drop down menus for each question. Can anybody give any idea how to do it? I've...

I found my mistake ...I wrote criteri instead of criteria for the color Amber... Thank you for your time...

Thank you for your reply. I have already done what you suggested. Form/Query/Conditional formatting. But with the conditional formatting I realize that you can only color the field that you are on. What I want isthat when Criteria field is chosen as A then I want the Rating field to be Green...

Hi, I have a very simple access database to ask you guys how to do this: I want my Rating Field to be Green when Criteria is A Amber when Criteria is chosen B Red when Criteria is chosen C Purple when Criteria is D. I have attached my database as well. Thank you very much... Deniz

I think I have found the answer of my question. Access works both ways. Your code works very well now.. Thank you ever so much... Deniz

Thank you very much for your help Mihail... I think I'm doing something wrong. I want to use the form as data entery sheet and want to capture the data in the table. Is it how it is intented to work or is it the other way around? Because first the code you gave me seemed to work but when I...