Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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...
10 minutes ago
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)...
Yesterday at 3:57 PM
Minty
replied to the thread
export filter data in selected fields to excel
.
@Kavithathanikanti - You do realise this is a 17 year old thread?
Friday at 10:14 AM
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...
Friday at 10:12 AM
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"...
Thursday at 4:38 PM
Minty
replied to the thread
DLookUp - Syntax
.
Could it be that Well_ID is a Number? Not a text field?
May 16, 2022
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...
May 16, 2022
Minty
replied to the thread
Grabbing XML field
.
Pass through from Excel...
May 16, 2022
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.
May 13, 2022
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...
May 13, 2022
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...
May 13, 2022
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...
May 13, 2022
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...
May 13, 2022
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...
May 12, 2022
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.
May 12, 2022
Home
Members
Top
Bottom