Recent content by BMeek

vich, Only someone who has suffered similarly can appreciate your frustrations with seemingly random errors only on certain machines. Thanks for the stars! I develop a distributed program using Access 2000 and have been through the ringer a number of times due to "Function not available..." My...

vich, How are you distributing the database? Did you build an installation routine or are you simply copying the file from a CD to the new hard drives? If you are copying the file via a CD, make sure the file is copied to the hard drive and not being run from the CD. Even if the database is...

trium123, Thanks for the information and the suggestion. We use Access 2000 as our development platform because many of our customers have not upgraded yet. We have the developers versions of all the newer MS Office applications but we have not migrated from Access 2000 for our client...

I have a Microsoft Access 2000 Program that is deployed to clients. Some clients have MS Office and some may not. Will there be a problem with the code if I include a reference to the MS Office Library (MSO9.DLL) and it is included in the deployment CD installation program along with Access...

I have a Microsoft Access 2000 Program that is deployed to clients. Some clients have MS Office and some may not. Will there be a problem with the code if I include a reference to the MS Office Library (MSO9.DLL) and it is included in the deployment CD installation program along with Access...

Hi PVH, Thanks for the suggestion. While the FileDialog box is easily found in the 2003 version of Access, what can I use in it's place for Access 2000? Bryan Meek

PH, Thanks for the response, however formatting query results is a lot easier than getting the same formatting to apply once the data is in the chart object. Your suggestion still doesn't get me the desired results of having both lines of text right aligned once the chart is opened and...

HiTechUser and others, I've run into a snag with right aligning my text. The ? in the format property aligns the text in the query builder results but not after the query runs and populates the chart axis. I still need some assistance getting the chart axis right aligned. I've tried using RSET...

Thanks HitechUser, Actually I found that if I opened up the query in design view, then pulled up the field properties I can place a "?" in the format line and it automatically right justifies both lines in the string. Thanks again for the response. Bryan Meek bmeek@adelphia.net

I am working on a query that provides data for a chart and I need to right justify the data field so the chart axis labels are right justified. I am using the following text string to force a line break between agent name and their firm name. Example: AgentName: [AgentLast] & ", " &...

I have the following code behind a form in an Access 2000 program that allows a user to select a file type from a set of option buttons then click a command button that automatically exports the file using DoCmd.TransferSpreadsheet. I have code that tries to save the file into the default "My...

Thanks for the suggestion Leslie. I am using a form that allows the user to select a report based on results with a variety of parameter prompts. The action is behind a button that calls a report based on the query. For example: Agent Results by Office Location Agent Results by Property...

I want to have two fields prompted to the user for an optional filtering of data. When I use the format for one field, everything is OK. But when I try to add a second field using the same technique, I get blank results unless put a value in each of the parameter prompts. How can I use the...

Thanks Paul, Aside from an extra " in the middle of the string, it worked fine. Thanks again! Bryan Meek bmeek@adelphia.net

Hello my friends! I need some help with a chart report I am using in Access 2000. The SQL behind the chart uses the following string: Z: "Next"+Space(1)+Format([subchrtCoopPercAvgVolPerAgent].[ProdAgents],"#,###")+Space(1)+"Agents...