Search results for query: *

Fantastic PHV! Works like a charm. Many thanks!

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

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

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

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

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.

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

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.

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.

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.

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

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

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

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

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

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