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...

Thanks, Ill try it. Any idea how to set the size of the OLE control to the size of the picture to be displayed?

Unfortunately I dont think that the bound OLE control has canGrow and canShrink properties. Also, changing the visible property would make the control invisible, but doesnt stop it from taking up a huge space on the report, resulting in a big empty gap when no picture is present.

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...

Sorry, found the problem. The report had the popup property set to yes.

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...

Sorry, I mean can you use Dlookup to lookup information spread over multiple tables?

Thanks. Im so used to using SQL for everything I often forget about dlookup. And am I right in thinking it cant lookup information spread over multiple tables? Thanks

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)

Crowley16, You say I can put it in a query, but can I put a query into it? (the dsum function)

Great. Thanks, Ill try it out tomorrow.

Sorry - an SQL query that joins 2 or more tables

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

Thanks. Thats it exactly. Why was it unclear? Maybe I should have but brackets in: The Sum of all (Cost * Quantity) Another question: Instead of a table name can I put in a SQL query.

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

Ive got a quesion Say you had a text box bound to ID, that went: 1, 2, 3, etc. Then you added an unbound textbox and set it to equal the value of the bound text box. Would this then show the same: 1, 2, 3, etc. Or would it show: 1, 1, 1, etc.

Ive now got a continous subform. But Im having a problem Say Ive got 3 records showing in my continuous subform looking like this: --- ID: 1 Price: 2 --- ID: 2 Price: 5 --- ID: 3 Price: 10 Now say I want to add a text box that would show the ID * Price for each one. So for record 1 it would...

Is it possible to make a subform that is bound to a query thats uses values from the controls in the main form? It seems I can only bind a subform to an existing object.

Hmmmm . . .not sure because I dont want the whole form to repeat, just a little bit of it. Maybe I could add a subform and make that a continous form. I think basically what I want to do is something like For each entry in Combbox Add Label Add Listbox Any ideas?