Recent content by Hakala

That's it! No wonder I couldn't find it in Office.... Sigh. Michelle Hakala http://www.winebird.com/

Is this a functionality that is no longer available? When I open several Excel files, they each open a separate instance of Excel. I'd like them "stacked" to conserve Taskbar space. Does anyone know which setting this is, if it is one? Thanks! Michelle Hakala http://www.winebird.com/

I will, thank you! Michelle Hakala http://www.winebird.com/

Got it! I removed the reference to that .dll and now both PHV's and Andy's answers work. Thank you all so much! Michelle Hakala http://www.winebird.com/

It can be a text string and just look like a date; that's fine. I get a missing reference error on the above, so that may be my issue. "Missing or broken reference to the file 'OWC10.DLL' version 1.2." Sigh. Michelle Hakala http://www.winebird.com/

Native. Text field, 20140320. Michelle Hakala http://www.winebird.com/

SELECT Peak.QI_DATE, DateSerial(Left([QI_DATE],4),Mid([QI_DATE],5,2),Right([QI_DATE],2)) AS DateConverted FROM Peak; I'm just trying to get it to work, so only using the field I have and one other to get a conversion. I'm also willing to do it as a make-table. Michelle Hakala...

I don't know how to run that code by itself. This is why I wanted to be able to change the format in a query. Sorry.... Michelle Hakala http://www.winebird.com/

It says "Undefined function "Left" in expression. :-( Michelle Hakala http://www.winebird.com/

Hi, Tek-Tippers! I'm trying to format a text date that comes to me as 20140320 to either be a date or look like a date (I don't care which). I've searched this forum and see the CDate function but my Access 2010 doesn't recognize the commands. Either I'm using the wrong commands or I'm using it...

I'm not importing Excel. It's a .csv and the Excel wizard doesn't even see the file. :-( Michelle Hakala http://www.winebird.com/

I am importing into an existing table and those fields are text. Could my old Access 2003 tables be the issue? Michelle Hakala http://www.winebird.com/

The import text wizard, just like I was doing in Access 2003. Michelle Hakala http://www.winebird.com/

There isn't a saved import spec and while trying to build one I am not allowed to add the data type. Only fieldname and skip Y/N are showing up. Adding this spec doesn't change the results - the columns are still importing as numbers. Michelle Hakala http://www.winebird.com/

Hi, Tek-Tippers! My Access 2007 database insists on importing text columns from a .csv import as numbers, causing much of my import to fail. I have tried creating a specification file but I'm only allowed fieldname and skip Y/N. I've never seen this limitation before. The table I'm importing to...