Recent content by Juddy58

Eventually solved the issue by using a unpivot followed by a pivot. Thanks Justin

Hi, I'm in the process of learning ssis need to clarify something with pivoting data. I have the following data in a data flow task F1, F2 represent the are the current field names and there could be 100s of fields. Each column basically represents a purchase order. I'm trying to get the data...

To follow up on this as it may help others. I tried installing add on's with express but didn't have much luck. I ended up installing developer edition of sql server as a new instance and it includes the required functionality. Thanks Justin

Thanks Frederico, I'll download it this week at work and let you know how I go:) Justin

Hi, I’m currently in the process of learning SSIS and I’m having a few issues trying to deploy a package. I think its to do with my sql server installation but I’m a bit confused how to resolve it. Apologies if its more of a sql server issue:) When I try to deploy a package I get the following...

Hi, thanks for the replys. I did solve the issue by declaring a dynamic multidimensional array (which I didn't know you could do!)and each time in my code there is a new email address I just redimmed it and added the new address to the array. Thanks for the help everybody Justin

Hi, I have a dynamic array astrEmailAddress which gets populated at run time with a list of email addresses eg, astrEmailAddress(0) = "aa@aa.com" astrEmailAddress(1) = "bb@bb.com" astrEmailAddress(2) = "cc@cc.com" Im need to turn this into a two dimensional array like, astrEmailAddress(0,0) =...

To easy Remou, exactly what im after. Cheers Justin and a star!

Hi, Just wondering if anyone has code to convert a string with a list of file attachments eg "C:\Temp\File1.txt; C:\Temp\File2.txt; C:\Temp\File3.txt" into an array eg, dim ArrAttachment(4) as string ArrAttachment(0)= "C:\Temp\File1.txt" ArrAttachment(1)= "C:\Temp\File2.txt" ArrAttachment(2)=...

Hi, I have a table tblClientDisciplineRelationshipOrganisation which contains the following fields fldClientID fldRecordOrder fldOrganisationID fldMainOrg 1 10 24 false 1 20 29...

Hi Darrylles, basically the code for the before update and after update is to track whether the user updates the current unbound record they are viewing, if they only view the record then the variable gblbolRecordUpdated will remain false, before the user goes to a different record a check is...

Thanks for the reply Remou, I think a control could possibly be a good and easy solution for me, I will have a look at it in the morning. I still wouldn't mind knowing if this can be done directly with code and a variable though, as im still learning about classes and my curiousity has got the...

Hi Darrylles, basically the code is for an unbound form I have designed, I have got the form working exactly how I want, but im trying to make it so I can reuse the form again within the database and for other tables etc, with a minimum of fuss. Im trying to avoid using the global variable as it...

Hi I have been developing a form in access in which all textboxes have similar onenter events and afterupdate events 'tbxproductname Private Sub tbxProductName_Enter() mdlvarValueBeforeUpdate = Nz(Me.tbxProductName, 0) End Sub Private Sub tbxProductName_AfterUpdate() If Nz(Me.tbxProductName...

sorry ace man you must have written your response while i was writing mine. Can I say one thing you are definetily the ACE MAN that is exactly what i need thanks!!! and a star! Justin