SendKey

[bionicman]

is it possible to use the SendKey command to send text to a message box? for example, when running a query that needs information from a message box.

 

[Fuga]

I always end up having trouble with the sendkeys stuff. What exactly do you want to do?

Fuga.

 

[bionicman]

I want to automate running a report, but my report prompts me for a date range, and a couple other things that come up in a message box.

 

[Fuga]

Is your report based on a query?

If the query is a parameter query, then you can use the contents of fields in your form for parameters.

However, you say it prompts you for a couple of other things and that could mean there´s something wrong with the query. I´m not very good at reports but I´ve had similar problems with forms. In my case, I had changed some names of the fields so the form had fields in it that no longer existed.

Fuga.

 

[bionicman]

Yeah, it is based on a query. I said it asked for a few other things as far as i want it to ask me an employee name also, i just did not type all that out the first time

Thanks for the help