Recent content by iainmc

Thanks for that. Do you know how, in VBA, i can find out what my object is i.e Microsoft Word Doc or XL Spreadsheet. Everything i have found says to use the the OLEClass to SET this but i only want to read it and i can't get the OLEClass to return a value to a variable for embedded objects...

Thanks, but unfortunately that just closed down my Access Db and not the Objects application (the WINWORD.EXE procees) Here is what i have Private Sub CbDownload_Click() Dim obj As Object Dim Path As String On Error GoTo ErrorHandler Path = InputBox("Enter path for file downloads -...

CautionMP, Thanks for you help on the SaveAs - it works a treat! There is one teeny tiny problem arising - as i'm looping through a lot of records a WINWORD.EXE process opens up in task manager for each one. This is causing my DB to freeze around the 1500 record mark - do you know how to kill a...

That looks like the sort of thing i've been after, i did try using the SaveAs method(as a guess) but wasn't sure what arguments it needed. I'll give that a go. Thanks

Thanks for that. Looks like it's open each doc and File, Save As.. then.

Hi, I have an Access 97 table containing 3000 records or so each with and embedded Word Document in one of the fields. I am trying to essentially download each of these files out of the table to my C: drive as a Word doc but am struggling. I want to do this in a VBA module. Can anyone point me...

Thank you Himanshu, just what i was after. iain mc

Can anyone tell me the property that needs to be set to force my output in Excel to have a font of BOLD? I am using Oracle Forms 9i if that makes a difference Many thanks

I'm not sure about 10g but in Forms 9i you have to register the Bean - have you done this? Or is it a PJC (Plugable Java Component) in which case you'll need to add it to your formsweb.cfg file? Iain Mc

It was written in Oracle Forms but as i am fairly new to ORACLE i don't really know what to look for.

When starting up my application i receive the error "ORA-01004 default username feature not supported; logon denied" Followed by a login box appearing. Does anyone know why i am getting this error and how to resolve it? I am unaware as to where i have asked for default username to be used and...

Top man

My PL/SQL on the menu is like this: CALL_FORM('A'); CLOSE_FORM('B');

This seems like such a basic problem but i have come across some real problems. I have a form, 'A', and a menu which has links to forms 'A' and 'B'. If i am on form 'A' and the user selcts form 'B' from the menu I want to open form 'B' and close form 'A' and vice versa. As things stand both...

Does anyone know of a way to print a canvas without the user being shown the print dialog box. i.e They hit a button and the canvas prints without the option to cancel or orientate etc.. Any help would be grand