Guests - If You want access to member only forums on FM. You will gain access only when you Sign-in or Sign-Up on Fishing Minnesota.

It's easy - LOOK UPPER right menu.

  • RECEIVE THE GIFTS MEMBERS SHARE WITH YOU HERE...THEN...CREATE SOMETHING TO ENCHANT OTHERS THAT YOU WANT TO SHARE

    You know what we all love...

    When you enchant people, you fill them with delight and yourself in return. Have Fun!!!

Sign in to follow this  
Whoaru99

MS Access / Excel experts?

Recommended Posts

Whoaru99

Normally I can figure out most of the stuff I need to do, but in this case I'm stumped.

I have several linked MS Access tables that I query and then export to Excel. Several of the columns that are exported are dates. In Excel I need to change the date format from mm/dd/yyyy to dd-mm-yyyy.

The problem I'm having is that for three of the four date columns, I can merely change the column/cell format and the date formats change, but on the fourth column, the only way I can get the date to change format is to change the column/cell format THEN click into a cell, hit "enter", and only then the date format changes.

What am I overlooking??

Share this post


Link to post
Share on other sites
huntingislife

Hmmm, I am not quite sure. It appears it should just work like the other 3 columns. Is the data highlighted when you change the format?

Did you try this? : Get the first cell in the correct format and then click and hold down the lower right corner of the first cell(when you get the black + sign) and just drag down to the bottom of your data. That should change the format of the other cells to the format of the first cell.

Good Luck

Share this post


Link to post
Share on other sites
Whoaru99

Yeah, I just select/highlight the whole date columns and then change the cell formatting. Three of the four change no problem. Nothing seems to change the format of the dates in the fourth column until I select the cell, click the cursor into the cell, and then hit enter to exit the cell. As soon as I exit the cell using the enter key, the format changes.

Also, if it change the date value in any of cells that would not reformat, the new entered value takes on the desired format.

It's like somehow the format is locked on the data in that column.

I've tried changing to date serial number/value and back again, nothing seems to work...

Don't recall if I've tried to drag the format, but I'll give that a shot Monday morning.

Share this post


Link to post
Share on other sites
huntingislife

Another thing you could try is to insert a new blank column next to the 4th column and then copy and paste the 4th column into it. But instead of just pasting it, select "paste special" and then "values". This will get rid of anything that the format might be referencing. Then you could format the new column and delete the old one.

Share this post


Link to post
Share on other sites
wayne123

I would compare the formats of the columns in Access and see if there is any difference. I am assuming that you are importing into a blank Excel spreadsheet if not check the format of the columns before you import the data. Also try the format painter. It is the icon with the paint brush.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  



  • Your Responses - Share & Have Fun :)

    • leech~~
      Thanks, for the info.  I'll just look at the Steelhead and Looper on my wall to refresh my memory!
    • oilandwater
      Have heard of very few.  An occasional rainbow (looper and steelhead, make sure to learn the difference) mixed in with the catch in Two Harbors, along with lake trout near the bottom on the right day.  I've seen a few cruising under the ice in McQuade, but pretty slow there.  Rainbow action will pick up as spring progresses. 
    • smurfy
      sheez got that right!!!!!!!!!
    • hunterdown
      I might be able to make this, I think Jr. will have the time off as well....so, maybe him and I?
    • Rick
      Spring turkey hunters hoping to bag a tom during the first two weeks of the season have until Friday, Jan. 26, to apply for a lottery permit. The season runs from April 18 to May 31 and is divided into six hunt periods, A through F (see table below). Hunt A and B licenses for firearms hunters age 18 and older are limited in availability and assigned via lottery drawing. Turkey lottery applications cost $5 and can be purchased online at mndnr.gov/licenses, by phone at 888-665-4236, or in person from a license agent. Successful applicants will receive a postcard in the mail by mid-February and can purchase their hunting license starting March 1. Firearms licenses for hunts C, D, E and F are not lottery-limited and will be available for purchase over-the-counter beginning March 1. All licensed turkey hunters can participate in Hunt F if they have an unused tag from one of the earlier hunt periods. Archery and youth hunters (under 18) are exempt from the lottery and may purchase a spring turkey license valid during all hunt periods, including hunts A and B. Surplus lottery licenses from hunts A and B, if available, will be sold over-the-counter starting in mid-March. Visit mndnr.gov/hunting/turkey for more information about turkey hunting in Minnesota. 2018 Spring Turkey Hunt Periods
      Hunt A: April 18 – 24
      Hunt B: April 25 – May 1
      Hunt C: May 2 – 8
      Hunt D: May 9 – 15
      Hunt E: May 16-22
      Hunt F: May 23-31 Discuss below - to view set the hook here.
    • Rick
      Youth and adults can learn to hunt turkeys this April with experienced volunteers who will cover safe hunting techniques, how to call-in turkeys, hunting tactics and field dressing a bird. “We teach the skills and techniques that allow new turkey hunters to become lifelong hunters,” said Mike Kurre, learn-to-hunt program coordinator with the Minnesota Department of Natural Resources. “This has been a successful program and as a bonus, we love hearing how former participants go full circle to teach others how to hunt.” Participants can apply through Monday, Feb. 12. The hunts are Saturday, April 21, and Sunday, April 22, and provide opportunities to access locations that may otherwise be closed to hunting. “We get volunteers from the National Wild Turkey Federation and this is the 16th year we’ve cooperated for these hunts,” Kurre said. “Over the years we’ve introduced more than 5,000 people to these hunting experiences. We also work with the Minnesota National Guard to get military adults and their families into turkey hunting.” Details about how to apply and costs to participate are available at mndnr.gov/turkeyhunt. A pre-hunt orientation is required and all participants will need to have a valid firearms safety certificate or its equivalent. Youth must be accompanied by a parent or guardian. Overall participation in the hunts is restricted by the number of volunteers and private lands that are available. Anyone interested in providing turkey hunting land for the mentored youth hunts should contact the Keith Carlson, Save the Habitat Save the Hunt coordinator for the National Wild Turkey Federation in Minnesota at kcanoka@comcast.net.   Discuss below - to view set the hook here.
    • Rick
      Gov. Mark Dayton has proclaimed Jan. 20-28 as Snowmobile Safety Awareness Week in Minnesota. This an opportunity for the Department of Natural Resources, volunteer safety instructors, the Minnesota United Snowmobilers Association (MNUSA) and its 250 member snowmobile clubs to join together to recognize the importance of safe, responsible snowmobiling. “It’s a fun and exciting activity, but snowmobilers should always remember to make safety a top priority,” said Conservation Officer Bruce Lawrence, DNR recreational vehicle coordinator. “They should also always use common sense and keep a clear head when riding.” Here are some other key safety points: Snowmobiling and alcohol don’t mix – don’t drink and ride. Smart riders are safe riders – take a snowmobile safety training course. Always wear a helmet and adequate clothing. When night riding slow down – expect the unexpected. Know before the ride  – always check local trail and ice conditions. Cross with care. Know risks and be prepared – make every trip a round trip. One is the loneliest number – never ride alone. Ride safe, stay on the trail – respect private property. To legally ride a snowmobile in Minnesota, residents born after Dec. 31, 1976 need a valid snowmobile safety certificate. Options for both classroom and online classes can be found at http://www.dnr.state.mn.us/safety/vehicle/snowmobile/index.html People can find Minnesota snowmobiling events and activities on the MNUSA webpage: https://mnsnowmobiler.org/get-involved/mnusa/events. Discuss below - to view set the hook here.
    • eyeguy 54
      sounds like a hoot. hope to get there. 
    • Roscoe010
      Hi Wanderer, I am going up this weekend too.  Glad the weather will be warm! I will try a different pit this time, but had good luck last year.  I hope the fish will be active and hungry.
    • IceHawk
      Thanks Rick! Jeff hope to make it always a good time and laughs when you get a group of great people together. I usally do more jaw jacking  then fishing at these things but for me its just as much fun 
  • Share & Have Fun