Recent content by kyon

Hi, I have this sql statement in the VB application as follow: Dim sql As String Set rsForm = Nothing Set rsForm = New ADODB.Recordset sql = " update StaffItem" & _ " set Measure_Date = '" & "'" & _ " where Cust_Code =...

Hi, I'm using Crystal Report 8.0.1.0 to MS Access DB. I have created a report access to the DB which have content in Chinese. When I preview the report in Crystal Report Application, it can display the Chinese character properly. However, when I export the report to as MS Excel (Office 2000)...

Thank to lbass and synapsevampire I have tried the sugguestion from synapsevampire and it is exactly what I want. Thank you very much kyon

Hi, I'm using CR Verson 8.0.1.0. I want to group records from a table in MS Access and then give out the summarize quantity. For example: A table in MS Access have records as below, Item_Code Season Design Col_Code Adjust_Qty 2300MP 3Y ABC BN7 3 2300MS 3Y ABC WE1 4 2300MP 3Y ABC BN7 1 2300MS...

Thanks Graham and CCLINT Your suggestions are very useful. My problem is the same as Graham mention and the problem have solved. Thank you! kyon

Hi, I created an application using MS Visual Basic Programming Language and MS Access Database. There have many Insert, update and delete statement in the application. I found that after I packing the application, I install it to my PC (used to develope the application). The insert update and...

I do not know how to create a label report in Access. I just know how to use print label function in MS Word. Can you tell me how to create the label report in access. Thanks! kyon

Hi Duane, Thank you very much! Your suggustion is useful. How can I extract the image in image control to print label function of MS Word 2000. kyon

Hi all, Can I save a picture to the MS Access Database? How? I try to set the field type as OLE object. However, I don't know how to check it is really save the picture (*.gif), so I try to use mail merge function in MS Word 2000 to check the picture is correct or not. Unfortunately, it show...