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!

  • Congratulations bkrike 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: bac2u
  • Content: Threads
  • Order by date
  1. bac2u

    Access - Export Specifications

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

    Query Export formatting problem

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

    vlookup returning #N/A

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

    Link color

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

    text that scrolls like a marquee

    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?
  6. bac2u

    Centering a style no matter how wide a browser window is

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

    page background texture

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

    Excel 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...
  9. bac2u

    Excel Macro

    I need to remove the banner rows on a print file I imported into Excel. Every 63 rows, there are 9 rows of banner stuff I need to get rid of. The spreadsheet is about 8,000 rows big. I know I should be able to use a macro but am not familiar enough to do it. I can't sort the spreadsheet to...
  10. bac2u

    entering a number in user Input Box

    I am trying to incorporate a user input box in a VB script. The input has to be a number, not a string, in order for the application to accept the data into the field from the user input. This is what I have: ----------------------------------------------------------- Sub Main ' Generated by...
  11. bac2u

    How to get InputBox to accept a number as a number not a string

    I'm really stupid at this, but I'm trying to do a VB macro in Emulator software (Reflections) and the thing compiles and seems to work okay except for one little thing. It doesn't put the user's input data that is prompted by the InputBox into the application I'm running the macro in. The...
  12. bac2u

    how to repeat (loop) a macro statement

    HI, Using relative cell references I've created a macro using the macro recorder, where beginning at cell A1 I copy the contents of A1 to the nine blank cells below it (so I end up with A1:A10 containing the same data. The data changes in every 10th cell of column A, and at each of those...
  13. bac2u

    How to make ActiveCell.Range selection be an end down

    Hi, I'm just trying to do a simple macro in Excel where I want to use Shift End Down to get to the next non-blank cell, and then do a copy function of that cell to the range of non-blank cells below it. The number of blank cells varies between the non-blank cells. Even though I use relative...

Part and Inventory Search

Back
Top