Search results

@sonic8 , cool. I thought it had to be simple but could not find it. Thanks. Will let you know how It goes.

Hi, I'm using the below code to open outlook from a command button on a popup form. All works well but outlook always opens minimized. I have another routine that uses the sendobject method (for different reason) and it works well. So what I do is check whether outlook is installed, if so use...

@isladogs, in the process of working on my project i generated several 'real' errors that were trapped, captured & reported correctly. Never have i been so happy to generate an error!. Incidentally, i just implemented your 'fhandlefile' module on a double click of a browse to control. Works...

@arnelgp , today I added your design to my project. I eagerly await an error!!

Thanks, It's getting kind of large. I'll see what I can do.

@arnelgp , I had a further look & like your idea. Yes, I will add to my project so that I can run an error report from within Access too. Thanks

@arnelgp , Thanks but I like the ability of being able to review the log file from outside access using notepad. Of course, one could also import into excel if they required sorting etc or attach it to an email. I hope that users of my application do not generate errors at all (if I've done my...

@arnelgp , I don't see how as the intent of the report is an "inspection" where the main report provides the date/location etc of the inspection, then the sub report is where the user has input inspection 'section' notes & the sub-sub report is optional photographs of varying quantity. I'm open...

@arnelgp , I already have the code i originally posted up & running. I posted the code as I thought it might be of interest as an alternate to capturing errors within access as a record in a table. Of course there are benefits of both techniques. I make no claim to the development of the code...

@arnelgp , didn't work when i tried it but let me explain. I have a report. In the body of the report i have a subreport (1 to many). Inside the body of the subreport I have another report (1 to many), which is the attachment control to display pictures. As i have it, each attachment is...

@theDBguy , refer page 1024. Written by Michael Alexander & Dick Kusleika. Wiley publication.

@arnelgp , will try. Seems so simple. Thanks.

I may have added this thread to the wrong forum. I thought the concept was clever & intended to share with others. Should it be moved to the 'Code Repository' if worthy? Please modify as you like if it has merit. I like the concept of being able to preview the error log from outside access...

Hi, I have a report that has a 1:many relationship with image paths as a sub form. I have an image control on the many form that references the appropriate path. All works good. but as expected, prints each image below each other. I'd really like to print 2 images across the page then start...

@ebs17 , you could not have said it better. A worthy exercise to prove the point. Thanks.

All, I usually use a 1:many with a 'notes' table to allow many notes, dates, originators that kind of stuff to be retained. Looks like the column history feature is not much of a feature.

Thanks everyone. I once before dabbled with the 'column history' feature. I just liked the idea of parsing a formatted 3 column list box to display column history, thus this thread. I think, in real terms there is not a lot of advantage in using the column history technique. Colins treatise on...

@June7, thanks. Yes the orange highlight didn't work but you saw the offending line of code. Will give it a go & let you know. Thanks.

Hi, I'm considering using field column History for capturing changes to a record 'Notes' on form 'frmPersons'. The record source is 'tblPersons'. I found this code by Googling and like the fact that it generates the history to a listbox. Code ceases where I attempt to parse datDate about 2/3...

Pat, thanks for sharing. Will definitely have a look at these. Thanks