Reflection for Unix and Digital - from an Access form jonefer 08.11.2005 06:41:04 (Please point me to the correct group if this isn't it) Does anyone know how to open a Reflection Unix and Digital Connection from an Access form? I've created some powerful screen scraping macros in reflection that write data to an Access Database. Reflection comes with the following generic example... but have no idea how to use it and would like to have ACCESS actually open up reflection, login and continue running macros that I have created in reflection (if it can run the macros, I'd just as soon move the modules to Access) Private Sub UserForm_Initialize() Set RUD = R2winCtrl1.GetActiveSession With RUD 'Configure a connection to the demo UNIX host .ConnectionType = "DEMONSTRATION" .ConnectionSettings = "Host ""UNIX""" 'Define an event to take place when a connection is made .OnEvent rcNextEvent, _ rcEvConnected, _ rcVBCommand, _ "RaiseControlEvent 1, ""Connected!"" ", _ rcEnable , _ rcEventReenable End With End Sub Thank you

Re: Reflection for Unix and Digital - from an Access form "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 08.11.2005 22:17:06 Looks as though you need to set a reference to some Reflection-supplied DLL, and then you should be able to use the code as is. Unfortunately, I don't know what the DLL is! Does the documentation talk about setting references? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "jonefer" <jonefer[ at ]discussions.microsoft.com> wrote in message news:E99EBF86-81F6-4D22-B734-BD268B423AEC[ at ]microsoft.com... [Quoted Text] > (Please point me to the correct group if this isn't it) > Does anyone know how to open a Reflection Unix and Digital Connection from > an Access form? > > I've created some powerful screen scraping macros in reflection that write > data to an Access Database. > > Reflection comes with the following generic example... > but have no idea how to use it and would like to have ACCESS actually open > up reflection, login and continue running macros that I have created in > reflection > (if it can run the macros, I'd just as soon move the modules to Access) > > Private Sub UserForm_Initialize() > Set RUD = R2winCtrl1.GetActiveSession > With RUD > 'Configure a connection to the demo UNIX host > .ConnectionType = "DEMONSTRATION" > .ConnectionSettings = "Host ""UNIX""" > > > 'Define an event to take place when a connection is made > .OnEvent rcNextEvent, _ > rcEvConnected, _ > rcVBCommand, _ > "RaiseControlEvent 1, ""Connected!"" ", _ > > rcEnable , _ > rcEventReenable > > End With > End Sub > > > Thank you

Re: Reflection for Unix and Digital - from an Access form jonefer 09.11.2005 08:39:10 Yes, and I did add the Reference "Reflection for Unix and Digital" and the code, if I transfer it to an Access Module, actually has no errors in it. My concern is - how will the reflection sessions know that they are being talked to from Access unless access can open them up and establish some sort of name link. Thank you for taking a stab - I hope someone else does. "Douglas J. Steele" wrote: [Quoted Text] > Looks as though you need to set a reference to some Reflection-supplied DLL, > and then you should be able to use the code as is. Unfortunately, I don't > know what the DLL is! Does the documentation talk about setting references? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > > "jonefer" <jonefer[ at ]discussions.microsoft.com> wrote in message > news:E99EBF86-81F6-4D22-B734-BD268B423AEC[ at ]microsoft.com... > > (Please point me to the correct group if this isn't it) > > Does anyone know how to open a Reflection Unix and Digital Connection from > > an Access form? > > > > I've created some powerful screen scraping macros in reflection that write > > data to an Access Database. > > > > Reflection comes with the following generic example... > > but have no idea how to use it and would like to have ACCESS actually open > > up reflection, login and continue running macros that I have created in > > reflection > > (if it can run the macros, I'd just as soon move the modules to Access) > > > > Private Sub UserForm_Initialize() > > Set RUD = R2winCtrl1.GetActiveSession > > With RUD > > 'Configure a connection to the demo UNIX host > > .ConnectionType = "DEMONSTRATION" > > .ConnectionSettings = "Host ""UNIX""" > > > > > > 'Define an event to take place when a connection is made > > .OnEvent rcNextEvent, _ > > rcEvConnected, _ > > rcVBCommand, _ > > "RaiseControlEvent 1, ""Connected!"" ", _ > > > > rcEnable , _ > > rcEventReenable > > > > End With > > End Sub > > > > > > Thank you > > >

Re: Reflection for Unix and Digital - from an Access form "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 09.11.2005 23:02:51 Presumably RUD is declared at the top of the form's class module, so that you can use it as long as the form is open. RUD probably has methods that are how you pass information to the session, and functions that let you get values back from the session. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "jonefer" <jonefer[ at ]discussions.microsoft.com> wrote in message news:3DC8786B-0636-4978-BC1B-C2D5DA84AA06[ at ]microsoft.com... [Quoted Text] > Yes, and I did add the Reference "Reflection for Unix and Digital" and the > code, if I transfer it to an Access Module, actually has no errors in it. > > My concern is - how will the reflection sessions know that they are being > talked to from Access unless access can open them up and establish some > sort > of name link. > > Thank you for taking a stab - I hope someone else does. > > "Douglas J. Steele" wrote: > >> Looks as though you need to set a reference to some Reflection-supplied >> DLL, >> and then you should be able to use the code as is. Unfortunately, I don't >> know what the DLL is! Does the documentation talk about setting >> references? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> >> "jonefer" <jonefer[ at ]discussions.microsoft.com> wrote in message >> news:E99EBF86-81F6-4D22-B734-BD268B423AEC[ at ]microsoft.com... >> > (Please point me to the correct group if this isn't it) >> > Does anyone know how to open a Reflection Unix and Digital Connection >> > from >> > an Access form? >> > >> > I've created some powerful screen scraping macros in reflection that >> > write >> > data to an Access Database. >> > >> > Reflection comes with the following generic example... >> > but have no idea how to use it and would like to have ACCESS actually >> > open >> > up reflection, login and continue running macros that I have created in >> > reflection >> > (if it can run the macros, I'd just as soon move the modules to Access) >> > >> > Private Sub UserForm_Initialize() >> > Set RUD = R2winCtrl1.GetActiveSession >> > With RUD >> > 'Configure a connection to the demo UNIX host >> > .ConnectionType = "DEMONSTRATION" >> > .ConnectionSettings = "Host ""UNIX""" >> > >> > >> > 'Define an event to take place when a connection is made >> > .OnEvent rcNextEvent, _ >> > rcEvConnected, _ >> > rcVBCommand, _ >> > "RaiseControlEvent 1, ""Connected!"" ", _ >> > >> > rcEnable , _ >> > rcEventReenable >> > >> > End With >> > End Sub >> > >> > >> > Thank you >> >> >>