Search results

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.

I will try that - good idea - but I suspect so. I need to gain more access to SQL server database before testing more (I was looking over a screen share so far).

Hello - connecting to an SQL server (sitting on Azure) and wanting to extract an XML field, using VBA, and ultimately parse it. Having trouble even grabbing the field. The prior programmer used ADO, but I'm more comfortable with DAO. It seems the connection is working (using ADO, but again I may...

Yeah - I was hoping to leverage ADO only because when I've done THOUSANDS of query updates, ADO is faster in that case. I'm guessing the time difference for just 2 records however is not worth losing the convenience of DAO/query updates.

Is it possible that running Access 2016 is part of the issue? If I update to say Access 2019 on the terminal server, that might lessen the issue?