Search results for query: *

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/

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

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

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

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

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

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/

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

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

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

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

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

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

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

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

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

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

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

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

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