Recent content by Aelstro

I'll bet you're right. I wonder if sending: VBkeys("%{NumPad0}) VBkeys("%{NumPad1}) VBkeys("%{NumPad3}) as three seperate commands would be the equivalent of holding down ALT if I removed the KeyUp portion until the third VBKeys statement was sent. Something like VBStickyKeys("%{NumPad0}) as...

Zathras, You are correct. Even in a wacky ancient dos program, CTRL-M does work "{^M}" Perhaps I should explain just so I don't feel so silly. On the page previous, no enters worked, and the arrow commands returned "2" for {down} and "6" for {right}. Of course, these are all the commands I...

Thanks again Tony, I got it to work. Ha ha. I mistyped Vbsendkeys("{enter}") to Vbsendkeys("enter") (missing parenthesis) so that it was sending "enter" insted of the carriage return... duh! Well, I hope this code has been useful to others and will continue to be for anyone who has to...

Tony, ForceEnter is my added code to the code originally writen by Brian Wolfe. I certainly thought it should be sending ALT + 013, but it doesn't produce the same result as me typing ALT 013 on the keyboard. I sent in "%{ForceEnter}" and it seems to set it right, but the result is that the...

Hello all, I have gleaned measures from this site, and haven't had to post very often. Unfortunately, I am stumped at this phase in my project. Setup: Old COBOL dos program feeds info into my spreadsheet. Commands include arcaic random key presses (i.e. 13 = main menu. 24 = print F2 = exit...

Ok, this is what I was looking for, here it is if anyone else needs to create class modules (or new user defined types, or user defined objects as they are called by different programming languages) First Menu Inser--> Class Module Then you define your Property value: Dim intDoors as integer...

Alright, now I have a blank screen and the name that excel uses so I can search a bit more I found this post that gives an example of using a class module http://www.tek-tips.com/viewthread.cfm?SQID=808797&SPID=707&newpid=707&page=1 But can anyone give a good solid example of the different...

Ahh yes, that sounds about right. how do I go about making a class module and interacting with it once it is created?

Thank you. Let me see if I can clarify I'm not looking to create a group of users, but just any user defined type, or object. Something flexible that I define and set properties and methods to. It could have been: Dim MyCar as new Car where car is my user-defined object having a property...

I have searched through the forum for anthing related to user defined objects, or user created objects. What I'm looking for is a basic set of code to create an object and attach methods and variables to it. Something like: <Define UserObject> Dim MyObject as new UserObject MyObject.MyName =...

Thank you. I learned something new about Excel today. That could come in very handy later. Aelstro

Ok, here is the solution for my problem, but I still don't understand. I removed the &quot;Print Area&quot; part and just imported &quot;Exports$&quot; This successfully grabbed the whole page. Now, my question is, why is there a print area that is different from the whole page? Can this be...

Hello all, I am trying to link a sheet from an excel spreadsheet to my database via code. The code looks like this: DoCmd.TransferSpreadsheet acLink, 8, &quot;Exports-ASN&quot;, MyLocation + &quot;Account Status Notebook\Account Status Notebook.xls&quot;, False, &quot;Exports!Print Area&quot...

I tried to update rst.fields(strField).value and all I got were errors about BOF or EOF being true. I'm sure it was something simple I did wrong. Anyway, thank you ever so much for your diligence. I never would have solved it without your code and suggestions. Kenneth

That is correct except the first entry would be left alone, second entry gets the first -1. I think I found a solution. Here it is: Public Function funFillArray(ByVal strTable As String, Optional ByVal intFieldNumber As Integer = 0) 'Created By: Robert Johnson 'Modified By...