Recent content by guldo76

I'm sorry you had problems. I use Access2k, and converted the db from 2k into 97. bye, Guldo

Well, I think you can: 1. build a grouped report, and perform group totals (but maybe it would overshoot your goal) 2. build a query with totals, and use it as source for the report 3. write the sql statement of the query directly as source for the report, so that you don't have to create any...

Well, I think you've found out by now, anyway if you have not, or anyone be interested... In the properties of the sub-report look for the "can be expanded" one, (or suchlike, i'm italian, you know...) and just set it to 'no'. bye, Guldo

See if you can read these. Bye, Guldo

I think I'better know in more detail what does your db look like; anyway, this is a try. Regards, Guldo76

Oh, God, I DO NEED help! I use a XL-linked table (prodotti) to get records and append them to another local table. But now, when my code has to run UPDATE Prodotti SET peso=null it gives me a 3274 error: "External table is not in the expected format". After this, the table can no longer be...

Sorry... It was just my fault, sorry. Anyway this file should work. Guldo

Thanks, Alexandre! It worked. I just had to put "#" in the sql. Moreover, declaring the function as 'date' resulted in an awkward "31/12/1899"!! Thank you, Guldo

Sorry for bothering for a likely-easy thing, but I can't manage properly with dates. I have a table I fill in by means of vbcode, and all's fine but the date. I have a date, say, from a txtbox. In vb I see it's like "18/07/02" for 18 july 2002. But as the sql append it to the table, it's...

I had a problem these days, about footers and empty grid lines. I wished to get a group footer just at the bottom of a page (and not where the records end); moreover, I was asked to perform a 'empty grid' to reach the end of each page. WELL I DID IT !!! And because this forum has been, still is...

FIXED!!! The line not working was: docmd.gotorecord acdataform, "NBE", acfirst because "NBE" was supposed to be missing or not opened. I tried and open the subform as 'standalone', while the big form was still there, and the VBcode recognized the 'standalone' as the desired one. Anyway, browsing...

Thanks a lot for your quick reply!!! Forgive me, but what's "RST"? I'm italian! Thank you very much!!! Guldo

Is it possible to have the report-footer displaied at the bottom of the last page, regardless of how many records are in it? A page footer would display in each and every page. Or maybe there's a way to make the page-footer appear just at the end of the report, or at the end of each group...

Thanks, BLeslie88. But I did code my controls by myself. I coded my own form, and it worked great. Then I inserted it in another form, and it no longer worked. The problem can be simplyfied as follows: Table1: products records (name, price) Form1 (works): find a specific product, modify its...

I have a subform with a commandbutton and single records in it. As the button is clicked, I'd like to perform the "GoToRecord" action, but it doesn't work, claiming the form is not opened! Why??? Any hint would be greatly appreciated. In fact, as the button is clicked, I want to append the...