Search results for query: *

Hope this shows up ok! ASEP (All) Sum of Quantity (gWh) Method of Sale Name Date Allocation Obligation Long Term Auction Mid Term Auction Short Term Auction 01/10/2013 2143.038766 10866.55 5853.280509 13.75 98.726309 02/10/2013 2194.152126 10866.55 5853.280509 13.75 98.726309...

It's a stacked chart that I created using the wizard. Two of the series are then updated to lines to display on the chart using a Macro. This needs to be the bottom 2 of the series in the chart which is why I have rearranged the columns. As for the PT data, rows are date, columns are as...

I manually sorted just be dragging the columns into the order that I need in the table.(It's not an alphabetic or numeric sort). Previously this used to also sort them in the Pivot chart but this doesn't seem to work in excel 2010. Make things as simple as possible — but no simpler. [pc3]

Hello, I'm having a problem with a pivot chart in excel 2010. I've manually sorted the fields in the pivot table, but this sorting is not showing on the pivot chart attached to the table. I've recently (well our IT department have) finally made the move from excel 2003 to excel 2010. So...

Hello, I'm hoping someone can help. I'm currently using a dual monitor set up for projecting powerpoint slides through a projector. However I could do with disabling the mouse pointer from appearing on the 2nd screen. Is there an easy way to do this? Many Thanks, Steve Carey. Make things...

These are all very helpful suggestions and have given me a good place to start. I've been working in VBA for so long it's been hard to remember where I started! Many Thanks all for all your assistance, it is much appreciated!!! Make things as simple as possible — but no simpler. [pc3]

Hello, I've been asked to teach a colleague some Basic VBA in Access. I've been a developer now for 10 years so things that are easy to me probably aren't the basics. Does anyone have any ideas of a good place to start, or can you recommend a good website that I can send him to first to get...

Hello, I am currently having a problem with rounding of a large dataset (1.5 million records). I have run the round function to 2 decimal places and every record seems fine. However when I sum these rounded records i am getting additional decimal places. i.e. .0299958. Has anyone got any ideas...

Hello, I have been trying to sort out a problem on my mother's pc for a couple of weeks now. Firstly I had to get rid of the Starware toolbar which was slowing her pc down. I thought that I'd managed to do this but she is still having problems. Initially the pc starts up fine and connects to...

yep, the destination field is definitely a memo field. The code is as follows Dim strErrorInfo As String: strErrorInfo = "" Dim rstErrors As DAO.Recordset Set rstErrors = db.OpenRecordset("tbl_P&SImportValidationErrors", dbOpenDynaset) Rest of code here… With rstErrors .AddNew...

Hello, I am currently getting a problem transfering some data using vba. When populating a memo field from VB using DAO the string data I am appending is truncated to 255 characters. However the string is more than 255 characters long, it shows okay in the immediate window but in the...

Many thanks, just the job, I'll make sure I check the FAQs first before I post next time!! Make things as simple as possible — but no simpler. [pc3]

Yep, outlook 2003. Make things as simple as possible — but no simpler. [pc3]

Hello, I am trying to write some code attached to a form that will open a blank outlook email window and populate the Subject field and to field with data passed from the form. I've got some code that will populate the whole email and send it but I can't seem to just open a blank one, any...

yep, it's referenced! I think it maybe that the pc with Access 2000 has an old version of the active x control Make things as simple as possible — but no simpler. [pc3]

Hello, I am having problems with the Windows Script Host Object Model. I am running MS Access 2003 and the system works fine. However a user that has MS Access 2000 is getting a runtime error which I've found is caused by FileSystemObject. It is returning "user-defined type not defined". I've...

Hello, I have a problem with having a text file as an attached table. The file is an export from another system which is produced with file extension .dp4, basically it is a comma delimited text file. Previously MS Access attached to this file as a linked table with no problems at all. Today...

Hello, Not sure if this is the right forum, but it's a jet problem so thought I'd try here first. MS Access creates a file Jetxxxx.tmp in the C:\temp file. this is created whenever ms access is opened. However a system that I have recently taken over support of has a huge amount of data to...

Excellent, that worked great. Thanks Paul. Make things as simple as possible — but no simpler. [pc3]

Tried that, still no luck. Make things as simple as possible — but no simpler. [pc3]