Search results

  1. D

    Question Making changes to MsysResource table.

    Yeh I know. I would love to know however why the form open event gets messed up anyway. As to the MSysResource table I will give up on this very easily. I am for example just testing doing all the changes in the forms open event.
  2. D

    Question Making changes to MsysResource table.

    I have noticed that when I add / update (not sure exactly what triggers this) an image to the Access Image Gallery and then put it on a form then upon the next time the form is opened I get I then worked out if I open the form > open the VBE > Debug > Compile, then Compact and Repair twice the...
  3. D

    Creating an appointment in outlook shared calendar using an access form

    If the calendar is actually shared with Outlook then you need to get the right calendar first. See the link I posted as to how to do that. Also can you please use the CODE button for your code so that it is easier to read.
  4. D

    Creating an appointment in outlook shared calendar using an access form

    Ok great. That code is a copy of the code about 4 pages back, so now read my comments on that code to improve it. Next is your sharepoint calendar shared with Outlook. If yes you will need to get that calendar, if no I think you can only access it view http calls...
  5. D

    Creating an appointment in outlook shared calendar using an access form

    I dont know sharepoint at all, but show your code and lets see if we can work it out.
  6. D

    Access 2010 - Image Gallery background color

    I wish I could use other images for development but that would take a whole lot more time. Looks like I will have to be extra good with my naming. Thank you.
  7. D

    Access 2010 - Image Gallery background color

    I am currently adding a lot of images to the gallery for re-use. Unfortunately the images are white and transparent. This means they do not show in the Access Ribbon gallery control unless you put your mouse over it. I have added two images of this. I tried to change Access' color scheme but...
  8. D

    How to reuse code?

    Put "Public" in front of Function. Also please read up on this topic which will help you understand why it failed in the first place http://www.cpearson.com/excel/scope.aspx But if you put this in a module then I will give you a hint, you cannot use Me! which is also an issue with scope. put a...
  9. D

    How to reuse code?

    If I understand your question then the answer is this; Private Sub Comando285_Click() Call EmiteRecibo End SubThis assumes that for example you have done some error checking, eg. Me!RecTId & Me!TbEntAbv actually contain values.
  10. D

    Hiding objects

    Here is what I use to hide it all. Maybe a combination of some of these helps you or at least you know where to find the commands that do what you want. DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar", acToolbarNo DoCmd.RunCommand acCmdWindowHide...
  11. D

    Question Graph Update Event - dispatches asynchronous calls, Really?

    Laziness (faule Hund ;) ) I suppose I just wanted what worked in 2003/07 to work in 2010 and I don't see any reason why it should not. I will have to see where the code can be put, but I have a feeling that there is a reason why it is set when the chart updates.
  12. D

    refresh Outlook Inbox via vba

    I know zero about email servers. Please keep that in mind. In my opinion Outlook is just a client to display your emails. As such it can hook up with many different email sources (Hotmail / iCloud / MSExcahnge etc etc). I have noticed especially with the free email providers that they do not...
  13. D

    Question Graph Update Event - dispatches asynchronous calls, Really?

    Sure can. I hope this works or in this case does not work. Just start the form. I did not check if the code in the update event would actually work with the example. But in any case the automation error is thrown.
  14. D

    refresh Outlook Inbox via vba

    Whenever I get the MAPI namespace I always call the logon method. oNS.Logon "", "", False, True This will of course depend on whether you are using GetObject or CreateObject. I have never used the SyncObjects object but I just did a little reading and am not sure it is necessary for you to...
  15. D

    Web Browser object freezes application

    Wow! two people with the same issue and almost the same text https://www.experts-exchange.com/questions/29000323/Web-Browser-embedded-in-MS-Access-form-hangs-after-logging-into-website.html?notificationFollowed=183750397#a41996626
  16. D

    Question Graph Update Event - dispatches asynchronous calls, Really?

    It has been a while for this forum and for MSAccess but I'm back at it updating from Win7 Office 2007 to Win10 Office 2010. I have a few Microsoft Graph Chart object in a form and I am using the onUpdated event of the chart object. That code looks like this; With Me.chart_status.Axes(2)...
  17. D

    Question Need to get Mailbox ID from outlook for an Email

    I think what you are after is the Stores / Store object which is available from Outlook 2007 onwards. https://msdn.microsoft.com/en-us/library/office/ff867405(v=office.14).aspx
  18. D

    Create Outlook meeting from Access

    Do you mean by this where for example a secretary is a delegate of someone else Outlook calendar and the secretary can make appointments in the name of this person on their behalf?
  19. D

    Access automating Word - Difference between Selection / ActiveDocument and GoTo

    Set up is Windows 7 / Office 2007. Access code is automating Word. The following code (which deletes page 2) works on most PCs With objWord.ActiveDocument Set rng = .GoTo(What:=wdGoToPage, name:="2") Set rng = rng.GoTo(What:=wdGoToBookmark, name:="\page") rng.Delete...
  20. D

    Image in output to Word Document

    You will find that vbaInet is right. I have just done a quick (really quick) google on how to get an image in Access into the clipboard to then use in word as I suggested. I was surprised at the number of people with a similar question. If you have the image as OLE then you can set focus and...
Top Bottom