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: *

  • Users: Hakala
  • Content: Threads
  • Order by date
  1. 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/
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. Hakala

    Excel Graph - Don't Show Zeroes

    Hi! I have an Excel graph and the line plummets to the bottom of the graph wherever there is a zero. Is there a way to get Excel to ignore the zeroes in the data without changing the data itself? Thanks! Michelle Hakala http://www.winebird.com/
  8. Hakala

    Excel IsBlank Opposite?

    Hi, Tek-tippers! I'm looking for the opposite to the =IF(ISBLANK(B1) Excel formula.... I want my conditional formatting to kick in if cell B1 is NOT blank. I have no control over the value that will be put in cell B1; I just want to trigger a color change in another cell if B1 is full. This is...
  9. Hakala

    Excel 2003 VLOOKUP Failing

    Hi, Tek-Tippers! For some reason, VLOOKUP in Excel 2003 is giving me #N/A when I can see the matching value right there next to it. I have a list of File IDs which are numerical but have a General Format in Excel, since we aren't adding them together or anything else mathematical. Each one is...
  10. Hakala

    Excel Cell Linking Not Updating

    Hi, Tek-tippers! I have a rather large workbook in Excel 2003 and suddenly the links and their associated math aren't updating when I add data. For instance: Cell CJ5 = the value of Cell CE9 (the previous day's ending inventory) Cell CJ6 = incoming inventory today (typed) Cell CJ7 = inventory...
  11. Hakala

    Convert Number To Negative Based on Another Field's Value?

    Hi, Tek-Tippers! I have a subform which I want to show me a running sum (great FAQ on that!), but the original number needs to be a negative. I would rather not have to type it as a negative, since I won't always be the one data-entering. If the status of the first line is "Received" I want to...
  12. Hakala

    Way To Do Projections?

    Hi, Tek-Tippers! I've been tasked with creating an Access database to hold correspondence inventory and production numbers. That part is pretty easy, but Management also wants the ability to look at projections. For instance, we expect to get 100 pieces of correspondence inventory (letters from...
  13. Hakala

    Limited Time Use?

    Hi, Tek-Tippers! Does anyone know a way to cripple a database after a set amount of time? I'm having an issue with my user pool saving design copies of a database and running production from them. Since these are DESIGN copies, they aren't complete and in some cases what they "think" is...
  14. Hakala

    Excel w/Essbase, Lost Right-Click Menus?

    Hi, Tek-Tippers! My boss recently got an Essbase add-in for Excel (we're running Office 2003) and now her right-click shortcut menus won't work. Any idea how I can bring them back for her? This is when you right-click in a cell and the Cut, Copy, Comments, etc menu shows up... hers doesn't...
  15. Hakala

    Fix Autodate in Excel?

    Hi, Tek-Tippers! I have a worksheet in Excel 2002 which has a date field that autofills with today's date. We use this as a form, and the users were often forgetting to update the date, so we autofilled it. The trouble is, it autofills every time the sheet is opened. What I need is a sheet...
  16. Hakala

    Excel Fix Auto Date

    Hi, Tek-Tippers! I have a worksheet in Excel 2002 which has a date field that autofills with today's date. We use this as a form, and the users were often forgetting to update the date, so we autofilled it. The trouble is, it autofills every time the sheet is opened. What I need is a sheet...
  17. Hakala

    Excel 2002 Conditional Formatting Questions

    Hi, Tek-Tippers! I'm trying to get conditional formatting to work based on: * Cell value is some specific text, such as "New Hire" and (different cell, different formula) * Cell has nothing in it I'm having trouble tracking down what the formulas should be. I know...
  18. Hakala

    Excel Find Data Problem

    Hi, Tek-tippers! I've been asked if I can create "a button or something" to allow our tech writer to check a long Excel file. He wants to know: Is any of the text in cell A1 in any cell in Column B? Is any of the text in cell A2 in any cell in Column B? and so on. So I guess he's looking for...
  19. Hakala

    Outlook Autofill Subject Line?

    Hi, Tek-tippers! We now have to use secure email in our office and our customer service department would like their Outlook (MS Outlook 2002) to automatically put the secure email tag in every email. So when they create an email, the subject line would already say SECURED: in the subject...
  20. Hakala

    Save a Record Without Moving To a New One?

    Good morning, Tek-Tippers! I have a multi-user Access 2002 database. One of the data entry forms is locking the records for other users, even though all the settings I can find to check are right (No Locks, etc). I'd like to add a Save Record button for that form, which would save the record...

Part and Inventory Search

Back
Top