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!

  • 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!

Search results for query: *

  • Users: tmryan2
  • Content: Threads
  • Order by date
  1. tmryan2

    IIF statement in query criteria

    I have a form with 5 text boxes called: name1, name2, name3, name4, name5. I have a table containing a field called: name I want to set up a query so that: - if the text box name1 is blank, returns all records. - if one more text boxes are filled in, returns only the specified names. This is...
  2. tmryan2

    How to filter out unwanted email addresses, InStr function?

    Hi, this should be an easy problem but I haven't been able to figure out how: I have two tables: Table 1 called "Contacts" contains a bunch of email addresses. Table 2 called "Do_not_email" contains email addresses and domains that don't want to receive email from me...
  3. tmryan2

    Non-printing controls in report

    Is there a way to have a control / field on a report to show up in the print preview, but not print out? Setting the visible property of the control to no doesn't work because it would make it invisible in both situations. Thanks.
  4. tmryan2

    MS Outlook and HTML

    Does anyone know how to "insert" a html file into the body of an Outlook message and NOT have it show up as an attachment? What I want is to have the html file rendered in the body of the message instead. Thanks.
  5. tmryan2

    Outlook and HTML

    Does anyone know how to "insert" a html file into the body of an Outlook message and NOT have it show up as an attachment? What I want is to have the html file rendered in the body of the message instead. Thanks.
  6. tmryan2

    how to play more than 1 midi file

    <br>I use the following code to play a midi file on a web page:<br><br>&lt;embed src=&quot;file1.mid&quot; Autostart=&quot;TRUE&quot; LOOP=FALSE TYPE=&quot;audio/midi&quot;&gt;<br><br>However, is there a way to play more than one midi on the same web page? ie. play file1.mid, then play...
  7. tmryan2

    Combo box initial value

    <br>I have an unbound Combo box whose values are linked to a 2-column table. In the Combo box properties, I have set the width of column 2 to zero, so that only column 1 shows in the drop down selection.<br><br>Question: how do I get the Combo box to display an initial value? Right now, it...
  8. tmryan2

    Passing multiple criteria from a Form to a Query

    I enter text into an unbound control on a form that is referred to in the criteria section of a query. And from this, I can change the criteria of the query each time.<br><br>The name of the control on the form (called Formname) is&nbsp;&nbsp;Controlname. And I refer to this control in the...

Part and Inventory Search

Back
Top