Replies

We are using office 2003 have have not had any training since office 2003 was intalled in 2004

macros are a rare event for word and powerpoint, and the great majority of excel filesl, however most access applications have macros.

I hope this clarifies things,

I understand that there are addins that convert the new menu to an old menu,

I which Office 2010 implemented this option.

We are not converting because the it department does not know how to line up their ducks in a row.

I am asking these questions to help them.

How much training is required what is in a typical training syllabus. – The amount of training depends on the current Office version.

If office is phased in, how will others read an office 2010 document in the meantime. – If you have a version older than Office 2007 you can install the Office compatability pack on the older version or you can continue to save documents in the old format. Older versions of Office will not be able to use new features.

The must be other problems of not converting so are can anyone else enumerate them? – Not sure. It depends on how much of Office you use, how extensively you use it, and how much custom development has been done.

Are there other issues? – Sure Custom forms, macros, programs, etc. all must be tested.

Is there a how to manual? – How to what? Use Office 2010? Convert to Office 2010?

I’d recommend you contacting a local Office expert for help. You’re asking some very generic questions which need much more detail to even come up with a plan.

Joe

i am using access 2003, I assumed the pie chart adresses only one field

thanks, I can do that in microsoft securities

I have enabled java scipt my complements cosit only of adblock plus; java console and framework assisant

but i am not sure i understand what you are asking about

I found a way using the find and subtring function, but i need to find three distinct area codes 514 ou 450 or 819

go to options and tha save tab, select something like 5 minutes, maybe a third party screen saver is doing something wild use a wiindows screensaver

this worked

SELECT Ref_SAE.Code, Ref_SAE.Libelle, [sousR_eta sae].CompteDeCodeEtablissement
FROM Ref_SAE LEFT JOIN [sousR_eta sae] ON Ref_SAE.Code = [sousR_eta sae].CodeSAE
ORDER BY Ref_SAE.Code;

where [sousR_eta sae] =

SELECT ETA.CodeSAE, Count(ETA.CodeEtablissement) AS CompteDeCodeEtablissement
FROM ETA
WHERE (((ETA.StatutCSST)=Yes))
GROUP BY ETA.CodeSAE
ORDER BY ETA.CodeSAE;

But can someone give me a link to a microst page that explains why my original query would not work.

l have 240 attached tables via odbc -sql server and 6 local tables, some 200 queries and a hundred reports and forms. I did what you suggested and it worked (57 000 K).

have you considered creating a form with drop down boxes then have a report based on a query that referes to the dropdown items of your form, where you could also add a button to open the report. The report title could have text boxes refering to values you selected such as between date1 and date2

I hope this helps. here is an example http://office.microsoft.com/en-us/access/ha011730581033.aspx

That did it thanks

If you go into View => Toolbars => Customize

Do you see it anywhere on the list?

If you do, try clicking on Reset button then close dialog
and see if it makes any difference.

Sorry I tried that it did not work I got

XP pro sp3

i istalled microsoft secuity essentials from

http://www.google.ca/url?sa=t&source=web&ct=res&cd=1&ved=0CAoQFjAA&url=http%3A%2F%2Fwww.microsoft.com%2FSecurity_Essentials%2F&ei=fET_SvyLCofelAesi6CWCw&usg=AFQjCNHnIs_dGpTqsgxt6jPeNTcNjmmutg&sig2=uFRKxTmcaRNxrxnMN5AaVQ

could this caused by the fact that i may have had other anti spy ware and avg still active

I’d use VBA code, macros are hard to maintain. You can use an expression in the file name, for example:

Dim strPath As String
Dim strFile As String
strPath = “C:Export”
strFile = Format(Date, “yyyymmdd”) & “.xls”
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, “tblTest”, strPath & strFileName, True

Note: you can’t use a date in the form 11/10/2009 in the file name, because slashes / aren’t allowed in file names.

thanks again

Is there another way around this problem without the dll? Because the application will be distributed and I do not want to support the end user wher most will have to contact their I.T. deparment to add the dll.

Thanks