Search results

I am trying to use Bob Larson’s excellent Export A Form's Recordset To Excel code. It works of course, but I am using a datasheet view in my subform and I am hiding columns based on the users selection. I only want to export the visible recordset from the subform. There are over fifty...

Do you have SharePoint? Then you could create a SharePoint list and link you database to that list.

I have been told that my old Browse [Find a directory or file] sample works all versions of Windows and Access.

Well this code does allow me to externally call it and only print page 1 of the report and the code within the report is working so the user can key which location they want to report filtered on. But I wish I could put the print code within the report so that I could use an IF to determine if...

No I cannot. The report is being either emailed or saved to the network. All the user does is click a button and choose the location number to filter the report on. I am trying to avoid making two copies of the report, one to print both pages and the other to only print page 1.

When using the below code I am gettting the error "This action cannot be carried out while processing a form or report event". DoCmd.PrintOut acPages, 1, 1 What event of the report should this code be in?

Is it possible to print only page one of a two page report? I have a report that I want both pages to be printed for one instance when I send the report via DoCmd.sendobject acReport or open it via DoCmd.OpenReport but for another instance I only want page one to be printed. I have searched...

That is because it still has the focus. You need to move the focus to another object but you will also have to use the On Lost Focus event to reset the properties of the button you modified.

The runtime version of access is a stripped down version that does not offer any of the usual menu options. The developer has to build [VBA or macros] any functionality that they want the user to be able to perform within their custom access application...

Cannot imagine a reason to want to bring back the classic menus into Office 2007. IMO: Most developers remove the default menus/ribbon and built their own or only use VBA via command buttons to enable the users to perform the actions only the developer wants the user to be able to do within...

Put an on open password on the back end. Then relink all the tables from the front end to the back end. You will be asked for the password but it will be embedded with the table links and the users will not be able to see the password if they try to look inside the front end.

Interesting. MsgBox Format(Now, "mm\/dd\/yyyy") Thanks Bob!

That will only work if the backend has a form that is opened when the backend is opened. Maybe an AutoExec macro to call a custom function with the above code from DCrake would be best for the backend to keep the users from opening the backend.

As the original poster has questioned, you can externally turn the AllowBypassKey property on or off. As this sample will do >>> ByPass Shift Key Utility for Access You have to be a member of UtterAccess to open/download the ByPass Shift Key Utility for Access file.

You need to ensure you have proper error trapping for all of your VBA routines, especially when using the runtime version of access. Then your users can provide you with the error number and message if they encounter a runtime error with your database. Private Sub Form_Open(cancel As Integer)...

Try importing all of the db objects from the bad database into a new database.

Check out my old A Better Mouse Trap? sample to see how I use a custom Save button.

This might show you how to fix your first question... http://www.btabdevelopment.com/ts/default.aspx?PageId=27

You need to store the value in a table if you want to retrieve it even after the database is closed.

Any reason you are not using all three fields (one on top of the other) in the report?