Search results for query: *

Thanks for your response. I will do a bit of reformatting.

I have looked at several posts and Thread 701-794191 is most applicable to my situation. The only thing that is does not address is when you have a name formatted as: O Donnell John. I want a first name, Last Name, Mid Initial columna and then I will need to reverse the order of the current...

Guess I am not doing this correctly as I am not getting the results I am looking for. Unfortunately, I have to have this working by tomorrow. Is there any chance I could zip up a copy of what I am working on and have someone take a look at it. I actually have 2 problems to solve. (1) the...

I will work with your suggestions at home tonight and let you know. THAnks.

Is this the way I would put my DLookup? Again I am not too good at these. DLookup (“CONTRACT_NUM”, “tblMembership” , “Criteria= ‘ActiveContract#’”) And if I understood you correctly, I would put it in the control source of the data properties in the text box? If so, I am getting an #NAME...

Have a great form that I don't want to garbage up but now realize needs to be adjusted. When the customer calls in and we ask for the "ContractNum", we would expect him to give us the 9 digit number assigned to him. Once inut in the text box, subsequent text boxes will populate based on the...

...they come from: tblMembership Contract_Num Group# Proper Name Steet City State Zip Birthday MemRelCde Gender Age tblComplianceLog ContractNum** (double stars can join to member table) Rel Code** CatID Compliant Comments Category (8 are listed) CatCode * (single star can join with...

Have a query built from a table and a query. I use this for a letter that is sent to customers in a membership file but the join is not correct and instead a creating a letter for each member, I can only get one member name to show up. All data types align and have tried different ways of...

I have what may seem like a silly question but could sure use an answer. In some of my databases, many of the reports look like a table and as such, I really like to use the Line/Border tool. Because a text box can grow, that outlined box is oten larger than the label box that is outlined. Is...

Exactly what I was looking for. Seemed like such a simple thing but I just could not get there. Thanks for your help.

Looked at the DlookUp function on line as was mentioned ever so briefly in my Access books. Doesn't this do what my "After Update" event is already doing, unless I am doing something wrong. I still can't seem to get that message indicating that the contract number number entered does not have...

thanks, and I have now posted in the "Forms" forum in hopes to understand how to get the result that I am looking for.

...to that particular member. The event property for this is: Private Sub ContractNum_AfterUpdate() Dim szSQL As String szSQL = "select * from qryMembership where Contract_Num = '" & Trim(Me.ContractNum) & "';" Me.RecordSource = szSQL End Sub What I want to happen is to...

I had to look up EOF and BOF defnitions to understand these properties. What I am curious about is the "on open" property for the form. It shows: Private Sub ContractNum_Enter() Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "No matches...

That is exactly what I am looking for but apparently didn't know how to phase my question. I am at somewhat of a loss as to how to do this.

Thanks for the response. I changed my szSQL statement as yours and puposely put in an incorrect contract number but did not get a message to say I had to wrong number or it was not found. Can a message of this type be built into this?

...I am using an 'unbound' text box with the following code: Private Sub ContractNum_AfterUpdate() Dim szSQL As String szSQL = "select * from qryMembership where Contract_Num = """ & Trim(Me.ContractNum) & """;" Me.RecordSource = szSQL End Sub What I would like to do is...

Got it. thanks again for the really good explanation. Needless to say, this will be filed for future reference.

Interesting but I was into the Microsoft site but was looking at lower and upper case rather than StrConv. makes a big difference if you know what you are looking for. Thanks for the explanation and pointing me in the right direction. I was courious as your use of the word "Mid" in the...

Perfect. If I can ask, based on your expression, what is it that is triggering the Cap of the 1st letter? Reason I ask is that I need to put the address in lower case as well, obviously keeping the 1st letter in caps. I tried twisting the expression a bit to fit the address piece but it is...