Search results

Excuse me~ I'm a newbie. I don't understand "old-fashioned way" in the answer very well. Is it possible to give me more precise explanation?

Yes!

I tried this, the result showed error. SELECT Table_1.Day, Table_1.ProjectName, Table_1.Site, Table_1.[No] FROM Project INNER JOIN Table_1 ON Project.ProjectName = Table_1.ProjectName UNION ALL SELECT Table_2.Day, Table_2.ProjectName, Table_2.Site, Table_2.[No] FROM Project INNER JOIN Table_2 ON...

Sorry...I do not know I can directly upload file here. This is the file.

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!

When I use the "CanGrow" property, only the height of cell with more characters becomes higher. But, the height of other cells in the same row remains unchanged. That is, cells with different heights exist in the same row. It become weird when the grid is shown in report. Is there a way to solve...

When I use the "CanGrow" property, only the height of cell with more characters becomes higher. But, the height of other cells in the same row remains unchanged. That is, cells with different heights exist in the same row. It become weird when the grid is shown in report. Is there a way to solve...

Thanks! I get it.

I got error in this line, but I don't know why? Do Until TextWidth(strText) < ctl.Width '- (ctl.Width * 0.26) I use the Chinese edition. Is it possible due to this?

I have tried this, but it changed font size of all text in the whole column. Can I change the cell that text length exceeds column width only?

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!

Thanks! It is resolved successfully.

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] & "...

1. This file is just for test, so all of item in this file is not real. I just want to check if the fn could work. 2. Form_2 is main form, and Form_1 is sub-form. No in Form_1 and Form_2 is connected. There would be several records in one document. This would cause replication of No, so I...

It works!!! Thank you!

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

Thanks for suggestions! The problem was resolved successfully.

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