Minty's latest activity
-
Minty replied to the thread Office365 - MDB to ACCDB Issue.@Cherylodge Do you realise this is a 9-month-old thread, and that the solution you posted was suggested at the beginning of the posts... -
Minty replied to the thread How you find duplicates but only just for the first 12 characters in a cell?.The first twelve characters of a field will be returned using (in a query) MyFirst12Chars: Left([YourVeryLongFieldNameWithSpaces],12)...
-
Minty replied to the thread export filter data in selected fields to excel.@Kavithathanikanti - You do realise this is a 17 year old thread?
-
-
Minty replied to the thread Solved PNG Logo in Generated PDF not Printing Clear.If you use the following, generally speaking, the output is a lot better quality DoCmd.OutputTo acReport, sRepName, acFormatPDF...
-
Minty replied to the thread Quick query about Azure.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"...
-
Minty replied to the thread DLookUp - Syntax.Could it be that Well_ID is a Number? Not a text field?
-
Minty replied to the thread Grabbing XML field.I use this routine to resue a pass-through to Azure Public Sub sSendToPT_Generic(strQuery As String, bRetRecs As Boolean) Dim db...
-
Minty replied to the thread Grabbing XML field.Pass through from Excel...
-
Minty replied to the thread Solved Build Query With Single/Double Quotes Potentially In Free Text Field.Correct It's effectively simply stored in memory, then deleted once the procedure is run.
-
Minty replied to the thread Solved Build Query With Single/Double Quotes Potentially In Free Text Field.The best way is to use a parameterised query. This...
-
Minty replied to the thread Really struggling with cleaning this excel data when imported to Access.@templeowls I also provided an answer in the crossposted thread, yet you haven't acknowledged that or @bastanu contributions here? Both...
-
Minty replied to the thread Dropdown selection over button.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...
-
Minty replied to the thread Special Sort.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...
-
Minty replied to the thread Data Entry not working as Intended.Set the subform to data entry = true then, no filters or anything else required? Every time the parent record change it will reset the...
-
Minty replied to the thread Join 2 controls.It's because it is long text I susupect. Access doesn't play well with long text (Memo) fields.
