Recent content by cimabue

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

Thanks, easy way is ... the best Sergio

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

Thanks Fuse 3k Sergio

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

Ops... my mistake, Your suggestion is right. Thanks. Sergio

Excuse for my poor english.. I tried your suggestion but I cannot open form and results as.... ViewPivotChart. I used your suggestion in all my reports and I insert SQL in record origin so to delete every queries. Now I have one table, only one query and many reports. I have to delete the...

I tried and I have This Error: A RunSQL action requires an argument consisting of an SQL statement... If I remember ... runsql is not correct with SELECT ...but only with UPDATE or INSERT

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

Thanks, your solution is good Sergio

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