Search results

Thank you for your reply, you have given me enough information that I should be able to research the problem. Very helpful.

I'm using an ODBC (read only) connection in an Access 2007 db (2003 format) to a SQL server 2000. I left a 2 table query open for about an hour while I went to a meeting. While gone apparently the application that runs on this server went down and the DBA had to kill my query because it was...

http://www.asap-utilities.com/ download this add-in, use sheets, combine rows it has tons of other really useful tools as well

Checking to see if it had just moved off screen was one of my first checks, maybe it did but I looked everywhere. I uninstalled office 2007, rebooted, reinstalled and rebooted again. The field list was still missing. I checked settings on another computer, looking for any differences and the...

I am working with pivot tables in Excel 2007 and my field list does not appear on screen. If I click the icon to show/hide field list it toggles but the only thing that changes on screen is the words within the pivot frame such as "drop data here" disappear. I have two machines and this is only...

=IF(B2="",A1,B2) Insert a column before the first and use the formula above to fill. Make sure your blank cells are really blank and don't contain spaces.

IIf(Day([call])<17 And Month([call])>1,Month([call])-1,IIf(Day([call])<17 And Month([call])=1,12,Month([call]))) This should work

http://www.asap-utilities.com free download add-in contains this function along with dozens of other helpful short cuts

Thanks for the response, I was afraid code would be the answer. Does anyone know why Excel would give me the option of allowing users to sort then not let it happen?

I have a file that I have password protected, selecting "allow all users to sort" but once protected an error is displayed when using Data Sort or A/Z sort button. Is there a way to allow users to a sort a protected worksheet? Created in Excel 2003 but will be sent to various companies so end...

I've just started using 2003 and had a query give me incomplete results. One table contains 6 numbers stored as text joined to the corresponding code in the data set table. Both fields are formatted as text. When using the table as criteria I do not get all of the expected records, I had to...

Looks like this should work, thanks a million!

I'm sending out an Excel workbook to get information and want to force respondents to answer the legal questions before they see the rest of the information. I will send it out with all other tabs hidden but as soon as they answer Yes or No to 17 legal questions I want the tabs visible. Each...

I have a spreadsheet with quite a few cells that have validation. This was put in via the data validation dialogue box rather than refering to a range. Is there any way to print out all of the choices?

Thank you both, the ~* works! I tried substitute but couldn't figure out how to nest it, I want to strip out all non alpha characters.

Is there a way to write a function to replace Asterisk "*" without wiping out all characters? I tried using Chr(42) and it still cleared out everything in my selection. Thanks, any help will be appreciated.

thanks so much, I had tried various combinations of upper but not this one. I works!

Your formula is 318 characters including spaces, Excel doesn't like to evaluate that many. Try a vlookup to get your varable. It looks like you are only using N or M+N or L+M+N. Try an simplifying your if statement. You should only have three choices. Use an Or statement...

I need to know how to create a custom date format so the date is DD MMM YYYY with the MMM being all caps. I can do the basic DD MMM YYYY but the three letter month is in proper case. How do I force Excel to show my month abbreviation in all caps? Help would be appreciated, this is for a...

Thanks, that was the answer I thought I'd get. It would sure be nice to know more detail but I guess this is one that is what it is.