Search results for query: *

The graphic options of rep 2005 seem to be a little bit poverish. A)Is it possible to sort the legend? alphabetically or numerically? b) is it possible to specify the order of the legend items to be shown? c) is it possible to colour the legend items your own specified way?

I heard the rumour that ADP's are being phased out by Microsoft. Access 12 supports it runtime but doesn't support development of ADP's so this type of solution will gradually totally disappear. Can someone acknowledge this en give some background information about the 'why' and the best...

Currently I show the parameters shown on my report by displaying them in my query as a separate column(I use sprocs for my reports). In this way i'm able to show all values chosen in a multiple parameter field. Is there an alternative way to simply display all the values in the multi value...

I'm using the text box connect method to have graphs shown by user's choice within my report. So when they click the + sign they'll be given extra graphs. is it possible when the reports are exported to do the following: - suppress the text within the text boxes - automatically show all extra...

Suppose i select a specific group of production items, let's say Group B. This group involves 20 production items individually assigned a productionid. And besides the group parameter I have a production item parameter. Would it be possible to change the list shown within the production...

I've setup a linked server on my localserver. Both servers sql server 2000. Within the security tab of my linked server i've mapped my username to the username valid on the linked server. Within my stored procedure i refer to the linked server. When executing the stored procedure within...

I'm programming a microsoft access project, to provide full security I use views as datasources with the 'with view metadata' clause. Within one data-entry form I want the records to be sorted different from the primary key. Normally I would use the 'order by' clause but when using this my...

Do graphs have a property to have them automatically grow in height and/or width when there's too much data to be displayed at the x-axis or y-axis?

Hi, When trying to pass the multiple parameter to my stored procedure the report remains empty. I've used method 1 to pass an arry from this website http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm here's my proc: CREATE PROCEDURE dbo.Qry_MSSRS_Myproc @Begindate...

i'm using schema.ini to export several tables to text files. Within the schema.ini I've specified to use , as field separator and to not use " " as text markers. The schema.ini is being placed within the export map. Odd things happen. Sometimes it works but working on another client computer...

I'm using the with view metadata clause in views. As a result I can not use order by in the select statement so my recordset will automatically be sorted by the Primary Key. I did use order by in combination with the 'top' statement, as a result the recordset isn't updatable whilst I would like...

I'm using the with view metadata clause in views. As a result I can not use order by in the select statement so my recordset will automatically be sorted by the Primary Key. When showing the recordset in the access client I want it to be sorted to two different fields than the primary. How can...

Hi there, i'm using schema.ini to export a table. As you probably know within a project you can't use import/export specifications but have to use schema.ini . Within the ini í'm looking for a statement to tell that varchar fields (text) will be exported without quotes. So think of my export...

I would like to pass the return value of a proc back to my ado code and have the value evaluated. See the following proc and ado code, I can't get the point, Access tells me object missing. My proc works well from query analyzer so i'll first pass the ado code ADO Private Sub Form_Open(Cancel...

I'll be having 8 people data entrying in my new adp. You guess, when person A is working in the same screen as person B and has edited a record person B would like to see the edits. How can I easily achieve this without having them to use a refresh button?

Is it possible to convert a number to a time format? for instance 3,00 to 03:00 and 2,25 to 2:15

I would like to pass a value to a sql server function from an adp module. Is this possible? So instead of passing a value from sql server to access it's the other way round (from adp to sql server)

In order to get a more efficient xml file (with less data) I thought let's make a hierarchical. How can I make a hierarchical file and easily import it into access without a dtd or schema? Table basicinfor Name state Johanna NY Exis NY Albert TX The 'state' has recurring values and...

Ade files have an important security flaw when SQL server authentication is being used. When the ade resides in a read-only directory users can still get easy access to all the data, how? 1). make a new database 2). use the import command in the file menu 3). choose the ade file They can't...

I'm invoking an append stored procedure from my client, i'm getting the message: insert failed because the following set options have incorrect settings: 'ARITHABORT'