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.

  • Announcements

    • Rick

      Members Only Fluid Forum View   08/08/2017

      Fluid forum view allows members only to get right to the meat of this community; the topics. You can toggle between your preferred forum view just below to the left on the main forum entrance. You will see three icons. Try them out and see what you prefer.   Fluid view allows you, if you are a signed up member, to see the newest topic posts in either all forums (select none or all) or in just your favorite forums (select the ones you want to see when you come to Fishing Minnesota). It keeps and in real time with respect to Topic posts and lets YOU SELECT YOUR FAVORITE FORUMS. It can make things fun and easy. This is especially true for less experienced visitors raised on social media. If you, as a members want more specific topics, you can even select a single forum to view. Let us take a look at fluid view in action. We will then break it down and explain how it works in more detail.   The video shows the topic list and the forum filter box. As you can see, it is easy to change the topic list by changing the selected forums. This view replaces the traditional list of categories and forums.   Of course, members only can change the view to better suit your way of browsing.   You will notice a “grid” option. We have moved the grid forum theme setting into the main forum settings. This makes it an option for members only to choose. This screenshot also shows the removal of the forum breadcrumb in fluid view mode. Fluid view remembers your last forum selection so you don’t lose your place when you go back to the listing. The benefit of this feature is easy to see. It removes a potential barrier of entry for members only. It puts the spotlight on topics themselves, and not the hierarchical forum structure. You as a member will enjoy viewing many forums at once and switching between them without leaving the page. We hope that fluid view, the new functionality is an asset that you enjoy .
Sign in to follow this  
Whoaru99

MS Access / Excel experts?

Recommended Posts

Whoaru99    0
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    1
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    0
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    1
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    0
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  



  • Posts

    • delcecchi
      Best wishes for a happy retirement Ace.   I could never have done the guide thing even if I were a good enough fisherman.   It takes a special type of person to deal with all the different people... Congratulations on a job well done. 
    • Cliff Wagenbach
      Terry, Sorry to hear that you have to retire after all of these years! I suppose It will be my turn to join you and Tommy before to many years also. See you on the water!! Cliff
    • TomWehler
      Congratulations on job well done sir. Your deserve time for yerself with Sandra an the whole younger crew. You have always been nice to me an a big help when I first seriously did the Muskie fish guide deal back summer 1996. We have had some fun times laughing online an in each other's boat over the years. Even boated a fish or three an coined a few major phrases still used in today's ever so silly online Muskie fish market.  Good stuff that I think only you n I could muster up and never take any of it seriously. Truely makes me smile clear to my middle all the junk we talked about an did. You are a good man Terry and welcome in my boat any time. Anytime. Ya done good and will not soon be forgotten. Thanks for being my friend on or off the water. The name fits as you really have been "The Ace"on our sweet Vermilion.   Still no fish round my docks but Bonnie, Polar Bear Boy an myself always have enjoyed your company. Yer the best in many ways my friend.  Thanks. Keep on Rocken!   Tommy.       PS.    I will continue to keep the Zombie Horde in check.    ; )
    • chaffmj
      I hope you enjoy your retirement!
    • seifjr
      Keep the reports coming Curt, much appreciated.  Unfortunately, I'm not able to get back up there until September 22-25th., so it going to be tough keeping my mind on work and not LOW.  Are you just moving around in the basin until you mark a school of fish, and then jigging them?  I see all of your waypoints on the screen you showed, so those must be spots that have held fish at one time.
    • guideman
      Hey everybody, I have my last two guide trips on the 22nd and 23rd of August. A bad back and old age have taken their toll and I will retire from a job I have loved to do for the last 27 years.  I still enjoy it but unfortunately my body just can't take the pounding anymore. I'll still be out there fishing but no longer on a daily basis. I will miss all the regular clients I have had over the years and all the new people I have met that I can call my friends. Thanks to all of you that have shared the boat with me over the years, I hope you all had a good time. "Ace"   "It's just fishing man"
    • guitpic
      Bought a couple of baitcaster reels..my first....Lew's BB1 speed spool and Daiwa Tatula CT R. After about two weeks of daily practice casting in the river behind our house....lots of backlashes(birds nests)...I gotta say, I've come to love casting with these reels....much more accurate than my spinning reels. Any other baitcasting fans out there?  If so, what do you use?      
    • rundrave
      dont worry moose we all need a little of aromatherapy to cure that up about this time of the year:
    • BigVwalters
      How's the bite been recently.   Coming up for the weekend and curious at what depths to start at. 
    • RuddyDuck
      On the lighter side, I am 'SpoonBillSlayer' on that other site. For whatever reason years ago when I joined these sites I used two different userids. Both odd duck names that fit an odd duck! I just wanted to get the new updates out on this mess, it just seems like the only people being notified of it are those in  lake assoc's.  We'll see what happens.