Search results

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 :).

Is there a preference between opening with an SQL statement or opening as a table and search with a Filter (something like tblTable.Filter = strFilter )?

I heart tha DAO is 'old-fashion' and will be no more supported by Microsft in the future. Besides, I want to use my database as a multi-user db with splitted tables.

Hi, I used to work in an Access DAO-environment with indexed tables. I was very happy to work with the '.seek Criterium' in my Recordsets to look after the 'good' records. However, I want to switch to an ADO-environment. Whitch method is the best (and the quickest) in my indexed tables: '.seek...

The updated text-fields are numeric. Updating such fields in one (table-bounded) form, causes updating (calculated) fields (using the updated text-fields) in other tables.

I use and need very often 'Text-fields events' (Got focus/After update).This effects updates in two other tables. Do you mean by 'Form level events' that I rather avoid this Text-fields events (this would be very annoying)? May-be I will know what's better trying it out wit real data?