Search results

Thanks all. Current set-up: Access front-end connected to SQL server on Azure server Wondering if DataVerse is as powerful as a front-end (user-friend forms, VBA capability, etc.) - does it work as an Access replacement? or more of a back-end storehouse? For PowerBI, just want to confirm what I...

Has anyone explored using DataVerse? And/or PowerBI? I have questions please.

What's weird is that IsLoaded = false, but it won't let me delete it, even manually!

I did DoEvents still no luck.

I'm actually running that code from a general module. And I've tested that the form is not Loaded before I run this code. Would subforms be a culprit?

Hello. I have a MAIN form that needs to differ depending on the situation. So I have two TEMPLATE forms that I want to use to replace the MAIN form. So roughly the logic is this: Close the MAIN form Delete the MAIN form Copy TEMPLATE_A or TEMPLATE_B and rename them into MAIN form The problem...

Not sure I'm following this item...

Thanks everyone - great insight. If you HAD to give up Access tomorrow... what would you go to. that you think IT would support? Visual Studio? Something else?

There is talk at my company of Microsoft slowly supporting MS Access less and less (not sure I believe that) and/or our IT dept supporting it only through say 2026. What are you hearing? And what alternatives are out there that allows for connecting to SQL server data, user-friendly forms, and...

Thanks all. Need to dig into it more.

Can't open a form whose underlying query contains a user-defined function that attempts to set or get the form's recordsetclone property. Just started seeing this error all of a sudden on Access front-end that accesses Access back-end DB and SQL server. Any suggestions?

Duh?!?!?

How to refer directly to Excel function within Access VBA, please? Thanks! Old database has this coding which is bombing... Abs(Round(Excel.WorksheetFunction.Days360 I get "variable not defined" for the "Excel" word.

I can grab other fields from the table, but any XML type field gets truncated, and not always at 18 characters. It varies.

Okay here's my new issue ... when I grab the XML field from SQL server, it only grabs the first 18 characters, whereas I know it's much longer. I'm using a String type in VBA. xmlstring = rst("XMLField") EDIT: It is grabbing the last 18 characters of the XML field (last 2 lines). Why won't it...

Actually now it's working - THANKS!!!

I get this error using that coding... 3305: Invalid connection string in pass-through query

Thanks. How about any suggestions on Connection Strings for an Azure SQL server database, from Excel? THANKS.

Okay I have access to the SQL server database now. I'm trying to set a recordset = a passthrough query on the server, but in Excel VBA (not Access VBA). Any coding examples? This is what I would use in Access... Function fnServerRecordset(pSQL As String) As DAO.Recordset Dim qdf As...

Also, for connecting to sql server on Azure, any suggested connection strings that work well for you? Thanks.