Replies

Using your input of “Allow upgrades to large tables” I found a Knowledgebase article # KB197430 http://support.microsoft.com/default.aspx?…kb;en-us;197430 The reason the larger file option is not available on my machine it that it was already chosen. The reason I can’t move files into the folder it that there are over 64,000 emails in it. I can’t make the folders any larger and I thought I could. I guess I will make a database to hold the information. One advantage will be much faster searches in the database!!! Thanks for the help!

I did not add the last security fix as it has a conflick with an add-in we have. Mine is SR-1 9.0.0.3823.

Allow upgrade to larger files is not a selectable item. I found it, but it is greyed out? Any ideas? My outlook 2000 is set up as IMO if that makes any difference? I know I was able to increase file size on my old computer, but I can’t remember how. Warren

Thank you!!!! In XLStart was a PDFWriter.xla that was causing all the trouble. I don’t know where it came from, but without it everything still works. Thanks to all responses.

Warren

I have checked and I do not have any addins or files listed on startup. Any other ideas?

There is a Microsoft Knowledgebase article on this topic of non working wizards: Q242218

http://support.microsoft.com/support/kb/ar…s/Q242/2/18.ASP?LN=EN-US&SD=msdn&FR=1&qry=nothing happens when you try to start a microsoft access wizard&rnk=1&src=DHCS_MSPSS_msdn_SRCH&SPR=ACC2000

Edited to activate link–Charlotte

Hi Jordan,

If you can find a way to use VBA or VB to get what you want it will be easier for the life of the program. However, when you need a custom list box look at this one: http://www.zealsoftstudio.com/ These people are great to work with and to make custom modifications if you need them.

Hope this helps.

Warren

Hi,

Maybe I am misunderstanding. Sorry. I thought you were getting the error on the report when there was no data. This error would be true since there is not a column (Field) for the data in the crosstab query. If the crosstab query has the department column and this is used on the report for the Field there shold be no error even with no data. I am using Access 2000, but I don’t think this is different for 97.

You can try the NZ function in the report field and see if this helps. I don’t know if 97 has the NZ??

=NZ([Text265],0)

Sorry, I don’t remember 97 better.

Warren

Hi,

No, it would be added to the end of his existing crosstab query to create the columns (fields) he needs for the report. Here is a copy of one from one of my databases:

TRANSFORM First(StudentWorkQuery.WorkDescription) AS FirstOfWorkDescription
SELECT StudentWorkQuery.Student_PersonID, StudentWorkQuery.FirstName, StudentWorkQuery.LastName
FROM StudentWorkQuery
GROUP BY StudentWorkQuery.Student_PersonID, StudentWorkQuery.FirstName, StudentWorkQuery.LastName
PIVOT StudentWorkQuery.Day In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31);

I needed numbers instead of the departments wanted here.

Hope this helps.

Warren

If your departments do not change you can at on to the end of your SQL for the crosstab query just before the semi-colin “IN(Department One, Department Two, Department Three);” etc. without the quotes. This will create a column for each department regardless of the existance of data.

Hope this helps.

Warren

Hi Jason,

Here are to Knowledgebase articles that may have your answer. Hope this helps.

How to change printer trays from Access 2000.

http://support.microsoft.com/support/kb/ar…=0&qry=changing printer&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

How to use code to change a reports printer.

http://support.microsoft.com/support/kb/ar…=0&qry=changing printer&rnk=18&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Warren