Search results for query: *

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...

You can create yourself a template of a blank Excel workbook with your customized headers and footers in place. This will also work on margins if you have to make any adjustments to themn before printing as well. Bryan Meek bmeek@adelphia.net

Thanks for the response! I tested the program using Office 2000 and packaging the program on a Win 98 PC and had the same error messages. I had to dial back some of the security bypassing the Security Wizard but maintaining an alias "SuperAdmin" as the owner of the entire database and...

Lee, Thanks for the suggestion, however I did set the user rights for update data under tables and queries and I get the following results: In attempt to view export file as a spreadsheet: You do not have permissions for viewing 'MsysTables'... In attempt to export the file using...

I have a Microsoft Access Program that we distribute quarterly to our clients. In the past I have set security very tight and only allowed minimal rights to the users and compiled the file into an .mde file. Now I need to allow the users to export a file of contacts they wish to follow up with...

I have a Microsoft Access Program that we distribute quarterly to our clients. In the past I have set security very tight and only allowed minimal rights to the users and compiled the file into an .mde file. Now I need to allow the users to export a file of contacts they wish to follow up with...