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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. glyrocks

    batch script to list files and sizes

    Right on, I'll check into that. I jumped on a .bat just because it was the first thing I thought of... Your script gets us plenty close, thanks again! dylan
  2. glyrocks

    batch script to list files and sizes

    Huh, well that's cool! I have a vague idea of how it's doing that, but there are a few things in there I'm clueless on. I really appreciate the code. One thing I didn't specify clearly is how the ROOT should actually display. We don't need it to return the path all the way back to the...
  3. glyrocks

    batch script to list files and sizes

    Hello all, I'm in need of some batch script help. I need to create a formatted text file that looks like this: ROOT l_comm_info.e00 3,939 l_mt1_lomc.e00 7,985 ROOT/SUBFOLDER1/ l_stn_start.e00 2,677 l_wtr_nm.e00 8,845 study_info.e00 4,608 ROOT/SUBFOLDER2/ s_base_index.e00...
  4. glyrocks

    Excel2003: change query DB

    Brilliant! I think I can take it from there. Thanks a ton, I would never have thought of that! dylan
  5. glyrocks

    Excel2003: change query DB

    I've built a spreadsheet we're using as a template to track certain things in a Access database. Using the Import External Data, I set up a simple query using a test database. Everything returns fine, all my calculations do what I want. But now I want to duplicate the template, keeping my...
  6. glyrocks

    Excel2003: Import External Data and formatting/sorting

    Background: I've got a single spreadsheet I'm using to track changes to certain fields in 7 separate Access databases. So, I have 7 DB queries using the Get External Data... tool dumping into a single sheet. The tables and fields have the same names and data types in each database. I've got...
  7. glyrocks

    loop macro from userform

    It is all one continuous table, but I don't want to format it all at once. There are a couple of nuances with the data and formatting that the user needs to watch for. So, by giving them a form to specify how many times to repeat something, they can stop and adjust things as needed. dylan
  8. glyrocks

    loop macro from userform

    It isn't looping through each row, rather repeating a set of formatting instructions. The table runs anywhere from 20 to 150 pages so I needed a way for users to tell the macro how many pages to format. Counting the number of rows could be useful though. dylan
  9. glyrocks

    loop macro from userform

    Thanks for the quick responses but I found a solution. I was trying to declare a variable in the form, and then use that variable in the macro. Instead, I just pulled the variable from within the macro: rows = UserForm1.TextBox1.Value thanks again! dylan
  10. glyrocks

    loop macro from userform

    I've got a handful of macros in Word 2003 that format table rows. I can get them to loop x number of times no problem, but only if I hard code it in the macro. What I had envisioned was a userform popping up that would ask how many times to run the macro, user enters a number in a text box...
  11. glyrocks

    Select statement built from combo box

    thanks, appreciate the help dylan
  12. glyrocks

    Select statement built from combo box

    Thanks, PHV- that fixed it. I appreciate the quick response. Can you-or anyone else--explain what the difference is? Why the 's' was wrong in my case, but didn't throw a syntax/compile error? Remou- you are correct, that code only works for one particular situation. I was hoping to get one...
  13. glyrocks

    Select statement built from combo box

    I'm trying to create a simple form that builds a select statement based on two comboboxes. I was following a tutorial online, but have gotten stuck. I think I have the combobox and variables set up correctly, but I'm new to this whole coding thing and am not sure what needs to happen next...
  14. glyrocks

    In the pdf format, the font size in the report has been reduced

    I haven't been exporting to PDFs, but I have been working with exports to Word (rtf). It seems that the fonts end up about a half pt smaller in Word. We have to use Helvetica, so I don't know if this affects other font faces as well. Don't know if that helps you any, but at least you're not...
  15. glyrocks

    Word 2003: overlap page footer with body

    Cool, I will play with that and see what comes of it! Thanks a lot! dylan
  16. glyrocks

    Word 2003: overlap page footer with body

    Interesting... how do I add a "frame in the page footer" ? Thanks, dylan
  17. glyrocks

    Word 2003: Table headers and footers

    a little messy" only begins to describe these tables. I had the whole thing dialed and ready to go by creating these tables in Crystal Reports. But the client doesn't like the output... Crystal Reports exports to text format Word can read/edit, but it doesn't create rows and columns- just...
  18. glyrocks

    Word 2003: overlap page footer with body

    The other thread was more about finding any workaround for the general problem of not being able to create a 'table footer' in the same way you can create a table header. Here, I have one possible workaround I need further help on- overlapping the footer with the body. You're correct: what I...
  19. glyrocks

    Word 2003: Table headers and footers

    WHAT would be the "last" row o[f] a table that can have any number of rows?" Seems like you could establish that the same way you establish which rows you want to repeat as a header: highlight them, Table > Repeat as Footer. Word would know which row because you told it which one, and it could...
  20. glyrocks

    Word 2003: overlap page footer with body

    For reasons explained in another thread, I need to overlap the page footer with the page body. I tried setting the page margin to something very low (0.5cm) and set the footer to start 3.2cm from the edge. Seems to me, that would cause the two to overlap. Any ideas? Thanks, dylan

Part and Inventory Search

Back
Top