Recent content by Sonny Jim

I found a solution by substituting the apostrophe with double quotes, so the code that works looks like this: =DCount("strInsLastName","QueryforClaimInputForm", " strLossAddr & strInsLastName =""" & [strLossAddr] & [strInsLastName] & """") Thanks again, pbaldy, for your generous and...

I have gotten the following to work in my text box but I get an occasional "#Error" when an apostrophe is used in either field. Here is my code: =DCount("strInsLastName","QueryforClaimInputForm", " strLossAddr & strInsLastName ='" & [strLossAddr] & [strInsLastName] & "'") What is the best...

This only counts up the number of records containing the current record's loss address.

I expect the most rudimentary thing I could do using the DCount function would be to use a text box to count of the amount of times that the last name & loss address on the current record have shown up on previous claim records. *One thing to note is that, unfortunately, users have been able...

I am dealing with the same thing, & have copied the SQL into a new query. The Design View is now visible. Why or how does the Design View disappear like this? Will deleting the old query & renaming the new query with the old name work without unexpected problems?

Thanks, pbaldy, I will give DCount() a try, that sounds like it should do the trick!

I would like to have a pop-up warn that, "Insured has made prior claims at this Loss Location" when a user types in an Insured's name that has had a prior claim made to the Loss Location being entered under this Insured's name.

I want to flag a form IF a name field AND an address field (from two separate tables) both contain the same values that I currently am inputting on a previous record. Specifically, if a customer "X" files another claim for the same loss location, then I want to flag the form. What is the best...

Will archiving older data improve response time of a database? What is the best way to archive data knowing that older records will still be accessed twice a year?

That is a real good idea, thank you very much for your insight Peter!

Thank you Peter. That is the key to my problem.

I have a form with a field that uses a Value List to pick a person's name rather than a linked table of names. Now that the list has grown very long I want to use a table instead of the Value List but the form will not show the old records where the list was used. What do I need to do to use...

My lack of strict formatting is honestly just due to my lack of experience with VBA programming. I will correct this and let you know if it helps. Thanks for the suggestion!

Okay. Private Sub cmdEmailCompanyAckRpt_Click() On Error GoTo Err_cmdEmailCompanyAckRpt_Click Dim stDocName As String stDocName = "rptCompAckEmail" DoCmd.SendObject acReport, stDocName Exit_cmdEmailCompanyAckRpt_Click: Exit Sub Err_cmdEmailCompanyAckRpt_Click: MsgBox...

Sure. Fields are either blank or have data that is from the wrong records. Sometimes even a last name will show up but the first name is left blank. This is often occurs very unpredictably, and infrequently, perhaps less than ten percent of the time, but often enough to become a problem...