ms-access tag

11 questions


1 answers
446 views
0
Access 2019 ACE.OLEDB fails to install on Windows 10.

Thank you for your help.In VisualStudio 2019 Community's C#, I tried to set up a program to manipulate Access's DB, but As ACE.OLEDB was not included, I downloaded accessdatabaseengine.exe (2016 versi...

2 years ago

1 answers
154 views
0
Handling Chinese Characters in Queries When Accessing AZURE SQL

select Name from Customer Basic Information where Name = 'Kanji'If so, the result is zero.On the AZURE SQL management site select Name from Customer Basic Information where Name = N 'Kanji'If you add ...


1 answers
78 views
0
Handling Chinese Characters in Queries When Accessing AZURE SQL

select Name from Customer Basic Information where Name = 'Kanji'If so, the result is zero.On the AZURE SQL management site select Name from Customer Basic Information where Name = N 'Kanji'If you add ...


1 answers
102 views
0
Microsoft Access Overflows When I create a link table from SQLServer and try to calculate it in a query

A table linked to Microsoft Access from SQLServer SQL calculates and tries to display, causing overflow This will result in an error.I was able to calculate normally when using the local table without...

2 years ago

1 answers
99 views
0
I want to create a search form with ACCESS

I would like to create a search form with ACCESS VBA.(Query - I think we can do the same thing, but this time we want to implement it in VBA.)As shown in the attached image, there are about 20 tables ...

2 years ago

1 answers
123 views
0
Please tell me about Access VBA.

I would like to enter a number (integer) in the text boxes X1 to Y1 to find the sum.x1□~y1□sum□button□Private SubtnWa_Click()  DimSouwa As Long lSouwa = 0 ForlSouwa= txtX1 TotxtY1 lSouwa=txtX1+txtY1...

2 years ago

1 answers
128 views
0
Export from Access DB to MySQL DB

You are trying to export from Access DB to MySQL using MySQL ODBC.Select the table in MS Access, export → ODBC database, and When you run it, ODBC - The call failed.                  Incorrect string ...

2 years ago

2 answers
117 views
0
What characters can I use for access and Excel passwords?

Please tell me all the characters that can be used as passwords in MS Office access and Excel.I remember seeing that you can use the code that you can specify in the Char function on some site, not to...

2 years ago

1 answers
136 views
0
Access VBA fails when EXPORTing to AZURE SQL

When the Access VBA attempts to EXPORT to AZURE SQL using the following instructions, an error occurs if the table exists on the server:DoCmd.TransferDatabase acExport, ODBC Database, ODBC; DSN=test; ...


1 answers
106 views
0
And the program of summing up from the other side doesn't work.

I would like to create a program that asks for the sum of X to Y.You also have to create a program that you want from the other side.Exit Sub is not available.It does not respond when looking for a la...

2 years ago
- 1 - »

© 2024 OneMinuteCode. All rights reserved.