Recent content by Minty

The first twelve characters of a field will be returned using (in a query) MyFirst12Chars: Left([YourVeryLongFieldNameWithSpaces],12) So use that as the comparison and grouping field.

@Kavithathanikanti - You do realise this is a 17 year old thread?

If you use the following, generally speaking, the output is a lot better quality DoCmd.OutputTo acReport, sRepName, acFormatPDF, sFullPath, , , , acExportQualityPrint

Just to expand, Azure is a cloud-based managed service provided by Microsoft, I'm not aware of any method of connecting to it "directly" without WAN access.

Could it be that Well_ID is a Number? Not a text field?

I use this routine to resue a pass-through to Azure Public Sub sSendToPT_Generic(strQuery As String, bRetRecs As Boolean) Dim db As DAO.Database Dim qDef As QueryDef Set db = CurrentDb() Set qDef = db.QueryDefs("qPT_Generic") qDef.Connect =...

Pass through from Excel: https://answers.microsoft.com/en-us/msoffice/forum/all/send-query-as-pass-through-to-odbc-source-via/304f93ee-12e7-4e0c-839f-af8e87cba4e8 But I thought there was a better way to handle XML data in Access but am struggling to find what I am looking for?

Correct It's effectively simply stored in memory, then deleted once the procedure is run.

The best way is to use a parameterised query. This https://www.access-programmers.co.uk/forums/threads/too-few-parameteres-expected-6.281472/#post-1453812 post demonstrates a simple way to set it up

@templeowls I also provided an answer in the crossposted thread, yet you haven't acknowledged that or @bastanu contributions here? Both of the answers provided gave you what you needed.

Altering a value in VBA doesn't trigger any events associated with that control. If it did it would be very easy to get things stuck in a loop where control A updated Control B which updated control A etc. etc. You can however call the event if it's made public, generally speaking though, this...

Finally, we are getting a proper description with some rules to determine the sort order. I'm not sure you can do this in one query, I think you will need to load the runners into a recordset, then loop through them and add them to another recordset, adding the heat numbers based on the number...

Set the subform to data entry = true then, no filters or anything else required? Every time the parent record change it will reset the subform to a blank new line record, or at least it should do.

It's because it is long text I susupect. Access doesn't play well with long text (Memo) fields.

That is a calculated field in a table. You can't update it as it is will be based on other fields in that table. Normally - that field would be [FirstName] & " " & [LastName]