Recent content by munhun

There are two different forms. One form is a pop-up form. .... A form Another form has subforms. .... B form ( sub form is C ) When I click the button in the popup form, I need to move the record of the subform of another form to the next record. I tried like this: 1. In the subform ... (...

"MySQL ODBC 8.0 Unicode driver" is installed and the program is normal. DoCmd.TransferDatabase acLink, "ODBC Database", "Driver={MySQL ODBC 8.0 UNICODE Driver};Server=xxx.xxx.xxx.xxx;port=3306;Database=dbname;User=username;Password=password;", acTable, "testTable", "testTable", False, True...

I used MS-ACCESS. I am currently using it as an ODBC manager. I gave the program permission through user login. The problem is that when someone connects to the ODBC manager, they see all the DB information. Therefore, I need to connect the tables in VBA without going through ODBC Manager.

Hello. I use MySQL as a database. I connected the database using ODBC Administrator. However, I found this to be a security problem. When someone connects to this ODBC, all database information can be viewed and modified. Therefore, I found that I need to connect to VBA automatically without...

Hello. (I am not good at English.^^) Help me. I moved the database. (B Server -> A Server) There was nothing wrong with the "B" server. Look at the next picture. "tech_keep_t" table and "tech_keep_t-2" table are the same. The "tech_keep_t-2" tables connected to the "B" server are...

Even if it's not a good idea... When there is no record "SourceObject = ''" form_name.SourceObject = "" Thank you...

CommandBars.ExecuteMso "RecordsTotals" ... Good code. But.... One more question. Do you know if "RecordsTotals" is displayed or not? I want to show when a record is present and not when it is not. It is causing problems when there are no records.

Hello. Help me. Click the "Home" tab -> Record -> Total to get the sum in the datasheet. I want to implement this menu button with vba. What is VBA code? ex) docmd.RunCommand ???? I would appreciate your reply by e-mail. jeongmunhun @ gmail . com Thank you.