Search results

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

I have a query with, say, field1, field2, field3 and field4. [field3] is [field1]*[field2]. I have a report based on that query. In the page-footer I put the sum of field2, subject to [field4]=0.1, for example, updated by a macro everytime the report is opened (print or printpreview). It's fine...

I'm afraid I didn't explain that well. I have a query that displays from 2 tables (join); fields such as: "name", "ps1", "ps2", "number". The very last field has just 2 possible values, 1 and 2, chosen when the query is opened. I already have that. I now would like to build a report with "name"...

Access2k How does the ControlSource really work? The guide isn't that comprehensive... I have a report based on a query. In that query there are (also) one field 'code' (number) and, say, three fields 'fieldX' where X is a number in 'code'. I'd like the report (when opened) to display, in a...

Access2k How does the ControlSource really work? The guide isn't that comprehensive... I have a report based on a query. In that query there are (also) one field 'code' (number) and, say, three fields 'fieldX' where X is a number in 'code'. I'd like the report (when opened) to display, in a...

Thank you very much! I'm running 2000. Could you send me that file somehow compressed? Thanks a lot, Guldo (guldo@hotmail.com)