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 Rhinorhino 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: srogers
  • Content: Threads
  • Order by date
  1. srogers

    menu steps to export to Excel CR ver 8.5

    Hi - I have gone through all the menu items and can't find any options to export. I went to the Business Objects support site and found articles about exporting but none so simple as how to get started. Is exporting possible in Crystal Reports 8.5 and if so, what are the steps to get there...
  2. srogers

    Excel - get left 8 digits including preceeding zero

    I have a list of numbers in varying length(less than 9 digits). What I want is to add preceeding zeros to make each number 9 digits long. Then I want to take only the left 8 digits and sort the numbers by the last two digits. I can add preceeding zeros with a custom format but then when I use...
  3. srogers

    Excel formula to create new column of codes

    I have 4 columns with about 13,000 rows. Col A Col B Col AK Col AN 10020 122.4 10020 10020 26 112 10021 10021 24.5 10022 10021 26 12.94 10023 10022 45.6 10024 J0270 K1254 Columns A, B and AN are codes and column AK is fees. The...
  4. srogers

    need terminal digit sort

    Does anyone have an idea on how to sort numbers in terminal digit sort? That's where you sort a list of numbers by the last two digits and then the two before that and then the two before that as in the example below: 123498 123598 123698 123499 123599 There will be 6 or 7 digits in the...
  5. srogers

    Need Query to get first 147 fields

    Is there a way to do a select statement to get the first 147 fields of a table (and then another one for the second 147 fields) without typing all the field names? I'm importing them into Excel with DTS and can't do it all at once since Excel limits me to 256 columns. It would also be ok if I...
  6. srogers

    PowerPoint, .wma file plays on Win2000 but not XP

    I inserted a .wma file in PowerPoint on my Win2000 machine and then saved it with Pack and Go and the Viewer. I unpacked it and burned all the files to a CD. It plays fine on all my 2000 machines at home. The machine I'm making it for is an XP. Once I was able to go to the XP machine and test...
  7. srogers

    Excel - duplex not consistent

    I was having a problem getting some sheets (several sheets selected at once) to duplex print on a consistent basis. I have asked about this before and got a fix for it as seen in this: thread68-829039 I think my user keeps switching printers (trying to get multiple things done at once) and...
  8. srogers

    Excel - need syntax for deleting the last row.

    I'm successfully finding the last row - at least that's what the MsgBox tells me. The problem is that the first row is being deleted instead of the 31st row (which it is finding). Sub testDelete() Dim LastRow As Long LastRow = ActiveSheet.Cells.Find(What:="*", SearchDirection:=xlPrevious...
  9. srogers

    Excel - want to "Bold" the row.

    In an Excel 2000 application I gave the user a button to click when they are ready to total the section they are working on (I use a Case statement for placement of the formulas. An array is also involved because I am adding this Total row to each of 15 sheets in the workbook). The formula part...
  10. srogers

    Count with criteria

    I have a report grouped by Equipment Type and it is based on a query involving 3 tables. I want to count Field A if it equals 15. Field A is a text field and I don't want to group by it. Is there a formula I can put in the report footer that will work? I tried =Count[FieldA]='15' But it...
  11. srogers

    Want a different column to display

    On my report the ID (key) is displaying but I want the other column, the names. In my table when I click on the field it shows that it is a lookup and it uses a combobox for it's display control. When I created the form it displays correctly, showing me names of items and not the autonumber...
  12. srogers

    Control can't be edited - bound to an AutoNumber Field

    I have a form bound to a query. One table in the query has an autonumber CategoryID and a text category name. A combo box on the form displays the choices in the table when you click the drop-down arrow. But when you click on one of the choices I get an error that says "Control can't be...
  13. srogers

    What is Me?

    I'm coming back to Access after a long absence and I can't remember what Me is - as in: me.Whatever.Visible=False Is it the active object? Like a form? or the control with the focus? Thanks -
  14. srogers

    Excel - Open file dialog box - can I go to a certain directory?

    Oops - I had another question too. I use this to open the Open File dialog box: sFilename = Application.GetOpenFilename("All files (*.xls*), *.xlt*") But now I've had someone ask if I open it with the right drive letter and folder. Can that be done? Thank you -
  15. srogers

    Excel - close and save inactive workbooks

    In the process of running some reports the user may end up with 3 workbooks open. I'm saving my active workbook fine and closing it with application.quit. Sometimes the other files close if there were no changes, but if there were any changes a dialog box opens asking them if they want to...
  16. srogers

    Excel - can't duplex print

    Any ideas why my document is printing on one side of the page only? The duplex option is already checked each time I try to print but it doesn't actually duplex print. I am selecting all the sheets and trying to print the same area on each sheet. Does duplex not work when you select all the...
  17. srogers

    Excel - adding a function, if necessary

    On a worksheet I display the week number (periods are broken down into weeks - most have 4 but every once-in-a-while period 13 has 5 weeks). What I need to do before I fill that sheet with new data is look at that week number and decide what the next week number should be. That is easy for...
  18. srogers

    Excel number format

    In Lotus 1-2-3 the number 32.8650 displays as 32.86 when I format it to two decimal places. But in Excel that same number is displaying as 32.87. Is that controlled by some setting I can change in Excel or is it just that the two applications round differently? Thank you.
  19. srogers

    Excel - need to name a range that will not move.

    Has anyone used the Indirect function to define a range so that it won't move when rows are added or deleted? I want to define the range B22:X22 and I want it to stay that range even though they will be inserting rows and deleting them. That's my only idea - maybe there's another way? Thank you -
  20. srogers

    Excel Print same area on several sheets

    I'm close to what I want but print preview shows it will only print the cell on each sheet where my cursor is sitting. Here's what I have: Sub PrintSalesLabor() Dim vArrSh As Variant Dim sh As Long vArrSh = Array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O") For...

Part and Inventory Search

Back
Top