Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 12th, 2003, 04:52 PM
pete5668 pete5668 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Location: MA
Posts: 10 pete5668 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Importing Access checkboxes to Excel

My problem is this: I have an Access database with several fields are checkboxes, for a true/false value. However, when I export the main table to an Excel spreadsheet, the checkboxes don't come along for the ride. The cells instead have the word TRUE in the cell if the box was checked, and FALSE if the box was not checked. When I select one of the cells, I expected to see a function, but I just see text TRUE or FALSE.

Is there a way to replace these TRUE/FALSE text values with checkboxes, en masse, in one simple step?

Thanks!
Peter

Reply With Quote
  #2  
Old November 13th, 2003, 01:59 AM
a.koepke's Avatar
a.koepke a.koepke is offline
Second highest poster :p
Dev Shed God 5th Plane (7000 - 7499 posts)
 
Join Date: Jul 2001
Posts: 7,323 a.koepke User rank is Sergeant (500 - 2000 Reputation Level)a.koepke User rank is Sergeant (500 - 2000 Reputation Level)a.koepke User rank is Sergeant (500 - 2000 Reputation Level)a.koepke User rank is Sergeant (500 - 2000 Reputation Level)a.koepke User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 8 h 8 m 45 sec
Reputation Power: 27
The only way I could think of doing this would be to write a visual basic macro that would go through and replace it with the check boxes.

You would just have a loop that checks the value of the field, adds a checkbox and then ticks it if the field is true.

Reply With Quote
  #3  
Old November 13th, 2003, 05:07 AM
pete5668 pete5668 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Location: MA
Posts: 10 pete5668 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks A.Koepke

Thanks. I'll try it.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Importing Access checkboxes to Excel


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway