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!

Recent content by cmmsi

  1. cmmsi

    Access 2010-Viewing a table and a query side by side

    Most Excellent, Correct, and Timely. I love this place.
  2. cmmsi

    Access 2010-Viewing a table and a query side by side

    When I open queries / tables in MS Access 2010, they open in tabs, and I have not been able to find a way to have them separate so I can see them side by side. I have even added the tile and window buttons to the quick access toolbar, but they do not work when the objects are displayed. Any...
  3. cmmsi

    excel 2007 export to csv with custom delimiters (wizard) has moved?

    I just opened up an Excel 2000 to check, and it looks like I only have an import wizard, not an export wizard. It appears I got the software confused. Thanks for the sanity check, as well as the information.
  4. cmmsi

    excel 2007 export to csv with custom delimiters (wizard) has moved?

    In Excel 2003, you could export a spreadsheet to csv, and you could get a wizard to help you along and allow you to change the delimiter / text qualifier and other options. In Excell 2007 and 2010, this I can not seem to find this option. It appears in Access 2007 and 2010, but not in Excel...
  5. cmmsi

    convert text to hyperlink

    YES! Most Excellent. Mega Cheers. Giga Cheers. Heck, Tera Cheers. O, yes, by the way, thank you.
  6. cmmsi

    convert text to hyperlink

    Yes, that works, and for a few items, it is easy because the actual link to paste into the dialog box is the data in the cell itself. Do you know of an automated way to handle a large number of cells (over 200 and growing quickly)? I was hoping to be able to handle it with the Format Cells...
  7. cmmsi

    convert text to hyperlink

    How do I convert text in a cell to behave like a hyperlink? the text is already formatted to behave like a hyperlink, and if you copy the text from the cell and paste it into the run prompt, the file designated opens up in the default application for the extension. As an example...
  8. cmmsi

    Oracle link

    check odbc as the user having the problem. test the connection (control panel->administrative tools->odbc data sources) and confirm it works for that user, or that it is even present. also, the tnsnames.ora file will need to have the correct info, AND be available to that user.
  9. cmmsi

    displaying ppt show via live meeting and presenter's view

    hello. Anyone aware of what is required in ms live meeting 2007 to allow dual screens to be used with live meeting, so that the 'show' can be displayed on one screen and to the audience, while they presenter can see their Power Point "presenter's view"? I have attempted this several times with...
  10. cmmsi

    Powerpoint Dual Monitor Issue

    Under slideshow->setup show, you should click on 'Show Presenter View' and when you run the powerpoint show, the full display should go to one screen and the navigation to another. If you are just extending the monitor via control panel, then you should be able to drag the entire powerpoint...
  11. cmmsi

    Where does actuate store email address and text for scheduled 'jobs'

    Hello, and thanks in advance. I run Actuate reports through an application called Maximo. When I submit a report to be scheduled and enter the parameters, Actuate returns a confirmation page indicating a job number and allows for some expanded details as well (schedule info on when it will...
  12. cmmsi

    09010 GCI CLO Session closed error in sqlbase 6.1.2

    Looks like it was a version issue; I moved to SQLBase 7x and all was well.
  13. cmmsi

    09010 GCI CLO Session closed error in sqlbase 6.1.2

    Any chance anyone is familiar with this error and how to resolve it? I am attempting to open a database through the application, and it just closes with no message other than 'session closed'. If I attempt to connect through ODBC, then I get a more detailed message of: [INTERSOLV][ODBC SQLBase...
  14. cmmsi

    Size Limit / Splitting Data Base

    Feel free to take a look at: http://support.microsoft.com/kb/304932/en-us or even access help on database splitting. Essentially, you can set up a database for each table, and then a single database with connections to each table in each database, so it looks like 1 database. A better...
  15. cmmsi

    How do you export a large table into excel

    Generally, I run into this when the user is comfortable with Excel, and not with Access. Row limitation is version based I believe, and I am using Excel 2003 which reports: Worksheet size 65,536 rows by 256 columns With that in mind, what I usually do is get the user to agree on summary...
See more

Part and Inventory Search

Back
Top