I installed a database application on a clients computer. I will be making modifications on my computer. Is there anyway I can just transfer that one object (form or report) to clients computer?
I installed a database application on a clients computer. I will be making modifications on my computer. Is there anyway I can just transfer that one object (form or report) to clients computer?
If it can be done by exporting I'd like to be in on the discovery.
Usual approach is to open the target db and use the 'get data' functions on the ribbon and import the needed objects. Your question suggests that the target db is not split. If it was it should be a simple matter of modifying a front end at your location and replacing the target db (front end) with that.
Last edited by Micron; 09-18-2023 at 09:52 AM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
use a macro since its easier to fill in the boxes, but use:
docmd.TransferDatabase acExport ,"Micrsoft Access",sTargDbName, acForm ,"fMyForm","fMyForm"
youll have to pick the object name (acForm, acTable, etc)
Hello Micron,
I tried your method and it works perfectly. But, i noticed the new form i copied is numbered as 1. So i deleted the old for and renamed the new form... Is that a normal behaviour when copying objects?
the copy will not overwrite existing, so it assigns a number every time you copy it.
remove old ver, then rename and remove the 1.
For reference, you can also drag and drop database objects from one database to another. See Drag & Drop Database Objects (isladogs.co.uk)
I made the assumption that one db was local, the other remote because you say one belongs to a client/customer. Given that you were able to do this using the Ribbon, I guess neither db is remote.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
If it is a split database (front end and back end) you can simply replace the front end. If it is not split, split it!
Groeten,
Peter