Search results for query: *

I would like to print out one of my Export Specification templates to give to someone. The Help text says they are stored in the database under Filename_ExportSpecification. I cannot find a way to access those files to print them out. Is it possible? (I don't want to send them my whole...

Success! This solution worked perfectly, and I thank all of you so much for your expertise in helping me solve this. You're the best!!!!!

...to use this on more than one field of the query? Here are the two fields I've set up in the query: FormatedField:Right("00000000000" & ([Field34]*100),11) and FormatedField:Right("00000000000" & ([Cost Center Total]*100),11) These two fields are in separate tables, if that makes a...

Hi, how do I make a calculated field in a query retain the display format I've chosen for it (000000000) when the field is exported? The field is a dollars and cents field, 5.54 for example, that I've created an expression field for which multiplies the value in the table by 100 (to strip the...

Thanks so much, that should do the trick.

I'm using nested vlookup functions like this: =Sum(vlookup(a2,range1,2,false)+vlookup(a2,range2,2,false)-vlookup(a2,range3,2,false)) and in some cells I'm getting only #N/A because one of the ranges (it could be any of the three) doesn't have an exact match to A2 in it. How can I make the...

Your suggestion worked great! Thanks so much!

I have a CSS style I'm using for a particular area of my web page and I don't want it to use the link color defined in Page Properties. How can I attach a diffent link style to that section? Thanks for any suggestions.

BillyRay, Thanks so much for the tip! The link for the smooth banner gave me exactly what I needed. thanks again, bac2u

Hi, I've seen this on many different web pages where some text scrolls like a marquee banner. how do you do that in dreamweaver?

Thanks to both of you for your tips. Using the % on the width did the trick. I'm using just CSS for this web site, I'm a novice and have never used tables and don't know how to write the code, but I've saved your suggestion, ArkM, because it helps me understand what's going on underneath...

Hi, I'm trying to set up a CSS with a position that is in the center of the page no matter how large the browser window is. I know how to set a banner that goes across the entire page no matter how wide the browser window is, but in this case I don't want the text and graphics inside the CSS...

Thanks for the tip. I had to do it a different way by going into Frontpage and saving as html a blank page with just the background I wanted on it. It opened fine in Dreamweaver. But I saved your tip for another use! Thanks again!

Hi, I want my page to have a textured background not just a solid color. similar to what I see folks who've done web pages in Front Page. Is my only choice for background in Dreamweaver just color, or are there page textures that I can pick from or somehow import into dreamweaver. Should I...

it's 5. here it is all together: Sub Macro1() i = 5 Do While i < 4610 If Cells(i, 5) <> "" Then Cells(i + 1, 5) = Cells(i, 5) i = i + 1 End If i = i + 1 Loop End Sub

Hey! It worked! I just had to change your cell statements around to be: cells(i,columnNo) cells(i+1, columnNo)= cells(i,columnNo) Thanks!!!

Hi, this is what I recorded, then put your code in: It doesn't work. I'm trying to copy every non-blank cell in column E to the blank cell below it. I'm missing something, obviously, how to imbed the copy statement around what you gave me. Please help! Sub Macro1() ' ' Macro1 Macro ' Macro...

Hi, I need a macro to copy the contents of every non-blank cell in a column to the cell below the non-blank cell, then go to the next non-blank cell and repeat the process. There are about 8,000 rows in the column. Thanks in advance for help. I can use the macro recorder but can't get it to...

Yes, I suppose you're right. I always forget that macros in Excel are never Excel, they're VB. I hate that! I'm old enough to remember Lotus and how easy it was to write macros, even looping macros, without being a programmer. Anyway, thanks again for your suggestion. It should work. Barb

Hi Skip and Ken -- sorry for delay in responding, I was out for a while... Anyway, Skip's way will work, great suggestion!! But I'm sure there's a way to do this in a macro too. Here's a sample of the data: I need to get rid of those banner rows whenever a page break occurs. It's actually 9...