Recent content by yunhsuan

Thanks for your suggestions. I have succeed to modify.

Hi, The data in forms is easy altered negligently. Is there any method to restrict all the records in detailed region edited? I think that the button can be create to activate the function of editing. So that, the function of editing records in detailed region would be locked until click this...

Thanks for your suggestions! I got the point!

Hello~ There are four field, AutoNo, No, Price1 and Price2, in my table. I order this table according to the "No" field and show them in the report. Then, DFirst Fn was used to calculate the first value of Price1 + the first value of Price2, and it was filled into the cell in header. I expect...

I turned on the Hide Duplicates property. The repeated dates disappeared successfully, but their grids also disappeared. This make my report look weird like this: Can the grids show when the dates in its cell are hide?

Thanks! My problem have been solved by your suggestion.

Hello! There are several records in a subForm, like below. At the footer of the subForm, I want to calculate PRICE according to conditions, the total price of condition "a" minus The total price of condition "b". For example, the condition of No. 1, 2, 4 is "a", and the condition of No. 3 is...

Hello~ I want to make the table group by Date in the report. But I hope the information of Date shows next to the Item column, and the same date only show once(the result should look like right one below). I just know how to let the result shows like left one, and both of Date and Item were put...

Hello! The column in subform can be easily deleted by selecting the whole column and click "delete" key in Datasheet view. This means users may delete colunms in subform accidentally. How to prevent this from happening? Thanks in advance!

Yes, I want. I have sent you a pm. Thank you!

Hello! There are several combos in the form of my database, and the combos are query to the datasheets. Because the list in datasheet is too long to let users find the correct one quickly, I hope users can find related name by just typing one or several words of the target name. Then, I found...

Thank you! It works successfully in my database.

I made a report in access with "Can grow" property in the Detail section. One field in detail section shows one or several invoice number. EX: TB-25886600 TB-25886601 TB-25886602 Ctrl+Enter is used to change to new line in this field. I want to get the number of rows in this field; for example...

Thank you!!! That's what I want. I know how to do.

This is similar to what I want. But I don't want the space between two cells. Is there method to remove the space? I want my table look like this one.