Search results for query: *

Hi, Does anyone know an easy way to join text data within grouping query? For example, I have data like this:- Field1 Field2 A Gr1 B Gr1 D Gr2 E Gr2 F Gr2 and would like to get result like this:- Result1 Field2 A B C Gr1 D E F Gr2 Thanks

Hi, I am responsible for maintaining a number of ms access databases on our company network. These are all written in access version 2000/2003 and all use the Excel 11 code library. I have recently upgraded my pc to office 2007 and now find that when I perform any updates the code library...

I have a stacked bar chart in MS access 2003 and need to set x axis labels (currently not displayed). This is easy in Excel as I can select Chart / source data option from menu. Unfortunately this option is not available when using Access. Does anyone know of way to to this?

Can anyone point me to some code which will delete a field from a recordset? I have tried to use Delete Method (Fields.Delete field) but it won't allow deletion whilst recordset is open. If I close the recordset then how do I refer to the fields to delete? What I am trying to do is:- 'Open...

I have a subform that has a source object based on a temp table. This temp table is re-created when users select options on the main form. The fields within my temp table also change accordingly. How can I 'refresh' the subform to reflect the changes to the fields in the underlying table...

Does anyone know why my database file size increases by about 50Mb when I import 936 Kb JPEG image file to a form? I have tried compacting the Db but it doesn't make any difference. How do I import image to use as form background without this problem?

Hello, I have a subform that displays order data records. The subform recordset is switched dependant on option buttons selected by the user on the main form. Each recordset consists of approx. 4000 records displayed continuously on the subform and shows the orders at a particular status...

I have a graph (microsoft graph object) which I need to scale to fit to print on A3 sheet. In form design view, I find that as I drag the chart border to extend the width to anything greater than about 300mm, the right hand side of the chart is progressively cut off. I have tried switching size...

I have a subform where its recordsource property is switched to a temp recordset variable when the main form is opened. I now need to amend the main form so that the subform recordsource is reset to sql if certain options are selected by the user on the main form. My code is bombing out when I...

I have a form containing a number of subforms. One of these subforms contains unbounded text boxes which I set by a calculation that is performed by the main form on current event. The form displays perfectly well on screen and even in print preview mode, but when I print it the text boxes are...

I have annoying error that is present on just 1 pc on our company network. When I run the the following line of code:- Set FrmTempRs=Ctl.Form.recordsetclone I get this error:- Runtime error 429 ActiveX component can't create object. I have checked code references all all looks ok. We have...

Can anyone help me with a piece of code that I currently get 'application-defined or object-defined error' with? I am trying to simply sort the data with XL spreadsheet using access sub. The code bombs out at line XLRange.sort..... I have simply copied and pasted the code from xl macro into...

Can anyone give me clue how I might code the 'copy and paste' elements for the following procedure? Open instance of excel For subform 1 to n Open subform Select and copy subform data to clipboard Paste data into next free excel Sheet rows Close subform Next subform Close...

Hi, I have application which runs as follows:- 1. Create global ADODB.recordset variable RsSt10 2. Append fields to RsSt10 3. Open form/subform (where subform is continuous form) 4. copy subform recordset to RsSt10 5. Set RsSt10 as subform recordset I'm all ok to here If I then...

I am having problems assigning a temporary recordset to the recordset property of a sub form when I open the main form. I can do this ok for main form using Set application.Forms(Str).recordset=rs (where rs is the temp recordset and str is the name of main form) But I am struggling to do same...

I have a form / subform where users enter details on subform. They then select which records they wish to view on the subform, and view a report from the main form which is filtered by this indicator field. At the moment I use a temporary indicator field on the subform recordsource to do this...

I have customised the default short menu on my pc, ie 1. Tools/menu tick "default short menus" and tick "allow toolbar/menu changes". 2. Open database, then right click menu, select "Customise" then drag and drop commands to menu bar. All well and good and works fine on my pc. When I open...

A really simple one I'm sure...... I have code which opens form in form view, then changes recordsource and displays results. All I want to do is switch view mode to print preview after changing the recordsource. If I open form in preview mode (using docmd.openform formname, acpreview), then I...

As you can gather from subject title, I'm new to vbscript in outlook so I'm sure this question is simple! A couple of days ago, I generated a form with function that opened access database when the user pressed the send button. The database then queries the outlook form data and updates a data...

I have a series of select subqueries which provide data for a make table query. What I am trying to do is design a form which allows users to select particular criteria via drop-down menu selection which will then be applied to one of the subqueries before the maketable query is run. I have...