Search results for query: *

Ive got an OLE control on my report that contains an image. If no image is present, I resize it to very small, and when an image is presnent I resize the control to an appropriate size. This works fine in print preview - when no image is present, no space is taken up on the report. But when I...

I had a look around but couldnt find an answer so here goes: I have a field in my table that stores a Microsoft Word Drawing which I want to display on my report. Only a few records actually contain a drawing, the rest are just null. How do I display the (quite large) picture when it exists...

Ive got a bound OLE control on my form that stores a Microsoft Word Drawing. When the user clicks the 'add image' button they can they can either select an existing file (linked) or create a new one (embedded). With the OLE control now storing the Microsoft Word Drawing the user should be able...

I am opening a preview of a report from a command button. But when I click the publish to Word button on the toolbar it sends the underlying form to Word and not the report. The report is active and on top of the form. Also, the only way I can print the report from the preview is by...

I have a simple continuous form with the fields: Date Task Room My problem is that 'Room' just shows the Room ID rather than the Room name. So I need it to be linked to my Room table to get the actual Room name. Any ideas? (any will do but preferably SQL)

This might be a stupid question but how do I get the output of this SQL statement to a textbox: SELECT Sum (Equipment_Bookings.Quantity * Equipment.CostPerDay) FROM Equipment_Bookings, Equipment WHERE Equipment.ID = Equipment_Bookings.Equipment Thanks

I have a table with the following fields: Equipment Quantity Cost And on a form I want to display the total cost (i.e. the sum of all costs * quantities). How do I go about this? Thanks

Im trying to layout my form based upon the results from a query. I would like each record in the query to be displayed on the form at the same time, so that each record will have a label for the title and a listbox to display some info. So if there was 1 record in the query there would be 1...

Im using an SQL 'INSERT INTO' command to add a record to a table. The form responsible for this is bound to this table. The problem is that the form doesnt 'recognise' the new record until I do 'Form.Recordset.Requery' Straight after the requery Im trying to move to the new record via a...

Im using a combobox to navigate to records on a form, but I want to find a record based upon the value in the combox AND another value (which at the moment is another combobox, but will eventually be inherited from a parent form). Can I use the findfirst command to match on two fields? Thanks

I've got a very simple table that is just a list of equipment. Theres an ID field and an Equipment field. This table is called EquipmentList Now through a rather long SQL statement I get a table of Equipment being used for a particular event (called EquipmentInUse). Again there is just an ID...

I'm trying to extract the plain text parts from multi-part email messages. I'm using Mail::Box and MIME::Entity and everything seems to work fine. Except I occasionally get an error message (see below). It works with this MIME header: This is a multi-part message in MIME format...

I'm trying to extract text from a multipart MIME message. The message contains text/plain and text/html parts. Ideally I would like to remove the MIME information and the html tags, leaving just the text. But extracting just the text/plain parts would be ok. How do I go about doing this? Thanks