Search results

Just have your query display only those two fields, count the Turkey ID (I really want to ask though!!) field and the yes/no field, and set the criteria for the yes/no field to "0" (zero, but without the quotes). That is the default boolean for no so it will only return those values which have...

Create a query with only that table (or linked tables if necessary). Have it show you the part name (or record number if that is easier for you to work with) and the description field only, and put the following into the criteria row of the Description field (without the quotes): "IsNull" When...

Sorry! Sorry about that. I didn't mean to post that reply three times, my network at work is a little loopy today. Sorry! :eek:

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up...

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on the a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up...

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on the a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up...

Well that solved the array problem. :) Thanks so much for your help!! :D Where do I find this Mile-O-Phile document you were talking about? The FAQ section of...? Thanks again, hopefully I can return the favor sometime.

Thanks! Thanx guys! :D

Does anyone have a good naming convention for active-x controls? (Something like the "txt" for textbox and such). Thanks!

Constant Expression required When I try to compile the code I'm getting an error that says "Constant expression required" and highlights the part of the code Dim nSendTo(intRecipients) As String Should I be setting up inRecipients as a constant integer prior to defining it as...

I'm new to VB code but experienced with Access. This is based on code I found here on the forum, with a little tweaking (which could very well be the problem). I have removed the parts relating to attachments because the emails being sent from this database never have attachments, although...

VBA Order By option Why not just have the text box value set to a string in VB and enter that string for the Me.OrderBy option on the report (using the onload event procedure)?

I am trying to create a module whereby access can automatically send an emila through Lotus Notes. I have a query set up to return all the email addresses for a specific subset of participants in our program, however I have not been able to get access to dump all of these addresses into the...