Search results

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 this field is to make it easier for the database engine to know if a record has been changed by another task since it was fetched.

To help you with the syntax for getting nulls returned as well as strings with different values: SELECT Contact_People.* FROM Contact_People WHERE (Not Contact_People.Category="Accounts") Or (Contact_People.Category Is Null);

@Gasman Apparently the OutputTo has different arguments than TransferSpreadsheet does and so cannot create the other format spreadsheet. Moi has language issues and so has trouble following directions and that makes him very difficult to help. Perhaps he will understand my last suggestion and...

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 program was official and 1.2 million for 2023. And given the actual numbers reported, apparently it is 30,000 per country per month. So we are a long way...

@moi Try using DoCmd.TransferSpreadsheet rather than OutputTo. Also, when you are naming your file, do NOT use dots to separate the date parts. Many applications cannot read files with names containing multiple dots. Use dash or underscore. Print the file name for us also so we can see what...

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 a macro workbook (acSpreadsheetTypeExcel12) and the other to create a normal workbook (acSpreadsheetTypeExcel12Xml). The OP was using the argument to create...

What plan is that?

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 fund NGO's.

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 want to buy nice parchment paper. The better paper is ALWAYS the best solution. It looks great and feels great. Word can't do that. Word alone is absolutely...

OK, I give. Who is paying?

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.

So, you tell Access to export a macro enabled spreadsheet but you name it incorrectly to .xlsx. What do you end up with?

Are you aware that the Biden administration isn't content with just having an open border, they are sending planes to import "legal" illegal aliens from several countries such as Haiti and Venezuela. They imported 1.2 million this way last year and 800,000 the year before on top of the ones...

Of course. The simplest solution is a report. MailMerge requires that you create a word document with bookmarks. Not terribly hard but more complex than a report. Also, Staples has fancy paper that you can print your certificates on so they look professional without burning up an ink...

What part of acFormatXLSX is the name for the MACRO format and acSpreadsheetTypeExcel12Xml is the name for the STANDARD format did you not understand? Please just try replacing the correct name for what you have.

Why would you assume he is competent to develop in another tool? No one said Access was the best tool for everything. I pointed out that we don't know what he wants to do so we can't actually provide valid advice. We need to know what he wants before we spin his head about the "wonders" of...

@GPGeorge I looked at some of your links and many of the UA links are broken

Because Access is a great tool for developing a certain class of projects??

Except that the extension doesn't match the export type. The .xlsx extension is the XML format but the type is the macro format. That seems to jibe with the error message.

You can't get what to work? I can't see your code. How can I help? Did you change the name as I suggested?