Search results for query: *

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

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

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

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

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

I have an Access program that outputs data into an Excel Spreadsheet that creates a one-page report with two charts. I am using DoCmd.TransferSpreadsheet to export the a query results as static data to an Excel template file. The query is exported as a separate worksheet into the workbook...

I have an Access program that outputs data into an Excel Spreadsheet that creates a one-page report with two charts. I am using DoCmd.TransferSpreadsheet to export the a query results as static data to an Excel template file. The query is exported as a separate worksheet into the workbook...

I have a project that uses Access and Excel to graph results of a query. My problem is binding between Access and Excel. I can get the data from a query input into the Excel file, but then I want to open the Excel file, run a couple of macros to allow the user to input their name and company...

I have a project that uses Access and Excel to graph results of a query. My problem is binding between Access and Excel. I can get the data from a query input into the Excel file, but then I want to open the Excel file, run a couple of macros to allow the user to input their name and company...

I have a project that uses Access and Excel to graph results of a query. My problem is binding between Access and Excel. I can get the data from a query input into the Excel file, but then I want to open the Excel file, run a couple of macros to allow the user to input their name and company...

I have an Access program with about 20 tables and about 60 queries. I have created a user-friendly interface that allows the users to point and click to create reports and/or charts from the data. I have to create about 40 variations of the program based on geographic locations and as part of...

Is there a way to format the text inside a MsgBox? I would like to use a larger font and bold part of the text. <p>Bryan Meek<br><a href=mailto:bmeek@pacbell.net>bmeek@pacbell.net</a><br><a href=http://www.handtech.com/meekent>Meek Enterprises - Personal Technology Consultant</a><br>A TC in your...

I have a chart displaying the top 10 results on a form with users providing the input for a specific city. The form is based on a query that does not filter by City. I use a &quot;Select&quot; query to filter the data that the user types. My trouble is the [City] value in the original query is...