Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by spinalwiz

  1. spinalwiz

    Conditional Images work fine in Preview but not in Print

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

    Conditionally displaying images in reports

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

    Conditionally displaying images in reports

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

    Conditionally displaying images in reports

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

    Activate bound OLE control

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

    Publish to Word doesnt work at Runtime

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

    Publish to Word doesnt work at Runtime

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

    Table join on continuous form

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

    Table join on continuous form

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

    Table join on continuous form

    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)
  11. spinalwiz

    Calculations

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

    SQL Query to TextBox

    Great. Thanks, Ill try it out tomorrow.
  13. spinalwiz

    Calculations

    Sorry - an SQL query that joins 2 or more tables
  14. spinalwiz

    SQL Query to TextBox

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

    Calculations

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

Part and Inventory Search

Back
Top