Recent content by Chalco

Or, you could use the word object direct Private Sub WORD_DOC_Click() On Error GoTo Err_WORD_DOC_Click Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Documents.Open ("U:\Computer\Working Databases\IntrviweThankyouMerge.doc") oApp.Visible = True Set oApp...

A quick follow up to this - the code works - thanks A follow on question though - the code uses the settings from IE, not the default browser - i.e. I have both internet explorer and firefox installed, and I use firefox by default. Following numerous tests, I couldn't get the code to work...

Thanks Checking, I can now (hopefully !!) get this working

I have some code that will re-link a table in the front-end to a back-end database and that works OK, however, I now find myself needing to recreate a link to a backend access database which in turn links to a sql-server database. I have managed to create the link programatically, and whilst...

Hi, I would like to create some code which can check a website for a particular piece of text, then depending on the value, download a file - however, I do not have any idea where to start. Can anybody provide a starter for 10, or even some sample code which I can then enhance if need be...

Hi, I normally work on Oracle, so I understand it's internal dictionary, however, I would like some guidence (or code !!) which when run against an access database will produce the sql that could recreate the database, including all R.I., indexes, default values etc Reasons are two fold - 1...

VBA code - if you create a procedure on the on-exit event to populate the field (check in the process that the source field is valid thou)

I think what is happening, is that the update is being rolled back - you could try autonomous (excuse spelling !!) transaction

If the field is on the same record, have the field on the screen (either displayed or not) and then say me.fieldname=value

No, just that by putting it at the backend, it may be easier (I am more of an Oracle user than Access) and I try to put as much functionality into the database than the client - as I said, that way, it means you don't have to set the field in every program that may insert into the table (may...

Create a trigger in the oracle database which fires on insert only. The trigger should set the field to user (Oracle predefined variable). This way, your code is transparent, and you ensure that whenever a record is inserted (wether it be from your code or somebody elses, the value is always set)

I use PDF995 - print to this, save it as a file and then distribute the PDF

Create a view, and then select from the view using the selection criteria

Thanks Scriverb (Sorry for the delay, but I have been off on Holiday/Vacation) - I will implement that for the majority of the images, however, there is one bit where I allow the user to import a logo for the reports - this is only a very small image - I know I could amend all my code to allow...

Hi, Can anybody help - I don't know where to start - I would like to add a button onto my my form, which calls up a dialogue box to select a picture to import, and then store this in the database (I have an object on the form called, Photograph (oddly enough !!)) I have read the fact that the...