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 derfloh 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: *

  1. tmryan2

    IIF statement in query criteria

    Fantastic PHV! Works like a charm. Many thanks!
  2. 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...
  3. tmryan2

    How to filter out unwanted email addresses, InStr function?

    Thanks scking! I haven't thought of that before. I guess I just needed a kick in the right direction. I ended up using your second suggestion: opening up the Do_not_email table as a recordset, and for each record in the Contacts table, cycle through the entire Do_not_email table to find a...
  4. 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...
  5. tmryan2

    Non-printing controls in report

    No, I form wouldn't work for me in this situation. This is quite a long report that includes a lot of summary calculations in group footers and such. I have been experimenting with changing the color of the font such that you can see it in report print preview but won't print out. However, I...
  6. 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.
  7. tmryan2

    MS Outlook and HTML

    WOW, it worked! Thanks keypounder. I've spent most of a day looking through Microsoft's Knowledgebase and couldn't find a solution. Thanks again! LOL LOL LOL LOL
  8. tmryan2

    MS Outlook and HTML

    I have tried pasting HTML code into the message body - it doesn't work. You get the actual code itself, it doesn't get rendered.
  9. 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.
  10. 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.
  11. 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...
  12. 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...
  13. tmryan2

    Query Criteria Problem

    <br>I just realize there is also another wrinkle all to the solutions suggested:<br><br>You are trying to return all records using &quot;*&quot; or &quot;Like *&quot; as the criteria. However, any variation of &quot;*&quot; will only only return non null records.&nbsp;&nbsp;If there is a record...
  14. tmryan2

    Query Criteria Problem

    This has worked for me before:<br><br>1. Create a non-visible field on your form and call &quot;Selectcategory&quot;.<br>2. In the Control Source of the new field enter the following:<br>IIf([cboCategory]=&quot;All Design Categories&quot;,&quot;*&quot;,[cboCategory])<br>3. In the query criteria...
  15. tmryan2

    Passing multiple criteria from a Form to a Query

    <br>Thanks very much for your reply DougP. However, the solution you suggest basically hard codes in the number of criteria that a user can enter. What I want to do is to be able to use one control on the form, and enter into it ANY NUMBER of criteria with/without boolean operators. So, I'd like...
  16. 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