Search results for query: *

Thanks! That worked great. I changed the format from numeric to text. Is there a method to use the word "All" instead of the "*"? I tried to substitute it in the code but it did not work. http://home.comcast.net/~ccrt-racing/ccrt.htm

I'm trying to add "*" to a combo box and then pass it to a query. to select all records. I've used faq702-4538 as best I can but cannot get it to query without error. Here is the SQL for the Combo Box (This works as it adds the "*" to the combo box) SELECT qryComponentNumber.ComponentNumber...

Seems I figures out a way using the Nz function. http://home.comcast.net/~ccrt-racing/ccrt.htm

I have 6 combo boxes on a form (cbodd1, cbodd2.......cbodd6) I have a text box "Sec1Sum" with this expression =([cbodd6]+[cbodd5]+[cbodd4]+[cbodd3]+[cbodd2]+[cbodd1]) The problem is if one or more of the combo boxes are not populated the "Sec1Sum" remains blank. I've tried using the Iff...

Thanks-- That did the trick. Anyway to get the hours? --Dave http://home.comcast.net/~ccrt-racing/ccrt.htm

I'm trying to figure out why the first record returns a value of 2 days given the start and end times are less than 7 hours apart? Additionally, Is there an easy way to caluculate the exact hours? Fuction used in query results below: ComplaintSentDate CustContactedDate ResponseTimeDays...

I can't seem to find the correct method to enable "Command8" "TextEndDate" is the field on the form that is pouplated by a calendar. I'm trying to make the Command8 object only available after the "TextEndDate" is populated. Thanks --Dave Private Sub Form_Load()...

I have a form with 3 cascading combo boxes cboProblemMain cboProbLevel1 cboProbLevel2 It works fine unless the user decides to go back and change the cboProblemMain or cboProbLevel1 after initial input. Then they are out of sync. Is there anything I can add to my code that will refresh to a...

Thanks very much to all. --Dave http://home.comcast.net/~ccrt-racing/ccrt.htm

The following snipet of code is from the second tier of 3 cascading combo boxes. Id like to know if there is a way to use a wildcard instead of typing each Case senerio. Example: Instead of listing each case "No Power", "No Display", "Error 1" for Electrical problems. I would add a prefix...

Thanks They both work great..... The later "mp9's" Is a little easier to input into a grid view criteria But the use of "Or" in "PaultheS" make more sense to me. Oh well, thanks to both of you for such quick responses. --Dave http://home.comcast.net/~ccrt-racing/ccrt.htm

What is the correct format to declare a multiple “Not Equal” criteria? I’ve made a sample table that contains one field named “Color” I’m querying the field using criteria of Not "Blue" Or "Red" The query result only excludes the value “Blue” the value “Red” remained. What an I doing...

It would be a valuable tool. I do have the need for this, as a few of my database are heavily reliant on queries querying queries. Unfortunately my VBA skills are at the infancy stage in comparison to the contributors on this board. But what better way to enhance the learning curve than to...

Can this code be tweaked to list query to query relationships?