Search results for query: *

Hi All, Thanks in advance for any help given, I have recently taken over a new job role from a collegue who has a powershell script that create mailboxes from a csv file and for some unknown reason has stopped working, I am new to windows powershell and I was wondering if anyone had any ideas...

Hi All, I have been working on an email project where I use a couple of sql queries in access to send an email with an excel attachement. It all works quite will except that the excel attachment comes up blank or closed? I am not sure anyway the worksheet is gone and I am unsure why, any help...

Hi All, I have put together a vba script that runs two sql queries using the data to populate a html template and then call that template and email it to an email address from one of the queries, this does almost everything I want except that if the query PER has more than one line of data...

Hi, I was wondering if anyone would be so kind to have a look at my code and tell me where I am going wrong. My code has calls two queries the first populates the email add and the subject line and the other query fills the html template I have borrowed a template function to call it from an...

Hi All, I was wondering if someone could give me some advice on why my package keep failing on the exception that I have added to the end of two update statements. The error that I am getting is the following "PLS-00103: Encountered the symbol ""EXCEPTION"" when expecting one of the following...

Hi All, I was wondering if you could help me I have created a pl sql script that when run, will update a table with some values then update the tables that the values came from with either a success or failure except it is just updating every record the same either success or failure and not a...

Hi all, I have looked everywhere for some vba code to email from excel picking up the email address from an excel work sheet can any one help, I would be most grateful Many Thanks

Hi All, I am stuggling vith the following vba code to copy and paste rows of data from 2 spreadsheets to one spreadsheet from a value in another spreadsheet. The reason I have been asked to do this is that 19151 rows of data that are group accoding to a code and I would like to automate the...

Hi all, I was wondering if you could help me I have an update query which hangs when I run it and I am unsure why. Here is the code UPDATE sdc_destination_data dd SET (dd.actual_destination_code, dd.actual_destination_desc) = (SELECT he.code, he.adDESC FROM (SELECT a.person_code, '54'code...

Hi everyone, I have setup the following function, it seems to compile ok but when I try to use it will sql it gives me a character to number conversion error what have I done wrong? FUNCTION get_learnersAgeband ( PersonCode IN people.person_code%type, datefrom IN date ) return...

Hi I get the following error ORA-00001: unique constraint (FES.PEOPLE_I6) violated when I run the following update query update people p set (p.gc_candidate_no, p.gc_uci) = (select gu.cnumber, gu.gc_uci from sdc_UCI_update gu where p.person_code = gu.person_code) where p.person_code in...

Hi all, I have currently written an insert statement that brings details from couple of tables into another table, the question if someone could please help me with is that the table that I am inserting the new rows into has a sequence id number that is growing by one each time a new entry is...

Hi, I have created an OBCD link from Excel to Access and have created a query in SQL. This has brought up a data set that I need into Excel, what I am also trying do allow a user to add information to a column that corresponds to the data that has been produced from access, which is not...