Re: [MS_AccessPros] Export to Excel greyed text

 

Robin-

Just tested, and that option is not available (checked but you can't clear it) if you try to export a form or report.  You can clear it if you try to export a table or a query.  Are you trying to export a report?  Instead, export the report's Record Source.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Sep 18, 2016, at 1:40 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

Access 2013


At 18/09/2016 07:44 PM, you wrote:

  

Robin-

Which version of Access are you using?

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
http://www.viescas.com/ 
(Paris, France)




On Sep 18, 2016, at 3:15 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




Thanks John,

I do not have the option. It is presented already ticked and greyed ou t.

Cheers,

Robin

At 18/09/2016 04:21 AM, you wrote:

  

Robin-

If you're using the User Interface (External Data / Export / Excel), then make sure you do NOT check the box "Export data with formatting and layout" on the first panel of the export wizard.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals  ;
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
http://www.viescas.com/ 
(Paris, France)

On Sep 17, 2016, at 8:59 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a dataset that I need to export to Excel.
Using the facilities provided by Access gives me the data but it is 
in a very grey colour.
What have I done to cause this and how do I correct my mistake?

Many thanks,

Robin Chapple

------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au >
------------------------------------

------------------------------------

Yahoo Groups Links

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___