Search results

Thanks to you all for your replies. True, Jiri, I am not writing into them, so your idea works fine. With pwbrown's answer I also figured out how to do it. Setting all objects to Nothing seems to work just fine. Set objSheet = Nothing objBook.Close Set objBook = Nothing...

Thanks for the quick reply. As I wrote I have variables I open the workbook when I ask the users to choose the needed worksheet. Public Function readxlsSheets(fn) As String Dim xlsFile As String Dim reStr As String xlsFile = fn reStr = "" ' find an open Excel...

Hi there .. any help highly appreciated. Maybe I am just too blind to see it and it is very simple - I actually think it should be. I have written an import program that opens an excel file, displays the sheets and lets the user choose one. The Excel sheet is quite complex so I had to write my...

So, a week has passed, I have not figured out how to circumpass access' restriction on the number of labels. What did work, though, was this: - I created a table into which I copied all my results, then added fields for all descriptive information - I filled these fields with the appropriate...

OK, sorry the answer comes a bit late, different things to do as well.. I concatenated two labels together and, luckily, now the whole report gets written. But of course the issue remains and I am not very happy with the solution. It works now but it seems risky So this is my table structure...

Thanks a lot for the answers. I have not figured out how to do it yet. The idea with concatenating the output came to me, too, but then the table structure would be lost. Or - this question shows my lack of knowledge - is there a way to add tabs that would allow the data to look tabular...

Thank you, but what I mean is something else. When I iterate through the recordset, the system tells me that there are too many controls on the report. The problem is that I have 9 columns and the number of rows varies with a maximum of 75. And that is apparently too much and I wonder how to...

I am running some complex scripts that calculate and filter data into several tables. To finish the task, I want to create reports from these tables. The nr varies depending on the user input, so there can be anything from 1 to 1500 reports. The header is put together from metadata in one...

I am working for the birdwatcher community in Germany. We are handling our databases mostly using Access and I have taken the task to learn how to program in it, too. And I am facing difficulties again and again which is why I am here. Searching the net for solutions I very often came accross...