Search results for query: *

Hi Boris, I am trying to install sqlexpress 2005 on a non-networked Vista laptop. There didn't appear to be any errors during the installation, but it doesn't look as if there is an instance running, so I can't connect to anything other than the mysterious 'SQL Server Compact Edition'. Do I...

Skip, I was truly importing data - just never noticed that option. You're a star. h

Hi, I'm having problems importing a delimited file (c10k rows) into Excel 2003. Below is a simple example using the pipe as a delimiter (you can guess this data comes from a mainframe report). 003.1270|aaa|bbb |12.00 AA|AAA|BBB|17 I formatted all cells as text prior to the import. The issue...

Hi, I'm using Word2003. Is there any way of viewing only changes made on a certain date? I've tried to save a changed document as a new version, but when I look at the changes I see ALL changes made rather than just the changes made in the latest version.

Dear STU1979, Your original posting said you wanted the same table at the start and end of the document. If the table formats are different you could still do the table copy and paste and record a macro to reformat the second table.

How about select table, edit copy, edit paste? How long can this take?

Hi, put the department in the row and data areas. In the data area set the function to COUNT of departments. hth Henio

Hi, try creating a pivot table - your subtotals will all appear together. Henio

Hi shteev, if your summary sheet contains lots of SUM functions, replace them with SUBTOTALs. These will sum, count, etc whatever you have filtered. hth henio

Thanks Patrik, you deserve a star. Regards, henio

I agree with all the comments about 'password protection' but still use it to stop people with even less knowledge than me from tinkering, getting the wrong answers and blaming me to other people!!! On a related issue, many of my macros run a query to extract data from a host database, and then...

Hi 01Patrik, I normally use the technique you suggest with no problems. I just tried something different and ran into this situation. I'm just curious... henio

Hi all, I have created a custom toolbar with two buttons which run a couple of macros. It works fine for me but when I email the file to colleagues, they don't see the toolbar. It doesn't appear on the list of toolbars available. I've searched for information about this and just got...

Hi, you need to use the INDEX and MATCH functions. eg sheet1 colA ID Acct Amnt 10 100 =index(=INDEX(Sheet2!$A$1:$D$2,MATCH(Sheet1!A2,Sheet2!A:A,0),MATCH(Sheet1!B2,Sheet2!$A$1:$D$1,0)) will return 1 sheet2 colA ID 100 200 300 10...

Hi, Thanks to all of you for replying. I tried Combo's solution first so s(he) gets my star. There seem to be so many ways of doing anything - I need to buy a good VBA book... Cheers Henio

Hi, I have this code to initialise a label on a splash screen. Private Sub UserForm_Initialize() Label1.Caption = Environ("username") End Sub This can give me fred.flintstone or barney.rubble (says something aabout where I'm working!). How can I extract the first name? Cheers, Henio

Hi Ken, actually I found out the hard way and should have posted the fact! However, I found a helpful tutorial at http://www.solver.com/stepbystep.htm which walks you through an interesting scenario and explains what you can do with the tool, which is something the 'help' facility doesn't...

Hi, this faq looks interesting - I've never tried to use Solver before. So, I've followed the instructions as given and get the error message Binary constraint Cell Reference must include only Adjustable Cells. As it is unlikely that KenWright's faq is wrong, does anyone have any ideas about...

Makeitso, the WHERE clause links the tables, and yes, there are matching fields which are used in the WHERE clause. I just don't understand how to force MSQuery to subtotal on a particular field. Cheers, Henio

OK, my original posting contained a cut-down query for the sake of clarity. I've merged the responses in with another query and I now get the wrong answer :-( I pasted this into MSQuery: SELECT PKT_HDR.STORE_NBR, PKT_HDR.SHIPTO_NAME, PKT_HDR.STORE_TYPE, CARTON_HDR.CARTON_TYPE...