Recent content by Libre

Before I start to watch these - Do you think the accdb would run on their system? Ok so they get the full blown version. Otherwise I wasted 6 months of development and I can't start all over with it. I just can't.

I have 1 PC. It's a 64 bit PC. I have no idea why my Access is 32 bit. So I don't have a computer available with that.

Hello everyone and TIA. I'm an independent developer (retired). For 6 months, I've been developing a very extensive Access db for a client. I've worked hard all these months and I finally sent them the first release yesterday - an accde compiled Access database. They can't run it. They tell me...

I get it. Thanks all for the helpful commentary.

Hearing loud and clear isn't the same thing as understanding, apparently. I've tried to be as polite and respectful as possible, faced with an attitude of, basically, I'm right because I say so. You don't support your position with examples of when or why you would choose one over the other, or...

That's fair because you didn't understand what I was telling you either. MY point was that I'll use any tool that's available, to reach my goal. That is regardless of whether it is orthodox or not - doesn't matter to me. I'm trying to accomplish something here - get some questions answered - not...

Based on the almost infinite nature of what COULD happen, it doesn't seem reasonable to handle every possible eventuality. What I've got now, is an external error log, displaying the timestamp, the error description, the error number, and the line it occurred on (need line numbers for that one -...

I've watched the link- or much of it carefully. I've vastly improved my error handling - now writing to an external error log for example. Also having a global handler rather than millions of individual ones. I'm super glad I looked into this before pasting my former code into every procedure!

I'm basically trying to keep the debug option from coming up. No user wants to see that. I don't know if there's any way to guarantee no errors are going to occur.

Another question about deployment: do you put an error handler into EACH AND EVERY procedure and button click? Everything regardless? Here's the one I use - look ok? Private Sub cmdClose_Click() On Error GoTo Err_cmdClose 'code 'code 'code Exit_cmdClose: Exit Sub Err_cmdClose...

"They are used for very different things". In my use of them, they are similar. In this precise case I'm putting the lines of an invoice into the detail section. These lines show up clearly in a list box, complete with column headings, and a clickable value - the one bound to the listbox. I was...

I don't know what that graphic demonstrates, but I meant that a list box has only one bound column so when you click or doubleclick on a line in a list box you're only addressing that one column, while with a subform you can click on (directly address) any column so it's more useful in that...

I haven't done much with reports. I'm just trying to get the output to be correct and formatted properly. I usually prefer list boxes to sub forms (not sure about sub reports) because they are much tidier with less overhead, take up less space etc, but you can only address one field in a list...

Excellent! Works perfectly. At first I was confused...remove the line details...eh? But of course because they are covered by the list box source, independent of the report source. And it works so thank you very much. Saved me much anxiety - couldn't find a thing about it by googling.

I have the data formatted the way I want. But It goes to 4 pages although all the data is on Page 1 with the following pages repeating all or part of Page 1. I'm using a List Box to display the lines of an invoice. The header information (Invoice Number, Customer name etc) is from another table...