Opret link ud fra tabeldata - hvordan?

Denne kode burde kunne lægges på knappen:

    Dim IE As New InternetExplorer
    Dim URL As String
    URL = "http://www.domæne.dk/filnavn.asp?var1=" & Me!Fornavn & "&var2=" & Me!Efternavn
    IE.Navigate2 URL
    IE.Visible = True


husk dog lige en reference til Microsoft Internet Control (tools->References når du står i VBA)

Application.FollowHyperlink "http://www.domæne.dk/filnavn.asp?var1=" & Me!Fornavn & "&var2=" & Me!Efternavn

nå, ja! Den havde jeg helt glemt :o(

and I thought it was me who was getting old Thomas :o)

hows it going tipsen?

I haven't had time to check it out yet, but it's on my agenda tomorrow - will get back to you after that :-)

glad my agenda isnt so full :o)

It worked (almost) like a charm!

The only thing I'm having problems with is the "NewWindow" property which I don't understand!

NewWindow  Optional Boolean. A Boolean value where True (–1) opens the document in a new window and False (0) opens the document in the current window. The default is False.

- independent of this setting every time the script is run a new instance of IE is started - it's apparently not possible to recycle the first instance? (One would achieve this in HTML by naming the browserinstance!)

Does it perhaps mean that it's possible to embed IE in an Access form!?

Please enlighten me :-)

Cheers, Tommy

Lets say your browser is already displaying a page. If you use True then the new page you open should open in a new window allowing you to still see your frist page in the original window.

Og tak!

Even though I set NewWindow = false the url was still opened in a new window/instance!

It snot something I use very often, so I cant comment on that. Is it a problem that it does that?

It's not exactly a problem - more an annoyance - but if it could be remedied it would be nice :-)

FollowHyperLink er åbenbart temmelig fejlfyldt - det er håbløst at lave en HTTP request med POST - det er kun muligt med GET, hvilket er en voldsom begrænsning! Udfra de informationer jeg kan finde om emnet, skal man ud i en del arbejde for at omgå denne fejl - man kan ikke benytte FollowHyperLink metoden - som desuden er temmelig god til at crashe Access afhængig af de inputs den får... - jeg er mere og mere glad for at jeg normalt ikke bruger Microsoft programmer til seriøst arbejde...