Search results

Sorry, I didn't see you last post... :o

arnelgp, I realy appreciate what you do, fantastic!!! With you last code you disable all the shortcutmenu's for all users in forms and reports. But now the users can not print any report because I disabled the ribbon… :rolleyes: That's why your code for small shortcutmenu's is so perfect...

arnelgp, For the forms the users don't need a shortcutmenu. So it is not necessary to create a menu specially for forms. I disabled the standard shortcutmenu for users and enabled it for admins. My question is can I activate the print_menu from #3 for users and the print_menu from #12 for...

arnelgp, That's indead a little diffirent :rolleyes: Thank you so much. :):) In my forms I enable or disable the shortcutmenu depending on user or admin as follow : Dim Dienstlevel As Integer Dienstlevel = DLookup("DienstID", "qryUsersDiensten", "UserLogin = '" &...

Good morning arnelgp, I'm experimenting a little and I added a 3th command in the short cut menu. Private Sub subCreateReportShortcut() 'arnelgp Const SHORTCUT_NAME As String = "menu_print" Dim cbar As CommandBar Dim bt As CommandBarButton On Error Resume Next...

In my reports the schortcutmenu are not disabled yet, and now I don't have to I think. If I don't disable them I don't have to change the code right?

Yep, I forgot the Microsoft Office XX.X Object Library :banghead: It's working…. :) Thanks a lot See you next time. Greetz Pascal :cool:

wait… I know what I forgot...

arnelgp, I'm having a compile error : a user-defined data type is not defined :rolleyes:

arnelgp, In all my forms I disabled the quickmenu (right mouse button)so the user can not go to the design mode of the form. As ADMIN they are enabled :p And also they don't need a Quick menu, everything runs with buttons... I was planning to do the same for my reports, that's why I asked the...

I know I can add a button in reportview, but I want to know if it's possible to run code when closing report in printpreview. Thanks Greetz Pascal :cool:

Dear specialists, I want to give the user the posibility to print the repport or not when they close the repport with this code : Private Sub Report_Close() Dim Response As Integer Response = MsgBox("Printen?", vbYesNo + vbQuestion, "Report Information") If Response = vbYes Then DoCmd.PrintOut...

Arnegp, That's what I was looking for. :):) I don't know why you want to compere the DateLastModified with the DateCreated. In my experience I know for shure that this date never changes. Once the pdf is created that date never change. We can not modifi or edit a pdf at work... So I left...

arnelgp, No they are not, you can see the JPG I send. :) The yellow dates are the modified dates, at the end you will see the creation date and they are all the same because of the copy yesterday. I would like the code compere the modified date with today's date and delete all of them who are...

arnelgp, Thanks for reply, I think your code is working with the creation date of the pdf. Because I copied the complete map to my working map at home, all these dates are the same. The code should run with the "modified at" date. See picture (=Dutch) Thanks Greetz Pascal :cool:

Hi everybody, I like to clean up a map where I store my pdf's (copies of reports) I would like to delete all the pdf's who are older than 6 months from "today's date" using the modified date and not the creation date. The web didn't bring me any solution so far... my pdf's are stored in ...

CJ, Thanks for reply :) Where do I place the "if dcount(….. After the me.timerinterval = 0 in the timer event? Followed withe the rest of my code? Thanks Greetz Pascal:cool:

DBGuy The user can already use the enter tap or the OK button and there is no problem to use it like this. :) Of course you need to confirm your Password one way or the other otherwise access concider the field empty. I'm experimenting and I was wondering if it was possible. I'm learning...

CJ London, Pbaldy, Thanks for reply.:) Pressing Tab or enter is just that what I want to prevent. I placed my "OK" code in the timer event. interval is 10000 Because I have a few securities bild in like login or password can not be empty, password change recuired after first login,... after...

Hi everybody, I have a database with login form. After password input I click the OK button and de DB starts running. No problem so far. What I like to do is run my "OK" code after input my password without clicking the ok button. (e.g. like the windows pincode to login) Is there a way that...