Recent content by DenisB

Thanks Dale, an easy and elegant solution. Best regards, Denis.

I know, I know... but I found the trick here...

If you are using Excel 2002, try this: Go in design mode in the sheet, right click the button, "Format control", "Properties", select "Move and size with cells". Your buttons should stay in place after printing or previewing. Don't ask me why.

Is it possible to saveas a workbook or a worsheet, discarding the macros and the controls. The application generates invoices, and I would like only those to be saved, without command buttons and code.

Is it possible to saveas a workbook (or a worksheet), without saving the code and the controls?

Every time I press a button, the code attached to the command halts with the error message : 'Error accessing file. Network connection may have been lost'. Impossible to edit the code, same type of message. I had the same problem earlier, but I do not remember how I cure it. Any clue welcome.

Trying desperatly to open a form with an SQL statement using 'Between #Today# And #DateField#' If I use the format DD/MM/YY for the dates, the result is erratic, not all the matching records in the underlying table are found. When I reformat both #Today# and the field (with the format property...