For all in search of sendkey (keystrokes) Macros! 1

[SupaSoundz]

Hello.

I do not like VB and I have been reading many threads telling the users to use it. All I want to do is create a macro with the sendkey function to go through steps to connect to Oracle in the long run using a command button. But I can't seem to even get started. WHAT I want to know is when I am putting in the keystrokes on the line that how am I suppose to enter them. Is there any special way? Because none of the ways I have tried have seemed to work.

[h2]For example:[/h2] first ALT+F then to ALT+G to ALT+L in Access 2000. That should open the import database window, but I have not gotten it to do so. From there I want it to open up OBDC to oracle sign in and then completion. I have figured out how many keystokes, tabs, enters, and ALT shifts I have to do. I just can't get it to run.

Please help. Thanks pmeyer@fdcclant.uscg.mil
- the ring in your ears -
"SupaSoundz"

http://www.mp3.com/supasoundz

 

[LonnieJohnson]

In a macro you need to put the expression in quoates. This is a command is the same as holding down Cntl then hitting T, D, C (which will take you to your menu option for compressing your database).

"%tdc" ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Guest_imported]

I've tried putting it in quotations, but when I click on run all it does is repeat what I typed in without making it happen. Could you give me a whole line example? as for to open file menu the import to link tables
thanx

 

[SupaSoundz]

Lonnie. If it was done in VB could you give me an example to start from.
As I said I just need to do simple steps as
opening the menu, counting tabs, and entering.
thanks again -Paul pmeyer@fdcclant.uscg.mil
- the ring in your ears -
"SupaSoundz"

http://www.mp3.com/supasoundz

 

[LonnieJohnson]

"{F11}%FDL"

This is the expression I just used to open the Link Tables window. I am using Access97. Maybe 2000 is different. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[LonnieJohnson]

If you were to use VBA, you may want to add a button on a form. In the button's Click event put...

SendKeys "{F11}%FDL"

PS: The {F11} opens the database window. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[LonnieJohnson]

Why don't you use the Transfer Database method? You can do this thru a Macro. You select the type (ODBC) and so on. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Bammer]

I like the sendkeys command for compressing.

Thanks.

 

[SupaSoundz]

I haven't used Transfer database because i didn't know about it. All I have used macros for at the moment is opening, closing, and flipping through forms, and connecting to some databases.
Now i am trying to get to the point where I can have a user just click a connect button and have the button go through all the connecting steps and have the user not have to worry about it.
I used the {F11} function but it did not solve the problem the way I wanted it to or at least I don't think because I didn't know if it connected ceds/oracle or if it did.
Could you possible just send me some kind of index or glossary of sendkey examples with keystrokes one after the other? pmeyer@fdcclant.uscg.mil
- the ring in your ears -
"SupaSoundz"

http://www.mp3.com/supasoundz

 

[SupaSoundz]

And what do you Lonnie and Bammer mean by compressing?
Is compressing connecting oracle then downloading the database to use?
thanks, Paul pmeyer@fdcclant.uscg.mil
- the ring in your ears -
"SupaSoundz"

http://www.mp3.com/supasoundz

 

[LonnieJohnson]

That was just an example of a SendKey command up above that would execute the CompactDatabase menu item.

Access has a great tutorial on SendKeys with examples. Just type in keyword "SendKeys".

I stongly suggest that you look into the TransferData base action in the macro window. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Guest_imported]

I guess thats my problem. I have already thoroughly tried to find every possible example but it did not come loaded on with my access 2000. Where ever I find sendkey or keystrokes the examples can not be seen and it gives me an error. Only system admins can install or do anything. I only have access to most of the files. That is why I am here trying to find thorough easy examples. The {F11} was fine. I am trying to work with the ALT, TAB, and ENTER keys in a consecutive process. if you are going to give me an example then that is what I will need it in. And as for compressing and compact database I really don't have any idea of what you are talking about. sendkey keystrokes sound really easy to me its just that I don't know how to write / encode them correctly. that is where you come in.
so let me know. -pauL

contact. pmeyer@fdcclant.uscg.mil

and I do not like this logging in and out thing. its getting quite annoying not being able to use your same name. AND you would think in the last visited would be my own forum and it doesn't show what you have last replied to or have down just where you have been. its hard to find this window again. i put in search for "sendkey or sendkeys" and comes back with no listing. super.

 

[LonnieJohnson]

The command that you are asking for is (Alt, Tab, Enter)

"%{tab}{enter}"

Now just curious, this command will toggle from one windows screen to the next. Is this something your are wanting to hardcode into your system? ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[LonnieJohnson]

supa-s-oundz

DO YOU HAVE YOUR PERSONAL OPTIONS AT TEK-TIPS SET TO EMAIL YOU WHEN SOMEONE REPLIES TO POST? THIS WAY YOU GET AN EMAIL AND YOU CAN CLICK ON THE LINK TO GET TO YOUR POST. VERY CONVENIENT. ALSO, THERE IS A "REMEMBER ME" OPTION WHEN YOU LOG IN SO THAT YOU DON'T HAVE TO DO THAT EVERYTIME.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[SupaSoundz]

I still don't think you understand. I need it all. All the little codes that help you toggle through using the sendkey macro function.

"%{tab}{enter}" -so how do I use this function?
Is it something like this: "%{tab}{tab}{tab}{enter}"
Would that make it tab 3 times then enter?
I need to use the ALT keys, CTRL keys, shift, pretty much
everything. I need to know how to make them work right.
Is {key} basically the style that goes into sendkey macros?

If you have the examples of sendkey and its lettering
could you please print screen it and send it to me
as a picture so I can just go over them. I have
no basics to work from.
pmeyer@fdcclant.uscg.mil
- the ring in your ears -
"SupaSoundz"

http://www.mp3.com/supasoundz