Recent content by fd110

gpt suggest!! Option Compare Database Sub ImportAndCompareTables() Dim db As DAO.Database Dim tbl As DAO.TableDef Dim newTableName As String Dim rsExisting As DAO.Recordset Dim rsImported As DAO.Recordset Dim strSQL As String Dim fld As DAO.Field Dim fd As...

If you can add a part to your code that has a dialog file and imports the tables to the database with an imported extension, it will be much easier to transfer information and left join with existing tables. thanks Sub ImportTablesFromExternalDB() Dim externalDBPath As String Dim suffix...

I have found a code that takes the file and deletes the tables completely. In this case, it is difficult to use join If it is possible to change the code so that it first imports all the tables into the database, for example, import_takhrij, and then upserts the information using join, and...

So, how to join two tables with multiple keys? In my opinion, you said in the training that you should not do three joins. Or did you mean three joins without key?

Without the key it takes too long and my device hangs With the key, since there are duplicate keys, the information gets mixed up and the old and new information is merged into one record Even in uniqe keys, both old and new information are merged together in one record. For example, a field has...

Hello Thank you for your attention. No, I just collect the files and other users do not need to update. They send me the files by telegram. I may refer the file to them for correction after I review it. They send me the Access database which is exactly like my file structure. Only information...

that's great Only FindAsYouTypeCombo2 alone doesn't work? What is the difference with FindAsYouTypeCombo?

:( OK For this reason, I am currently looking for a way to sync and merge these files and make sure of the health and correctness of the data transfer. Or to modify the key in the takhrij table in such a way that it does not cause problems in the merge. For example, the Autonumber key should not...

If I have some sample files or code to merge, I might be able to find something out of all of them that solves the problem. If you have files for merging databases, please share Thank you

Thank you But for now, I want to see if there is a way to merge the databases There are some examples on the internet, like the Isladogs method, but each of them has problems and is not exactly what I want. They are key focused, but my data will have some kind of composite key that has three fields

Thank you very much. I am waiting, maybe other friends in this forum can help.

I'll have to work on the Isladogs file a bit, maybe I'll find a way

Thank you very much for your time. So there is no way we can merge these files together? Because manual integration is both time-consuming and the possibility of mistakes in it is high!! Sharing and synchronizing users may also take time. Unfortunately, not all our users have permanent access...

No, we don't have a server and we have to put it on the Internet! Yes, I know little about the front end

Thank you very much for your suggestion. In what environment should I share the file on the internet for it to work? Does Microsoft have a server for this purpose? If we can't share the file, isn't there a way to import data from multiple files?