Recent content by brokkel

  1. B

    Visibility problem in access form

    nevermind, I changed it to : DoCmd.Close acForm, "totaluserreqpanel" DoCmd.Close acForm, "VM TOOL" DoCmd.OpenForm "chatpanel" and now it works perfectly ... carry on :-)
  2. B

    Visibility problem in access form

    I think you are on to something: Private Sub chat1_Click() Public_autonumber = Me.autonumber1.Value Public_requeststring = Me.comment1.caption DoCmd.OpenForm "chatpanel" DoCmd.Close acForm, "totaluserreqpanel" DoCmd.Close acForm, "VM TOOL" so the form I'm closing is Totaluserreqpanel, the...
  3. B

    Visibility problem in access form

    Hi all, I have a visibility problem in one of my access forms. I go from form A to form B, but, for some reason part of form A remains visible on form B ... Any idea how I can get rid of this? please check the screenshots
  4. B

    Speeding up this Loop?

    I think I should know a good way of speeding up, let me test something
  5. B

    Create a Google Calendar event with VBA

    anyone can add anything to this? Would be great :)
  6. B

    Create a Google Calendar event with VBA

    One thing I found already is how to log on to the calendar: Dim HTMLDoc As HTMLDocument Dim oBrowser As InternetExplorer Dim oHTML_Element As IHTMLElement Dim sURL As String On Error GoTo Err_Clear sURL = "url" Set oBrowser = New InternetExplorer oBrowser.Silent = True oBrowser.timeout = 60...
  7. B

    Create a Google Calendar event with VBA

    I have searched the Internet but have not found anything worthwile. Has anyone any idea whether this can be achieved? Many thanks!
  8. B

    Make a "reverse" selection in a Microsoft Office Spreadsheet 10.0

    Hi there, I have a spreadsheet control in a form that I use to show the daily planning. Now I want that users are able to select a range in this spreadsheet and then hit a button. The VBA code should then provide me the selected range. Do you believe this is possible? If yes, please...
  9. B

    Defining "Yesterday"

    Ok I'm a total N00b in this and I know half of the board has studied Informatics, so I'm hoping someone can help me I'm trying to create an Microsoft Access (2003) query that will provide me everytime results from Yesterday. But I'm having some difficulties defining "yesterday". I have...
Top Bottom