Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kyon
  • Content: Threads
  • Order by date
  1. kyon

    update date to Access DB

    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 =...
  2. kyon

    Hi, I'm using Crystal Report 8

    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)...
  3. kyon

    Group by in CR

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

    Problem in running application in window 98/2000

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

    Save a picture to MS Access DB

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

Part and Inventory Search

Back
Top