Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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 -

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 -

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

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

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

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.

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 -

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