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...
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...
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...
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...
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...
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...
Ok folks, in your spare time, perhaps you will give this a look. In using Access 2003, and running a macro to transfer text from a query, it appears that the file extension needs to be .TXT, and perhaps there are a few others.
I use different extensions depending on where the data is going...
Hello. I have a powe poit presentati, and want ot be able to extract the comments from the note pages to a report. Is that possible?
Thanks in advance.
One of the nicest things in Oracle 9i is the ability to create a read only ODBC connection to oracle, in environments where the connection should only be for querying and reporting.
Anybody know how to do this for SQL Server 2000? I can't see the option in any of the ODBC connections or...
Hello. I have a tabular report that generates properly with the 'can grow' property growing the height to display all the data in each column.
However, it will not grow the border to the maximum height of the largest column.
I wish to do this to generate a sort of grid, and currently, it...
So, does anyone know how a handout can be created in power point with the 3 slides on one side, and the handout notes on the other?
I am looking for this as an assistant to the instructor / presenter (often me) that is a little more efficient than the full notes slides at 1 sheet of paper per...
I have reports in a multi-schema environment that have several tables, in each of several sub reports. Needless to say, when I create a version for a new schema, I would like the propogation to work so I can set the database location once per report.
Sometimes, it does not work. Is there any...
Periodically, Office XP and 2003 seem to loose the join in a query. Now that I have a few more that it happens to, I can see the common denominator is linking of a table to a query. The table can be native access or a linked table.
The query so far, has been executed against a linked table...
I have an install of Access 97 where the export to text file option is not present. I know there is a bulletin on the web somewhere, but I can't find it. It explains what you need to do to fix your installation, as re-installation does not seem to help.
Anybody remember this and can point the...
Hello, and thanks for reading this, as well as any help you can provide. I recently installed active synch to connect to my new pda, but it required Outlook 2002 to work correctly, so I upgraded.
Now, on occaision, I get this message when outlook is open:
Can't contact LDAP Directory server...
This morning, when I booted up, I got a long beep and just about nothing more. After a shutdown and restart, everything managed to boot.
But nothing works. The start button won't stay clicked, desktop and tray icons won't launch; files that have recognized extensions won't launch their...
Amazingly, on my old pc, I would click the save password check box after entering my password, and would never enter it again. Now that I have a new machine, and have migrated the folders, I created new connections and click the save password check box after entering the password, and it looks...
Hello, and thanks for reading this. I am finding that when I use access 2000 and link to a table in sql server or oracle, the standard non integer number format appears to be decimal, which I understand can be better, but I need it to be Double as I often need to put the tables in Access 97...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.