Search results for query: *

I have an Access database in which I have created a select query. I now want to disply the results of the query in a form. How do I display the results of a query in a form?

I have a spreadsheet with two columns of information. The first column contains an account number which is fine. The second column contains an address, which is unformatted. Some of the addresses start with a comma, so for example it may start ", 25 Harlow Avenue, ". Other addresses may start as...

I have a spreadsheet with two columns of information. The first column contains an account number which is fine. The second column contains an address, which is unformatted. Some of the addresses start with a comma, so for example it may start ", 25 Harlow Avenue, ". Other addresses may start as...

I have an Excel spreadsheet into which Users will enter data. I have a column which will be populated with phone numbers. I want to be able to restrict users to only entering numbers into this column and not allow alphabetical entries (a,b,c, etc.). Is there any way to do this?

I have created a new database with 5 tables. I now want to add a sixth table to the database. I am trying to import it as an ODBC data source. However, it gets part way through importing the table into Access before coming up with the error 'Invalid Argument - Error 3001'. I have tried...

I have a cross tab. This has the period in the row and a percentage formula as the column. This in itself works absolutely fine. However, when I add a second percentage field to the cross tab and put it in as a second row, rather than giving me one figure per period, it splits it into 2 or 3...

I have a spreadsheet where the user has a client code and a client name. He has filled in the first cell, for example client code 123 client name ABC. He then wants to have this client information in the next few rows. When he drags it down the client name remains ABC but the client code...

I have a report I've built in Desktop Inelligence which works absolutely fine when run in Desktop Intelligence. I exported it to the repository and scheduled it to run monthly on Enterprise. However, when it ran on Enterprise I found that most of the information on the report was missing. Is...

I have a report in Business Objects XIR2 and I'm trying to create a variable to insert into the report using the Where operator. To start with, I created the following variable called "Months Between":- = If (MonthsBetween(<Take On Date> ,CurrentDate()))>25 Then 1 Else 0 No problem with this...

I have a report broken down by a group called "range group" and then within this by a take on period. The report shows new business by take on period for each group, payments after month 1, month 2, etc for each take on period and the payments as a percentage of the new business. Part of each...

I'm unable to view the menu toolbar (File, Edit, Insert, etc.) in Desktop Intelligence. Does anyone know hoe to unhide it or make it visible again??

I have a Desktop Intelligence report which is spread over 12 pages. Page 1 has information on it, page 2 is blank, page 3 has information on it and so on. All the odd page numbers have information, all the even ones are blank. Is there any way to avoid this or any way to hide blank pages?

I am trying to create a simple report in Desktop Intelligence to bring back all account numbers where the customer name starts with a 1 (accidentally overwritten). I know in Crystal reports you would use "customer name startswith "1"", but how do I do this in a Desktop Intelligence query?

I have a geographic map of the UK in Crystal reports XI to show some holdings figures by region of the country. I have a function which splits out the accounts on our system into various regions of the UK. Unfortunately some of the regions I have in this function didn't match to the regions...

I have a report set up to run weekly on BOXI R2 to be emailed to about 15 people. Most people on the distribution list receive the report, however there are one or two who don't. Also, when the report is sent out and you look at the "To:" field on the email, it's cut the recipient addresses off...

I am trying to write a bit of code in Visual Basic. I have a spreadsheet where cell F13 will be the User Name and cell N13 will be a date field to show the date they need their request completing. What I need to do in my code, is say when cell F13 is blank give a default date of 01/01/2010. When...

I am trying to write a bit of code in Visual Basic. I have a spreadsheet where cell F13 will be the User Name and cell N13 will be a date field to show the date they need their request completing. What I need to do in my code, is say when cell F13 is blank give a default date of 01/01/2010. When...

I have a spreadsheet for users to use and one of the cells requires users to input a date in format dd/mm/yyyy. I want to be able to check that a valid date has been input before the file is saved or closed. I have gone into Visual Basic and used the BeforeClose and BeforeSave. I have tried...

I have a user who is logging onto BOXI V2. When she selects a report and view latest instance she can still see the folder tree on the left of the screen and she can see the drill down options in the middle of the screen but the where the actual report should be all she can see is a black...

I have a custom function in Crystal XI which I've copied from Visual Basic. I've selected the basic syntax in Crystal. It works fine apart from one part where it's coming up with an error message - it says the isnull function cannot be used within a custom function. Does anyone know a way round...