Search results

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.

Hello~ I've set the Can Grow property to Yes for all controls in the Detail section. This make the height of specific cell grows, but the height of other cell maintains. It looks weird when the border of cells are shown. I tried to refer to...

Unfortunately, yes. And sometimes, records need to be print across when the number of records is a lot. Is there any file and video can let me refer to?

The number of records in my report is uncertainties. Could I fix number of records in one page in the report?

Hello~ I tried to make a table in report. The area of the group header, detail section and group footer in this table should be fixed. I know I can fix the height of group header and footer by pulling broader. But, the height of detail section would be changed by amount of records. How can I fix...

I think I succeed by this: Project.ProjectName AS ProjectName