Search results for query: *

cheers again mufasa 5% is not an rise, its an poke in the eye.

cheers for looking after running that parameter script and asking around i think i know whats happening, will have speak to our DBAs about setting up that 'utl_file_dir'thing, the database that i was using is an live one ( we run many scripts againist copies) i was just thinking i bet they not...

well the answer is select value from v$parameter * ERROR at line 1: ORA-00942: table or view does not exist and the parameter not exist in this database i have full control on the sqt drive. its the normal one we write to , all i have done really is taken an script that...

okay its:- DECLARE /* Insert script variables here */ v_start_Report_date date; v_end_Report_date date; V_JOB_WINDOW_START date; V_JOB_WINDOW_END date; V_JOBSTATUS_DESC SRC.JOBSTATUS.DESCRIPTION%Type; V_ABS_APPT_TYPE...

...V_JOBCODE_DESC||','|| Replace(Replace(Replace(Replace(Replace(Replace(V_DISP_NOTES,',',' ') ,chr(13),' '),'*',' '),chr(10),' '),chr(8),' '),chr(9),' ')||','|| V_ENQ_NO||','||...

What is the context in using this function in desinger. its saying invalid definetion to anythign i put in.. Basically what i am after is something to remove blank spaces from end of objects ( like the trim function in excel) cheers wayne 5% is not an rise, its an poke in the eye.

Hi due to my work place not sending us on desginer cousres(neat) i have an query. is it possible to say make an object or something that an user can select in an prompt that runs an group of names toghter so say these names below Adrian Iliffe...

I thought i throw in me pennies worth ( about 2p). Yes i suffer the same problem its with the dates from and text file to an excel spreadsheet and this using vb, it does it for some but not all ( i will try and look into that) but yeah it also does it for numbers, we have an 13 digit number...

Not to be stupid or anything , what is that technique? oh just an sec i get it i see you mean the first bit and have Sheets("2.1.1").Select Value = ActiveSheet.UsedRange.SpecialCells(xlLastCell).Row =IF(Value=2,"",SUM(A2:A" & Value & ",A2:A" & Value &...

Hello Wonder if anyone can help me? Right as soon in the code below i have got an script that sticks an distinct count in the cell z2 but if there is an problem. if only the title is there and no other rows it trys and divides by 0 which is not good. Sheets("2.1.1").Select Value =...

cheers that helps a lot as well, my office assitant just kept telling me it was time for lunch. cheers wayne 5% is not an rise, its an poke in the eye.

Hi xlbo ahhh soz, yes i have to do it on 66 spreadsheets in one workbook , and theres 40 workbooks, the count is only for one distinct row of data. and so only need one count per spreadsheet, just working out how to vb it now. cheers though wayne 5% is not an rise, its an poke in the eye.

Cool cheers thanks for the fast respone , yes it works, but can i ask why? what does the curly brakets do? now i just got to do this 2640 times, i wonder if i can vb it. cheers still cheers wayne 5% is not an rise, its an poke in the eye.

Hello i wonder if anyone can help me? being an bit of an idiot but is there an way to get an distinct count of an colmun of data? the data is text. cheers 5% is not an rise, its an poke in the eye.

cheers Yeah ran it on its own and it runs okay. maybe the the computer. not sure thanks for your help, i will comment the line out check it through again. more strange was that it ran fine an couple of months ago. oh well cheers again wayne 5% is not an rise, its an poke in the eye.

cheers xlbo for replying. The bit of code it stopping on is this bit Sub Billinging() Application.Interactive = False Application.DisplayAlerts = False Dim LoadCells As New Collection Dim cell As Range For Each cell In Range(Cells(2, 2), Cells(40, 2)) If...

Hello All Okay the problem is that we got an bit of an hefty script that, opens an programs runs it saves results and sends it to excel and it carries out some filter stuff. Now the problem is that while running for no appranent reason the running will just stop. i have had task manger...

The code below was not written by me , but i think its what you need to export it as an HTML ( notice the object exportasHTML) Sub RunReports() Dim Buso As busobj.Application Dim DP As busobj.DataProvider Dim HT As busobj.Report Dim HP As busobj.Document Dim I As Integer...

Oh yes and that, opps, I keep forgeting that bit. The Tea-Boy

Hi Hiren i found this command works DoCmd.RunCommand acCmdImport Cheers FunkMaster