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 derfloh 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: Matt27
  • Order by date
  1. Matt27

    Link query results to a form

    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?
  2. Matt27

    Address information in Excel

    I believe this is how we're going to receive the information and it's being left to myself to clean it up. I'm not sure what application it's coming from, but it is coming from another company.
  3. Matt27

    Formatting an address

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

    Address information in Excel

    Ok I'll do that, thanks for your help.
  5. Matt27

    Address information in Excel

    Thanks for your replies, I didn't think it was going to be straightforward having spent some time trying to think of a solution!! This is going to be a file we will receive periodically, hence the need to automate it as much as possible. In the file I have at the moment there are just over 600...
  6. Matt27

    Address information in Excel

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

    Allow only numeric entries in Excel

    That's great, thanks for that. Is there any way of doing it the other way round - if I wanted to restrict the users to only entering alphabetical characters into a column and not numbers?
  8. Matt27

    Allow only numeric entries in Excel

    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?
  9. Matt27

    Access 2003 - Invalid Argument Error 3001

    I have tried importing the table into Excel. I get to the final step which is the SQL Server Login. I type in the password and get the following message:- Connection failed: SQLState: '08004' SQL Server Error: 4060 Server rejected the connection; Access to selected database has been denied...
  10. Matt27

    Access 2003 - Invalid Argument Error 3001

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

    Percentage row in a crosstab

    I've now resolved this myself!!
  12. Matt27

    Percentage row in a crosstab

    I have now created a shared variable to produce the result, but now the only problem is that when I add this variable to the cross tab it only gives me the figure for the first load period (row 1 in my cross tab). Any ideas??
  13. Matt27

    Percentage row in a crosstab

    I can now see why it's giving me 2 or 3 rows. In the formula for the new row I am restricting it to 5 categories of the field used for the columns. It's giving me one row total for these five and then a seperate row for each of the other categories contained in this column field. So how do I...
  14. Matt27

    Percentage row in a crosstab

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

    Drag and drop in Excel

    Thanks for that, but is there any way of avoiding copy and paste. Ideally what I want to happen is for the user to be able to drag and drop but for the values not to increment. I know that you can do this by holding the CTRL key and doing it but is there no way of, say, "turning it off" so the...
  16. Matt27

    Drag and drop in Excel

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

    Desktop Intelligence report missing data on Enteprise

    The report runs monthly, and will run at whatever time the database is up and running after being updated at month end. So there is only one datasource and the report wont actually run until this datasource is available.
  18. Matt27

    Desktop Intelligence report missing data on Enteprise

    I've checked the connection setups of both and they both appear to be the same. I have other deski reports I've created which use the same database connection and have worked absolutely fine on Enterprise when scheduled!
  19. Matt27

    Desktop Intelligence report missing data on Enteprise

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

    "Where" operator in Business Objects XIR2

    That's great thanks - that works when I put it in with my main block of data. In this main block of data I have a field called <Account Location>. If I wanted a seperate summary table to show the 4 values held in this field along with a total for the two variables I created above for each, how...

Part and Inventory Search

Back
Top