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

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  



  • Posts

    • Wanderer
      A boat and trailer are two separate pieces of equipment.  The trailer is titled and the boat isn’t.  You can have one and not the other for any amount of reasons. The wheelhouse is one item and titled, hence the plate.  Shelter tags primary purpose (besides raising money) is to officially verify who is responsible for it.  You can do that with a plate number. Is what it is.  But I’ve just been having more difficulties considering the license fees as just another drop in the bucket.  If ALL the money was used for managing wildlife and habitat I’d have an easier time with it.
    • JFitz
      We caught em between 17' and 27' off a shoreline point. Definitely had more action in our shallower holes though.
    • Snuffy
    • JFitz
      Got out today on Niles Bay. We had 4.5" to 6" of good clear ice. Only one walleye between the two of us but the tullibee and whitefish were on a tear. Even got a nice bonus pike! Hoping to dial in the walleyes over the next couple days.
    • huntercj
      First ice fishing trip today out of morson ontario .  Fishing  was a little slow got a few walleyes and a couple of crappies . Lost what little  snow we had today made the ice really  slippery. Found 9 to 11 inches of ice.
    • leech~~
      Dang Curt, did you take my suggestion on a drone?  Great report. 
    • curt quesnell
    • DRAGFOOT
      Well, I have to pay for registration on my boat trailer to run it on the road, and the boat to run it on the lake, why shouldn't wheel houses?  I guess I don't feel bad for the wheel house guys.
    • Bryan P
      No not yesterday. 2 weeks ago when we had that first cold spell I went out on Baxter, Blue and Long and checked the ice. They were locked up but only had 1-2" inches so didn't venture out too far. Baxter probably was walkable but had open water on the back end so figured I stay off. Last Sunday I went and checked them out after that warm rainy week we had and they had open water, so yesterday I skipped checking them and went farther north. But I did notice most lakes were locked up on the drive up there. Cant wait for the local lakes to get some decent ice! 
    • JMP_37
      Wondering if big sandy is clear enough to spear fish when the ice comes on? Never done it before and would like to give it a try