Recent content by Porteño

Yes, thanks, my intuition was in that direction, as I titled this post. Adding format in design view solved it. But, how I change that metadata programmatically? this doen's cut it: CurrentDb.TableDefs(tablename).Fields("Startdatum").Format EDIT: I found it :D...

Hi, I just double-clicked on table in object panel (All Access Objects, tables). It just Access imported from Excel and converted by ALTER TABLE, if I converted by design view, everything looks normal.

Hi, it is plain Access. And yes, the number is correct. It is not shown as DATE but shown correctly in the calendar when opening the table. Is there some metadata I can change for proper display? See table open and design view attached

I imported a table from Excel. A filed containing value "01-09-2016" was set to short text datatype. When I go to table->design View and change column to DATE/TIME, the value turns to 1/9/2016, great. but, when I run this: CurrentDb.Execute "ALTER TABLE [mytable] ALTER COLUMN...

Hey, I appreciate your welcoming. Yes, it was a temp table, and removing the first row did the trick. thanks to you all!

Hi! My first interaction with VBA was back in 97 til 2003... It has been ages since I don't touch VBA code, but interestingly I found myself comfortable. But a lot of problems arise and I notice every time a google something Access VBA related I found a tip here, so I decided to join to say hi...