Recent content by Luciano

Here is the solution to decode from utf8 in Unicode ' Decodes a UTF-8 string in Windows (Unicode)-string 'Returns: ' A Windows (Unicode) string Function UTF8_Decode(ByVal sStr As String) Dim l As Long, sUTF8 As String, iChar As Integer, iChar2 As Integer For l = 1 To Len(sStr)...

As a matter of fact, someone who is specialised in mySQL and php imports/exports some tables with 'DBSync for MS Access & MySQL' in/from my Access 2013-database. He told me that I have to solve this issue (something like set utf-8 in my Access-database) ???

Hi, I do export with php an MySQL table into an Access 2013 table. It's working fine but special characters (i.e. é à è ë ü ..) in my fields becomes totaly unrecognizable characters. How can I avoid this ?

is Docmd.setwarnings true echt nodig? Ik wens immers nooit een bevestiging te vragen.

Hello I have developped an Access 2013 application. I installed the Access 2010 Runtime and my application runs well, except that I have to confirm in a pop-up window Acion/Update/Delete-querys. In the regular-version, I uncheck the checkboxes in the Option/Client Setting/Confirm Record Changes...

Hello I have developped an Access 2013 application. I installed the Access 2010 Runtime and my application runs well, except that I have to confirm in a pop-up windowall the Acion/Update/Delete-querys. In the regular-version, I uncheck the checkboxes in the Option/Client Setting/Confirm Record...

How saving the Excel-file before openeing ?

Hi namliam je hebt inderdaad overschot van gelijk, 'k heb mijn code aangepast en dit geeft een beter en sneller resultaat. Thanks DoCmd.OutputTo acOutputQuery, "qryPlanningOnLine, "ExcelWorkbook(*.xlsx)", "C:\Planning\Planning.xlsx", False Dim objXl As Object Dim objActiveWkb As Object Set...

Hi The following code is working fine: Dim objXl As Object Dim objActiveWkb As Object DoCmd.OutputTo acOutputQuery, ”qryPlanningOnLine” , "ExcelWorkbook(*.xlsx)" , “C:\Planning\Planning.xlsx” , False Set objXl = CreateObject("Excel.Application") Set objActiveWkb =...

Hi I have a fatal error trying to open my Access-database: (NameDatabase.accdb). It's impossible to open. unrecognised database format 'H:\NameDatabase.accdb' Is it possible to recover this database?

I think this is the perfect solution for my problem. Thank you very much.

Indead, it would be a valid solution, but it's quit impossible for me to rename these controls (I use many prefixes like txt, chk, cmd, fra, ...).

Hi, I want to disable in VBA (.enabled = false) a lot of controlls, depending of some conditions. Is it possible to group (and having an unique name)these controlls to disable them all together at the same time.

I have three 'large' (bound and split) back-end tables that works 'together'. Large means in my application between 500 and 10 000 records. When I launch a criterion (max. on 3 fields), the number of retrieved records is rather small (between 0 and 20 records). You think that even in this...

OK, thanks, this was very helpful :).