Search results

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...

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...

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!

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...

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...

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...

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...

Hello~ I created two tables, containing No, Day, ProjectName and Site. The contents of ProjectName come from another table, called "Project". Then, I combined this two tables by fucntion "UNION ALL" in query. SELECT Table_1.[Day], Table_1.[ProjectName], Table_1.[Site], Table_1.[No] FROM Table_1...

Hello~ I try to create a report in Access. I hope cells in header can show upper border with single line and lower border with double line. How can I achieve this? I know how to show all border, but I do not know how to show single side border. Please give me some suggestion. Thanks!

Hello~ I create a report. Sometimes, the the length of text in cell is too long to fit column width. In Excel, the font size can be reduced to fit column width automatically. Can this also work in Access? Can any one tell me how to do or give me some example? Thanks!

Hello~ I have a table record No, Day, Supplier, Item, UnitPrice, Quantity, Tax and TotalPrice. EX: Supplier_1 Item_1 @12*1-$12 Tax-$0 Then, I use this table make a query. In this query, supplier, Item, UnitPrice, Quantity and Tax are combined to Summary. Summary: [Supplier] & " " & [Item] & "...

Hello! I made a form, containing project, site, stock and unit price. project and site are stored in table Project. stock and unit price are stored in table Stock_Name and Stock_Price. I tried to make site and unit price be filled in automatically according to project and sotck, but I met...

Hello~ I use SUM() to calculate value in subform on main Access Form by control data source (Below is "Test" file). But the value would become unchangeable. So I want to calculate value by using VBA code. I have tried to use DSum fn, but I failed. Maybe I used the wrong code. Can any one tell me...

Hello, I built a login screen in my access by referring to a website. There is a table to store login details, containing ID, username, password and User. User need to key in username and password to login. After user successful login, the form, Test, would be opened. I hope User can be filled...

I tried to set formula as default value. I hope the taxes value can be changed according to two fields in the same table. But it not works as expected. Could any one help me? Below is my access file. Thanks for your suggestions.

Hello I'm trying to make a accounting system by access. There would be quantity, unit price and taxes. Generally, taxes is calculated by quantity * unit price * 5%. I set formula for automatic calculation. Somtimes, taxes is not 5% of price, but the value of taxes cannot be changed. How can I...

Hello I want to make floating numbers, composed by date and serial number. I have succeed to make floating numbers, which serial numbers are reset every day. Actually, the serial numbers need to be reset every month. How can I revise the code in this access?