Recent content by LGordon

Since the Navigation Panel and Ribbon are closed programmatically and the F11 key has an AutoKeys macro, there is not much that can be done. It was more of an exercise to detect the keystroke in case it might be useful in another context. Excel has a BeforeSave event. I thought there might be...

In case I decide that I want to prevent the save. The best way, I suppose is to create a .accde version, but this is a stopgap process. I was hoping that there was an event with a cancel parameter or a macro that is similar to the autoexec.

Is it possible to detect if a user saves the database by typing ctl S?

It would appear that you can only print the width of the paper you are using. If your report is wider, then it continues on a second page. Could some of the more experienced Access developers confirm this statement? Also, is there a way to replicate the Excel format to Fit to Page setting.

You need to sum the TotParts by Press. Go to Create query. Add the table. Once the table is shown on the top, drag down the fields Press and TotParts. On the row for Criteria, located on the left, under TotParts, click the summation symbol. That will add a new row called Total and you will...

Does anyone know how to add or edit the pages that Access 2010 writes when you choose to save a report as HTML? It gives hyperlinks to First, Next, Previous and Last. I want to give the user the option to select a page.

Does anyone know how to reset the table validation using VBA code?

Does anyone know how to set a table level validation rule with VBA?

My database should be read-only except for a few people. My idea is to check the user as the database opens if they are not in the table, then change the validation rule for the table to False. I have the following code. Note that db is defined as a dao.database at the module level. The code...