Search results

I have a copy of my DB attached here. Please start with form frm_everything and enter any date and time then you will see the combo boxes. Thank you in advance.

Hi, Thanks for responding. I downloaded your database sample and unlike what you have in my computer it shows Cat instead of "-Select One-". Please see the snapshot here: I believe there should be something wrong with my Access settings because the property settings theDBguy suggested works on...

Not too many. I have 10 rows at most. Thanks for all suggestions. I am going to work now and will try all you said when I am back. Silversun

I tried your method in Format Property. It works for a combo box with row source defined as "Value List". My combo box has a query as row source and this method doesn't work. Thank you for your help anyways. I am still trying to figure it out. I am not sure about Union query, not familiar with...

I think I was not clear enough at the beginning. I am not going out of each section neither vertically nor horizontally. I am within my first record and want to have my pointer showing for example 7th colored box. In next record the value (Risk_Level) that was used to place the pointer on the...

The Format Property gives me option to select one of the values as Default Value but it MUST be one of the items in the list that user can select which is not my option.

I will wait for you to get in front of your computer. The Format Property gives me option to select one of the values as Default Value but it MUST be one of the items in the list that user can select. Union query, I am not sure how I can use it to my benefit in this problem. Please explain...

Hello Covid-19 fighters In my report I want to create a graphical representation showing a pointer that points to a multi-color bar according to one of the fields in my report for each record. I realized my report takes the value in the first record for pointer and uses the same value for all of...

Hi everybody. I have a Combobox and I want user to see "--SELECT ONE--" or something similar without adding this item into underlying table before clicking on it to see the rest of the items. Also I believe it makes sense to see all items in the list excluding "--SELECT ONE--" when user clicks...

Your instructions about modifying tables and sub-report helped me to solve the issue. I now have my project close to finish and appreciate all your helps and others people in Access Programmers. Thank you

I have created the junction table tbl__RiskLogs and filled up some of the records manually. Now, if I want to get my report based on this new table, each record shows only one of the risks and related info from tbl_all_Logs. How can I get a report of all five records in this table and show...

My case line order was low to high initially (and it did't work) but as arnelgp recommended I switched the order before I got the desired result. May be if I would keep the case order and modify the range properly it could be working.

Hi, Continue working on my project, close to the end I have a new issue with my report. Please help me on this. I have a larger table (Table A) and a smaller one (Table B) that has only 4 fields. Five values that are Foreign key to table A are stored in table B. The way I have my relationships...

It works now. By reversing the order it start working. Thank you all specially arnelgp

Yes. When I say it is not working I mean it only executes the last "Else" clause statement. I changed the format to integer from single but still not working! I changed the function to "Sub" as well.

Thanks for your help but it is not working at all. With this last format I get all errors on my case statements I changed the format to "Integer" and follow all you and others said but it is not working. When I say it is not working I mean it only executes the last "Else" clause statement.

Hi I used two different formats as you and arnelgp suggested but it is not working. Can you please help? Private Function myBar(test_riskRate) Select Case test_riskRate Case (2160 < test_riskRate And test_riskRate <= 1944) Me.myArrow.Visible = True Me.Box34.Visible = True...

Hi everybody, I have a case statement in my project that is not working and I can't see the issue. Anybody can help me please? When I call my function, any number that is assigned to riskRate (for example 1700). goes through case statement function and always executes "Case Else" clause only...

Hi, I was able to successfully fix the issue. With your suggestions I created a single table with all the values for risk measurements in it. Then using Column() property of each combo box it was easier than I thought to calculate the total with VBA under AfterUpdate event of each combo box...

Hi, I have created my single table with all values in the same place rather than multiple tables. I understood what you all said about the structure. I tried my best (as always do) not to repeat data or tables. So now I have created a table that includes all risk numbers with their corresponding...