Search results for query: *

Am receiving the error message "Default value or value provided for the report parameter is not a valid value" when attempting to save a data driven subscription when choosing to make the reports parameter based on a field returned by the recipient list query for the subscription. If I choose...

When I go to insert an image onto my Access 2003 form, I am unable to choose Jpeg images. In the file type filter list box at the bottom of the select file screen, there is no listing for Jpeg files. I only get a limited selection including WMF, BMP etc. But no Jpeg or GIF. This only happens...

I think this issue may be addressed in a patch. Have you tried looking at the online Business Objects knowledge base or logging a call with them?

Is the user using a measure object which is defined in the universe using an SQL aggregate function such as sum,avg,max or min? BOE will only generate grouping SQL if such a measure object is used in the query.

I have an Access app I want to distribute to users. Problem is they could put it in any location and my app uses linked tables to two different back end mdbs. The structure will always be the same with the client in the root folder and the back ends in a data folder one level higher. I need a...

lichter, here's a direct link to the document: http://www.adobe.com/support/techdocs/2aab6.htm

I have only tested the 5.05 patch with test documents so far but it seems to work. Sometimes however, you need to re-apply the "Embed tags in PDF" option in Conversion Settings under the Acrobat menu. That option is supposed to be ticked but I found that even if it was ticked the...

Yes ETID, the 5.05 update resolved the issue for us.

Sorry lichter, no resolution as yet. We have reverted to using Acrobat 4.

If someone else has created a view in Oracle, how can I find out how it was put together? Specifically, I want to know what was the SQL statement used as the basis for the view or failing that, what tables each of the fields in the view comes from. Using the describe command gives me the fields...

I have two tables. One containing records of training qualifications staff have received with a structure like: StaffID | QualiicationID 1 | 1 1 | 2 1 | 26 2 | 1 2 | 2 3 | 1 And another showing the qualifications required to be eligible for a certain...

That was in fact the original way the application worked except that the users had to select the range manually and name it. Then they pressed a button on an Access form to import the data. I wanted to give the users a solution which would allow them to just use the Access application and not...

Yes! That did the trick. But how did you find out what values to use in place of those constants?

Thanks for the tips Rob, The code you gace me still has the same problem as mine though... When it gets to the line where it assigns the variable sRange the value .range(cell,cell.end(xltoright).end(xldown)).address it doesn't do it properly and I end up with a blank message box. I know the...

No, it still returns the same address as range1. I have narrowed down the problem however. The code seems to be ignoring the lines: ActiveCell.End(xlToRight).Select 'Go to the far right of the data ActiveCell.End(xlDown).Select 'Go to the bottom of the data I know this because I added the...

I have an Excel worksheet which has data I'd like to import into Access. Problem is that the data starts at around row 900 with the top part being filled with statistics on the data below. So... I wrote a nifty little Excel macro to parse through the file until it gets to the top left cell of...

Thanks Mike, The idea of xlUping from the 65000th row and looping to it from row 2 was just the clue I needed to make my macro work.

I'm an Access VBA programmer but have recently been asked to write Excel macros and I am lost. If I have the following data in a worksheet: A B C 1 #1 #2 Tot 2 10 40 3 49 45 4 36 10 5 75 23 How can I write a macro that will 1. add the "tot" column to the worksheet and then add a...

Thanks Goramn. you post has helped me. I still find it puzzling that truncate doesn't work though because according to the documentation it's supposed to get rid of decimal places. DGillz, your idea is good, however, I have many numbers of different lengths in my tables so dividing by 10000...

I have two number fields which I need to concatenate and I want to do this via a formula. It needs to work thus: <number 1>.<number 2> However, when I make a formula to do this it puts 2 decimal places at the end of each number so I end up with something like this &quot;99.00.3,499.00&quot...