Search results for query: *

I'm afraid you won't be able to drill down to that property with VBA or EXTRA's built in macro editor. I've wanted to check whether a field was read-only before and wasn't able to find any methods like this in the library. You can browse through the properties and methods that they've exposed...

Can anyone give me some pointers on how to use a linked server in a DTS Package? The only thing I can see to do is to connect to the SQL Server directly but scheduling this is giving me some problems due to an error I'm getting: Error string: Login failed for user '(null)'. Reason: Not...

I'm posting the pertinent code from my form. You'll need to create the following but change whatever you don't like to fit your needs: - form (frmMain) with a MenuStrip at the top and a StatusStrip as the bottom. The default size is 800x600. - panel (pnlEXTRA) with the BackColor set equal to...

I've been having intermittent issues with Outlook dropping some contacts I haven't emailed in a couple of days. Yet it retains some contacts I haven't emailed in months. I'm talking specifically about the drop-down list of contacts you see when typing in the "To:" field of a new email. I've...

You can also use the InputBox function as shown below Dim sDate as string sDate = InputBox("Enter the date you want:", "Any Caption", Format(Date, "mmddyyyy"))

Gotcha. I figured it would be something like that. I don't know that licenscing PCOMM is an option for me, but I've been playing around with a "no extra cost" solution that might do what I want, although not as slick as an emulator. I was able to create a .NET form with a transparent panel...

I started developing Extra! macros a few years ago and quickly moved into VBA to interact with Extra! sessions due to improved performance and functionality. I've now gotten into .NET and have begun development of better tools but don't love having to switch back and forth from the .NET app and...

Date is not a variable type in my version of EXTRA so you just declare the variable without a type. Option Explicit Sub Main() Dim exp 'variable to holds expiration date exp = #1/30/2008# If exp < Date Then 'check expiration date vs today's date msgbox "Expired"...

With EXTRA you have to declare explicitly declare additional subs at the start of your code. I fixed a couple of other errors too. Option Explicit Declare Sub Wait(Sess As Object) Sub Main Dim Sessions As Object Dim System As Object Dim Sess0 As Object Set System =...

You can use the Date() function: Sub DateAdd() Msgbox Date() Msgbox Format(Date() + 20, "MMMM DD, YYYY") End Sub Change the date format to suit your needs.

I just wish I had known about Sess.Activate a while back. When I tried to view the EXTRA library in the macro editor it would always crash on my old PC. It's (inconveniently) not listed in the help topics. I've hunted around in the object library in VBA but never saw this until now. You...

I discovered this a while back and the odd thing to me is that although it generates an error, it still displays the email. I just use On Error Resume Next and it works fine. I think there are two ways to do this. One is with carriage returns (Chr(13)) and the other is with <br> in HTML. I've...

Try the AppActivate function instead of Sess1.Activate. Whatever your session displays in the Title Bar is what you put in quotes. Mine works like this: AppActivate "SESSION1 - EXTRA! for NetWare"

This link will get you started: http://www.tek-tips.com/viewthread.cfm?qid=523094&page=14 I think you can also use Windows Task Scheduler if you have it. I think it runs in a similar fashion.

Thanks for posting this! I was able to get the .bat file to launch the macro but when I added the Command part, it bombed. All it needed was to move the Command arguments inside the quotes like so: "C:\Program Files\Attachmate\EXTRA!\Ebrun.exe" "C:\Program...

If you are trying to move the cursor to the end of the current field, try: Sess0.Screen.Sendkeys("<EndOfField>") We have our End key set to execute <EraseEOF> which erases to the end of the current field the cursor is located in but use Ctrl + End for <EndOfField>. Does this help?

You can replace all of your "Sess0.Screen.WaitHostQuiet (g_HostSettleTime)" with "Do While Sess0.Screen.OIA.XStatus <> 0 : Loop" I had been putting a WaitHostQuiet in the middle of that loop but I learned from ChrisWhite123 that omitting it saves tons of time in how fast the macro can run.

ChrisWhite123, removing the Sess0.Screen.WaitHostQuiet (g_HostSettleTime) from the middle of my loop has already saved tons of time in my processes. You wouldn't think that 50 ms would slow things down that much, but the difference is astounding. Thanks!

This may be what CompuDork was referring to, but I use the OIA.XStatus property to check the state of the "status bar". If the mainframe is processing slow then this will allow you to wait until it is finished before performing the next task. I typically use a g_HostSettleTime = 50 so that it...

It sounds to me like his keyboard map has been erased or overwritten with a blank default. We've had this happen to a number of people in my office. You can view the keyboard setup by opening the Keyboard Map Editor (either an icon or by selecting Options>Settings>Keyboard Maps and select the...