Search results for query: *

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

Thanks for the reply, Thats what I thought of doing, the problem I have is if you have a variant datatype that is stored as a string but it just contains a number eg, "2" and you run the isnumeric function you get a result of true when it really is stored in the variable as a string so it should...

Hi, just a quick one. I have a global variant variable in my database, it can contain any type of data. Does anybody know of a function like "isnumeric" but will tell me if the value in it is a string? I have done a few searches and haven't found what im after. Thanks Justin

Thanks mate, Thats what im after, and a helpful link. Justin

Hi just a quick simple question from a sql server newby, what is the sql to delete a field ("fldProduct") from an existing table ("tblProduct"). I know its something simple eg,using Alter Table. I have done a few searches and can't find what im after. I know how to addnew fields to a table etc...

Hi, I have a Form with listboxes that are requeried after an event(When a certain tab is selected) Because it can take a while for the queries to run i want a popup to appear (letting them know to wait). Once the queries have run and listboxes requeried i then want the popup to disappear. The...