Sendkeys Problem (1 Viewer)

[Ali Edwards]

Hi all,

Have run a database in Access97 for a few years now with no problem. However, since upgrading the operating system to Win 2000, none of my sendkeys actions work. I'm still using Access 97 as that is what most in the company use and the database is regularly distributed to them.

I have tried creating new sendkeys actions and they just won't work. Unfortunately most of the functions in the db rely on sendkeys so I'm really in schtook. Where possible I'm using different methods to get out of the problem but I still need to use sendkeys a fair bit.

One example is to copy a field's contents to the clipboard:

sendkeys "+{Right 20}", true
sendkeys "^c", true

Anyone have any ideas or had similar problem?

Many thanks,

Ali

 

[Ali Edwards]

Another thing!

Because of the demise of all my sendkeys actions, I am trying to find a way to make a query's Criteria pane = a text box in an open form. I used to (from a cmd button) open the query in design, arrow down to the criteria pane and paste in the data from the field in the form - all from sendkeys. This meant I could base several forms and reports on the same query.

I kind of need to do:

qry.[Queryname].[fieldname].Criteria=Forms![Formname]![textboxname]

Can anyone tell me if this is possible?

Thanks again folks
Ali