what does keystrokes %RR do

[rollingzep]

Hi,

I have inherited an Access database. When I open the database, it triggers few queries before the main form is visible.
I looked for the AutoExec but do not see one.
I see a macro with SendKeys Keystrokes %RR.

What is the above macro for? If this macro does not trigger the queries, is there a way to check the code which triggers this?
If i need to modify the queries or the code behind, how/where do I check?

The code behind this all takes a while to execute all the queries and I need to see if they are all used or if few of them are redundant?

TIA

 

[welshgasman]

Why not just run it and see?

 

[rollingzep]

Why not just run it and see?

As I mentioned, it is an inherited DB and contains sensitive data. Also, I am unable to see the codes, queries and tables involved with this macro.
How do I check those objects involved.

 

[welshgasman]

A quick Google shows it is Alt key +RR, so perhaps a shortcut to run those queries?

SendKeys statement (VBA)

Office VBA reference topic

learn.microsoft.com

So run that key sequence manually?
What is the extension of the DB?

However the macro is called RefreshRecords? Does that not give you a clue?

 

[rollingzep]

What I need is to see the contents specified in the macro. There are no queries or modules listed in the macro.
It is .accdb
I can understand that it obviously refreshes but what does it refresh?

 

[welshgasman]

That would depend on what context it is called?
I have only ever used macros for bat h actions.
Look for how a macro is called from a macro or vba. I think if called from a macro, that will be harder to find. VBA is much easier to debug.

 

[welshgasman]

I believe it simply requeries the active form.
Tried the keystrokes on two of my dbs and that is the effect.

 

[Micron]

When I open the database, it triggers few queries before the main form is visible.
I looked for the AutoExec but do not see one.

Possibly the creator chose to hide it or the form might have an embedded macro that runs the queries before displaying the form. There is a setting in options that allows you to see hidden objects, but you want to be careful with that.

Also possible that SendKeys is requerying that form, which will automatically cause a query to run. However, if more than one query runs or actually opens as a datasheet then I say that's not it.