Recent content by Marnix

Hi Minty and Isaac. Thanks again for helping. I struggled a bit getting it to work, mainly because I want to use it DSN-less and in code. Now it works. Needed to add the connection string as qdf.connect = "ODBC;Driver = etc. etc. . It also took me some time to find out that the TSQL is sensitive...

THanks a lot Minty and Isaac for your replies. Really appreciate this! Will work with the answers tomorrow and let you know the results to close this topic.

Thanks for responding. I tried, but still the SQL seems to be evaluated by access. Dim qdf As DAO.QueryDef, rs As DAO.Recordset, strSQL As String, val As String strSQL = "select * from Notities where contains(notitie, 'test')" Set qdf = CurrentDb.CreateQueryDef("MyPTQ") qdf.SQL...

Hi, I recently migrated a split access db to Azure SQL Server. Really happy with the performance of SQL Views in SQL Server. I need to build a search form for searching text of supporttickets. In TSQL in SSMS i can perform queries like this one: select * from Supporttickets where...

Yes, totally clear and really helpfull. Just curious of anyone looks at the code and thinks 'Hey... this can be done smarter '. But I implemented the echo and hourclass and that works fine to stop flashing. Hi, I checked this before. When the recordset is changed and I read the values of the...

Thanks. That's helpfull! At least the screen is not as busy and it looks more neat. But it seems to cost the same amount of time. For now: thanks!

Hi, I'm reconstructing an access database having linked tables to Azure SQL Server. One of the techniques I use is setting a recordsource only when needed. THis makes loading a page with tab-control much faster. The following code shows part of the sub where the recordsource is set. The form...

Hi, In short: - I started with a database with relations between tables - I managed using SSMA to transfer this to Azure SQL. (yes, I needed to install the RT version of Access to prevent crashing of SSMA) - Relations between tables in Azure SQL are available. If I create a diagram...

Hi, We have a split database. I used the migration tooling to migrate tables to an Azure database. All tables have been renamed from TABLENAME to DBO.TABLENAME because of the way to use SQL in a proper way. My frontend however is using the plain tablenames. What's the best way to go: rename...