Search results

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

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

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

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

I was asked to create a report with lines between records; that's easy, as long as there are records to print! I mean, they'd like to have a report with a grid all over the page, regardless the number of records appearing. (XL-like) Can you help me? Thanks, Guldo

I'm running Access2k. I have a problem: I'd need to insert, into an already existing report, the result of a query. I'd like to get it horizontal, too. If I put it in the page header, it shows just the first record; in the main part of the report, instead, the whole result of the query is...