Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hakala

    Office 2013 Not Stacking Icons on Taskbar

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

    Office 2013 Not Stacking Icons on Taskbar

    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/
  3. Hakala

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

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

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

    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/
  5. Hakala

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

    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/
  6. Hakala

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

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

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

    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...
  8. Hakala

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

    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/
  9. Hakala

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

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

    Text Date 20140320 to 3/20/2014 or 03/20/2014 in a Query?

    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...
  11. Hakala

    Access 2007 Importing .csv Text as Numbers?

    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/
  12. Hakala

    Access 2007 Importing .csv Text as Numbers?

    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/
  13. Hakala

    Access 2007 Importing .csv Text as Numbers?

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

    Access 2007 Importing .csv Text as Numbers?

    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/
  15. Hakala

    Access 2007 Importing .csv Text as Numbers?

    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...
  16. Hakala

    Excel 2003 Formats Not Changing

    Hi, Tek-Tippers! I have two Excel sheets and I want to use VLookup to find some values, but it's not working. I found out the format of the lookup cell is not correctly working. Both columns show General format. The Vlookup didn't work so I changed them both to Text, which is actually what the...
  17. Hakala

    Currency Values Aren't Two Decimal Places

    Yet another great tip. Thank you! Michelle Hakala http://www.winebird.com/
  18. Hakala

    Currency Values Aren't Two Decimal Places

    That worked! I didn't know there was a rounding function in Excel. Thanks, Skip! Michelle Hakala http://www.winebird.com/
  19. Hakala

    Currency Values Aren't Two Decimal Places

    Hi, Tek-tippers! I am trying to reconcile a massive currency nightmare in an Excel workbook. However, some of the values I get (there are four sources) are not true currency numbers and have many decimal places, usually in the six to eight range. If I format to currency, of course, it only...
  20. Hakala

    Could Not Update Error

    Hi! I have a split database using Tony's front-end updater, and am still receiving the "Could not update; currently locked" error several times per day. The user base is six but they usually aren't all in it concurrently. I believe I have the table set to no locks, and the front-end is on each...

Part and Inventory Search

Back
Top