Search results for query: *

PHV exactly. as said the API call will, can identify the open/running Access sesion and the form itself. identifying the actual control on the form will rely on form open and respective textbox having focus initially. i just dont know how to code the api class find, or really the sendkeys...

kjv1611 i completely agree. but i dont think we will get the access. The 'IT' team have designed the User forms so that data can be updated in respective tables, from Business point, they have thousands of these changes. there is a business process in place to send data to DB admin team...

PHV There are, i understand, windows API's that can identify the 'open' object, in this case the Access form. that isnt the problem. its using the then found 'class' and using sendkeys / messege, to send a variable, value to that 'class' being an Access form is irrelevant. so not really a...

PHV as with above post, i dont have vba control of the database or form?

xlbo Thank you for reply. Unfortunately we dont have access to database. I am a vba developer working with business team, and IT admin wont on this occasion give us direct access. i can, via api's identify the class of the open object, but from there, i do not know how to write the code to...

can anyone help? i am trying to write a macro to copy values from excel and paste into an open msAccess form using, API to find class and Send keys / keypress / keystrokes to paste value to open form textbox can anyone point me in right direction. many thanks Nicholas