Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Aelstro

    Sending ALT + 013 via VirtualKeys

    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...
  2. Aelstro

    Sending ALT + 013 via VirtualKeys

    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...
  3. Aelstro

    Sending ALT + 013 via VirtualKeys

    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...
  4. Aelstro

    Sending ALT + 013 via VirtualKeys

    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...
  5. Aelstro

    Sending ALT + 013 via VirtualKeys

    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...
  6. Aelstro

    Basic user created objects

    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...
  7. Aelstro

    Basic user created objects

    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...
  8. Aelstro

    Basic user created objects

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

    Basic user created objects

    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...
  10. Aelstro

    Basic user created objects

    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 =...
  11. Aelstro

    Excel Import- Print area

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

    Excel Import- Print area

    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...
  13. Aelstro

    Excel Import- Print area

    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...
  14. Aelstro

    Updating a single record using ADODB

    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
  15. Aelstro

    Updating a single record using ADODB

    ...Db = CurrentProject.Connection Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection SQLstr = &quot;SELECT * FROM &quot; + strTable rst.Open SQLstr, Db, adOpenStatic, adLockOptimistic, -1 IntI = 1 CountIndex = 1 varData =...
  16. Aelstro

    Updating a single record using ADODB

    Some more detail on the project: The field in the table is a list of invoices. Each invoice number can have multiple lines, so the invoice numbers can be repeated. Other than the repeats, the invoice number is unique. So I am trying to write a script that goes through the Invoice table and...
  17. Aelstro

    Updating a single record using ADODB

    I think that may have given me a clue. I'll probably need to moveFirst and then for each row moveNext in a repeating loop. Seems like that would take a long time though. The record I need to alter is actually at place 649 out of 740. I just gave the simple example so I wouldn't have to type...
  18. Aelstro

    Updating a single record using ADODB

    I've searched and searched the forum but have come up with nothing. I'm sure it is simple and I just missed something basic. I have a table. In this table is a record. I know what record it is by field name and row. Using ADODB I want to update that single record. i.e. NameTable...
  19. Aelstro

    Revise field on form when a table field is changed

    I'm having a similar problem. I'm trying to update the caption on text boxes as code executes, but it doesn't seem to refresh the screen to update the captions. Does anyone know what I can do to update them?
  20. Aelstro

    ADODB removing Records in a recordset

    Thank you for your help!

Part and Inventory Search

Back
Top