Recent content by hendy13

i already solve my third problem. this is my final result image : thanks mh123 for guiding me to solve my ms.access problem :)

@mh123, i already used your code and solve my second problem. so this is the result picture: as you can see, i already export the filtered table to excel, then set the property such as borders, font, alignment, background color, etc. now based on this data in excel, i want to create a chart...

@mh123, can i ask you again ?? what i want to ask is : how can i make all font to became Arial in vba code inside your codes? how can i make all text align center, and middle align in vba code inside your codes? how can i make all borders (black colors) from A1 cell to H2 cell ? how can i make...

@mh123 using your code, finally i can solve my problem. thanks a lot ms123, you are great :) here is my code : Private Sub Command250_Click() Dim rst As DAO.Recordset Dim customQuery As String Dim cnt As Integer Dim appExcel As Excel.Application Dim wbk As Excel.Workbook...

Is there anyone who can help me please :banghead:

@mh123, i already modified my code, but still error. Dim rst As DAO.Recordset Dim customQuery As String Dim cnt As Integer Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As Excel.Worksheet Dim rng As Excel.Range Dim welder As String Dim...

@mh123, So i add 1 combobox and the data is MCD-1100,MCD-1101,... and then i add a button. onClick code of the button i put : Dim rst As DAO.Recordset Dim customQuery As String Dim cnt As Integer Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As...

Good day developers. I want to ask about how to export filtered table to Ms.Excel 2007. so this vba code to filtered the table : Dim db As Database Dim rst As DAO.Recordset Dim strSQL As String Dim flnm As String Dim appXl As Excel.Application Dim bookXl As Excel.Workbook...

Good Morning Developers, I already create a query that consist of slag_inclusion, poros, i.f, l.o.p, crack, root_concavity. based on this query, I create a chart. But the problem is, the chart only showing 5 bar (that consist of poros, i.f, l.o.p, crack, root_concavity), but where is bar for...

@JHB, Thanks a lot. it works :D

Good Day Developers, so i already searching for many hours but can not find any answer for my problem. so i create a table called weld_performance. it consist weld_id, weld_prod, total_rt, accepted, rejected, and rejection rate. from weld_prod until rejection rate, the type data is number. the...

@JHB thanks for your reply. i already solved the problem. i really a newbie in this access 2010. so i create a new table and put the value to the table from 6 textbox (you can see from my old post). and based on the table, i create a chart. anyway, thanks for your help.

for example, i create 1 table that consist of Customer_ID, Slag, Poros, IF, LOP, Crack, Root. type data is all Number (Integer). my table name is book_tble. then i create a form and put 1 combobox (control source : Customer_ID), 6 unbound textbox (control source : Slag, Poros, IF, LOP, crack...

Good Day, I try to develop an access 2010 Forms that contains 1 or 2 charts. So my problem is, in my form i have 1 combobox and 5 unbound textbox. Inside Event OnChange combobox, there is function DCount that will setup value to the 5 unbound textbox. until this point, the 5 unbound textbox...

Hello to all developers. My name is Hendy. I live in Batam, Indonesia, South East Asia. i'm fairly new to Ms.Access and want to learn from this forum. Thank's for your attention.