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...

Perhaps I need to back up a minute and you can advise me. I have so many test queries/reports that I want to go back to square one. As an end result these are the fields I want on my report and the tables they come from: tblMembership Contract_Num Group# Proper Name Steet City State Zip...

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.

I would like to write code that would advide the user that the recordset is empty. The following code appears when the user opens my form that is built upon a member ship table (over 1000 members): Private Sub ContractNum_Enter() Private Sub Form_Open(Cancel As Integer) If...

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 looking for some help on writing a code. I have a form that is made based on a membership query. Upon entering a contract number in the first field, all other fields pertenent to the customer will populate (addr, city, state etc will appear. To accomplish this I am using an 'unbound' text...

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...