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
.
Pat Hartman's latest activity
P
Pat Hartman
replied to the thread
SSMA_TimeStamp field never gets updated
.
I think the field doesn't actually contain a date and time. I'm not sure what it contains but it is something unique. The point of...
Today at 4:59 PM
P
Pat Hartman
replied to the thread
Qry excluding a word not working
.
To help you with the syntax for getting nulls returned as well as strings with different values: SELECT Contact_People.* FROM...
Today at 4:53 PM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
@Gasman Apparently the OutputTo has different arguments than TransferSpreadsheet does and so cannot create the other format...
Today at 4:08 PM
P
Pat Hartman
replied to the thread
Another mass shooting
.
Then in the next paragraph they change from 30,000 in total to 30,000 per month. So 30,000 * 12 turned into 800,000 for 2022 BEFORE the...
Today at 4:01 PM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
@moi Try using DoCmd.TransferSpreadsheet rather than OutputTo. Also, when you are naming your file, do NOT use dots to separate the...
Today at 2:17 AM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
I guess I wasn't being clear. I'll try again. There are two argument values for the TransferSpreadsheet for version 12. One to create...
Yesterday at 10:46 PM
P
Pat Hartman
replied to the thread
Another mass shooting
.
What plan is that?
Yesterday at 10:29 PM
P
Pat Hartman
replied to the thread
Another mass shooting
.
He's probably going to tell us that NGO's are paying. I guess he doesn't read any of those omnibus spending bills where MY tax dollars...
Yesterday at 7:30 PM
P
Pat Hartman
replied to the thread
Text template "certificate".
.
I've created certificates as Access reports. They look fine. You just need to find the right graphics to place on them if you don't...
Yesterday at 7:19 PM
P
Pat Hartman
replied to the thread
Another mass shooting
.
OK, I give. Who is paying?
Yesterday at 7:16 PM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
If you're ok with the inconsistency of the command, what do I care? My exports use the correct argument so I always know what I am getting.
Yesterday at 7:11 PM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
So, you tell Access to export a macro enabled spreadsheet but you name it incorrectly to .xlsx. What do you end up with?
Yesterday at 5:51 PM
P
Pat Hartman
replied to the thread
Another mass shooting
.
Are you aware that the Biden administration isn't content with just having an open border, they are sending planes to import "legal"...
Yesterday at 5:49 PM
P
Pat Hartman
replied to the thread
Text template "certificate".
.
Of course. The simplest solution is a report. MailMerge requires that you create a word document with bookmarks. Not terribly hard...
Yesterday at 5:33 PM
P
Pat Hartman
replied to the thread
Query export to Excel through button
.
What part of acFormatXLSX is the name for the MACRO format and acSpreadsheetTypeExcel12Xml is the name for the STANDARD format did you...
Yesterday at 5:28 PM
Home
Members
Top
Bottom