Search results

  1. C

    Progressive sum

    Hello, Excuse for my English. In a query I entered this formula to calculate the progressive sum sales of single products: TotProg: DSum ("[a] + [b]"; "Tbl name" "" Date <= "& [Date]) It works perfectly, but this formula calculates the progressive of all the years stored. I would like to...
  2. C

    Mde

    Hello I am using Access 2003 and I split the database into FE and BE. I disabled the shift key and added a hidden form to force to close the database with a button. I tried to create an MDE file from FE, but it is not possible. I tried to save the database with another name and tells me I can...
  3. C

    VBA and disable alt + F11

    Hello, I would like to know how to disable the alt + F11 by vba code. I use access 2003. Thanks Sergio
  4. C

    SQL and VBA

    I’m working with access 2003 and I have a command button that runs a query called "Test" and opens it as a Pivot (graphic): Private Sub Comando196_Click () On Error GoTo Err_Comando196_Click Dim stDocName As String stDocName = "Test" DoCmd.OpenQuery stDocName, acViewPivotChart, acEdit...
  5. C

    Query subordinate

    Good morning everyone. Working with access 2003 and I have a problem with subordinate queries. Using a command button to open a report that displays only the dates of a particular product that has no orders. The structure has two tables. The first table (called: 2011) with fields (Prodotto) and...
Back
Top Bottom