Recent content by m0use

Hi there, I have searched on multiple forums and found it is not as easy as you expect it would be. I tried making this work with forms and subforms in the 'normal' way, but this does not allow me to make a 'sort of' freezepane effect as is possible in Excel. Attached is an example that i've...

I hope you will find this information usefull. I use Outlook to receive reports and then automatically open the right access-database (with shell and command parameters) to process them. In my search for a way to stop my Outlook-code with processing untill the access-database has closed, and...

It looks like a Bound-Column thingie. Try looking at the "Bound Column" at the List-Box properties on the form. This should be bound to the column in which you have the text you want. If this is not possible you can always query for the text. m0use

Re: outputto challenge closed Right on Gemma!!! Great, this works. Usually i just overwrite the snapshot but now i kill it and then do as you suggested with the while-loop. Still strange that I have to do it this way, but it does not seem to slow the processing down. Hardly notice it. Thank...

Tinh, Thanks for your suggestion, but this also does not seem to work. Still searching...

John, Thank you for your suggestions and support, it is much appreciated. I will keep on searching for a neat solution. As soon as I find it I will update this post for others who experience the same. So, the challenge is still open... and I still don't get it... Thx, m0use Edit: Tried...

Putting the code into a module is how this started. (I usually put all my custom code in modules.) So I'm sorry to say that is not working either. FYI, i'm using Access 2003 on WinXP Pro. With the workaround I mentioned it runs ok for now, but I really do not like this way of programming...

My code is in the form_open event. But that is not the problem because it works when i manually open the form. Strange... As a workaround I now made a new form in which i put the second outputto and i open it as hidden after the first outputto. This seems to work, but it not the way it should...

Thank you for your reply. There is always data in the reports. And the funny thing is that when I open the dbase with "shift" and I open the form in which i have the outputto code it will also work. So, it does work when the i put it in a button script and it does work when i "shift"-open the...

Hello, In VBA I'm trying to export 2 reports of my dbase as snapshots to a folder where users have access to. The code I use: DoCmd.OutputTo acOutputReport, "whatever", acFormatSNP, "T:\whatever.snp" DoCmd.OutputTo acOutputReport, "whatever_1", acFormatSNP, "T:\whatever_1.snp" The...

Case solved: I've been overlooking .SourceTableName = "Sheet1$" or whatever you want it to be... The following is the case: At our office we have users which use English and Dutch systems and office software. They pull data out of another system and export it as an Excel-sheet which gets...

Have you tried: =IIf([Reports]![NewStockMonthTotal].[HasData]=False,1,0)...? This seems to work for me! m0use

Jv2 try the following: =IIf([Reports].[....].[HasData] etc... Greetz, m0use

Hello readers, How it (my dbase) works: I have build a routine that automatically updates the starting database when another database with a name starting with: "UpdateV" + (text-field value) is found in the same folder. (Or you can browse to it through a interface...) It then checks a table...

Thank you Chris, this solves my problem.