Search results

the Dcount function is what you want to use. If you search Dcount in the vb help, it'll explain the syntax. There are also numerous Dcount threads in this forum that will show you example syntax.

it would make more sense (and would be more accurate) to create a delete query to accomplish the task. I would recommend making a backup of your data before messing with delete queries though.

Here's the query criteria code that I updated, - it works for me IIf(IsNull([Forms]![mainform]![formContainerMain].[form]![customerID]),[Forms]![mainform]![formContainerMain].[form]![branchCustomerParentID],[Forms]![mainform].[formcontainermain].[form]![customerID]) the code you listed says...

replace [ustax_OrderForm] with the word Form (exactly has RG has it) also, the subform is formContainerMain, not mainContainerForm

You might check out this post from lagbolt. This form has a "search as you type" function that you might be able to adapt to your situation. It wouldn't provide the results within the same textbox, but you could create a small subform that would list the search results...

How about this? http://www.access-programmers.co.uk/forums/showthread.php?t=141161

Other than using a combo box listing all of the names/ID's, I don't know of any other way to create this.

SELECT RTrim([CLIENT TABLE].CITY)+' , '+ RTrim([CLIENT TABLE].ST)+' '+ Left([CLIENT TABLE].ZIP,5)+IIf(LEN(RTRIM([CLIENT TABLE].ZIP))>7,'-'+RIGHT([CLIENT TABLE].ZIP,4),'') AS [ADD], RTrim([CLIENT TABLE].FN)+' '+ RTrim([CLIENT TABLE].LN) AS NAME, [CLIENT TABLE].MEMBER, [CLIENT TABLE].PIN, [CLIENT...

Here's a simple macro you could create that will accomplish what you want. Just record a new macro, then stop the macro before doing anything. Go to the Macros, and select "Edit" then paste the code into the macro. If your sheet is named something else, you'll have to change the sheet name...

It looks like there is a hotfix that may fix the problem. I just googled and found it, so I have yet to try it myself. http://support.microsoft.com/kb/945674 Edit: I just installed it and it now works on my machine. I can compact & repair network databases just fine now! :)

If you're running Access 2003 SP3 and your "f:" drive is a network drive, this is a known bug with SP3. When compacting a database on a network drive, it doesn't properly replace the database with the compacted version. It will place a copy called db1.mdb in the same folder though. You can...

sounds like your min/max buttons are not enabled on the form and the border style is not sizeable.

Case Is >= 85 'grabs everything with a score of 85 or greater Component4Score = 0 Case is >=75 'grabs everything from 75 to 84.9999... Component4Score = 1 Case is >= 65 Component4Score = 2 Case Is < 65 Component4Score = 3 Case Else Component4Score = "#Error" End Select

Good point -- sorry about that. I'm not sure I'd use a Select Case with situations involving numbers that don't have a defined decimal tolerance. One option that would work though is to properly order your cases to allow for such situations. Select case fldn case is >2000 ' filters out all...

You did catch the LEFT function, right? LEFT([CLIENT TABLE].ZIP,5)

I believe to accomplish this you'd do: Select Case fldn case is >=1000, is <2000

you need to divide by 60 twice (360) then 24. If you do that, you get ~ 9.32.

RTrim([CLIENT TABLE].CITY)+' , '+ RTrim([CLIENT TABLE].ST)+' '+ LEFT([CLIENT TABLE].ZIP,5) + IIF(LEN(RTRIM([CLIENT TABLE].ZIP)) > 7, '-' + RIGHT([CLIENT TABLE].ZIP,4),'') AS [ADD], I believe you'd want to use pdx_man's approach and code it something like this (untested).

Question - couldn't you just use If Nz(txtTextBox, "")= "" Then 'True MsgBox "It is empty" Else 'False MsgBox "It is not empty" end if This would convert a null to "" and then compare it with "", so if the field is either Null or "" it would check out. Ryan