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!

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

Recent content by ccheng

  1. ccheng

    How to define SQL?

    Hi, Below, I have modified the calculation codes below as shown in blue, with the code I replaced in red. stSql2 = "SELECT tc05_Services.Ix_Statut_Prestation_tc05,tc05_Services.Ix_Service_Modulebox, Sum(tc05_Services.CSUR_EB) AS SumOfCSUR_EB, Sum(tc05_Services.CSUR_MEP) AS...
  2. ccheng

    Export/Import data from one Access database to another

    Hi, I'm wish to export a table using the same export function that exists already in the Access program. Below is the code that defines the export function. How should I modify it so that it will also export another table name "td03_clients"? Public Sub ExportData(repertoireExport As String...
  3. ccheng

    Defining VBA codes

    Can someone help me with the following form? I'm new at this and I'm trying to figure out what links or formulas are used to calculate PrixAnnuelHorsOption3 and PrixAnnuelHorsOption4. Private Sub Form_Current() Dim Volume As Double, prixDemar As Double, prixCom As Double, prixDemarVol As...

Part and Inventory Search

Back
Top