Search results for query: *

We use MS Access 2007. When I run any report, it shows report but does not give me option to export to Excel. I can export to other formats (pdf, xps, etc.) but not to Excel. Excel option is grayed out (disabled perhaps?). Where can I find setting that will allow me to export reports to Excel?

I would like to do find on whole spreadsheet; is there a way I can select all tabs (sheets) and issue a find command?

We are using SQL 2000. Where can I find (or set) how long job information is kept on jobhistory/sysjob tables? It seems information about some jobs is kept for months while others is only few days. I want to look at old abends for few jobs.

How can I get column names from a table that doesn't have any data or has data (just like DESC command in Oravcle)?

How to delete duplicate records from table/query? Let's say, in a table there are 9 fields fld1 through fld9 and organized/grouped by least occuring to frequent occuring from fld1 - fld9. If I want to delete all duplicate records that match on fld1, fld2, and fld3. How would I do this?

Does anyone know how to do outer left and our right joins in a same query? If there are two tables, I want to get records from both table whether there is a match or not. For example, we would join on A-ID and B-ID TableA Table B A-ID A-Name B-ID B-Name 1 AA...

Can I use two conditions in one IIF statement, for example, If DEPT_NUM is blank or NULL, make DEPT_NUM = '9999'. I am having trouble with even just 1 statement, as following select fld1, IIF(DEPT_NUM = NULL, "9999", DEPT_NUM), fld3 from Tbl_A

(SQL Server 2000) - Every morning, I need to check about 30 jobs to see if they ran OK or not; is there a better way of doing this than opening each job separately. Is there a SP (stored procedure) that can grab status from each job and display so I don't have to open each job separately?

Let's say one of applications running on my PC has three pictures (images); if I do screen print and paste it on a WORD document and/or PPT slide, it will show all three pictures. Is there a way to 'cut' unwanted images so I can only show one of the images on my WORD document and/or PPT slide?

how to inactivate a password in MS Access?

If I know a table name, how would I know what columns are used as primaryt key. 'Desc Table_name' doesn't provide that info. What system table I can check?

In Excell- How can I trigger a VB code (to go to a particular tab) when someone picks a value from a dropdown in a cell? I have different tab for each value in the dropdown and would like to go to that particular tab when the value is picked.

How can I trigger a VB code (to go to a particular tab) when someone picks a value from a dropdown in a cell? I have different tab for each value in the dropdown and would like to go to that particular tab when the value is picked.

Is there a way to find out about relationship between tables in a dastabase if we don't have ERD (Entity ReationShip Diagram)? Is there a system table(s) that keep track of such information?

Does anyone know how to copy data from Oracle tables to MS Access tables (with same name) without copying to MS Excel first?

What's the easiest way to combine two databases into one. I can backup one and restore in other database. Is this the easiest or someone knows easier method?