Recent content by justiwhi

Sorry, I figured it out, but I do appreciate your reply and offer to help. I had the * in between the wrong set of " ". I was trying: 'Check for Sender Name If Me.txtSrchSendName > "" Then varWhere = varWhere & "[SendName] LIKE " * "" & Me.txtSrchSendName & "*"" And " End If Instead of...

pbaldy, These filters have wildcards after the user input, but not before. I have been unsuccessful in getting the before and after wildcard to work. Might you have a suggestion?

John, Thank you for the code, I am using it and it is fantastic. Do you know of a way to add a date range to the form/code you posted, and limit what is searched to within these dates? My thought is to have, in addition to the search box, start and end date boxes that a user can use...

Advice taken! Thanks again, I'm sure I will have more questions in the future. Have a great weekend.

Again, thanks for everyones help. Just to let you know, here is the code I ended up with which works exactly how I want it to. I am trying to learn as I go so I try to ask the right questions that I still have to figure out some on my own. You guys are a great help! Private Sub...

Thanks to everyone for their help. One more question for you guys. Is there a way to have more than one operation occur if the if statement is true? Example, If Me.ComboBox = 1 Then Me.ControlName1.enabled = true AND Me.controlName2.enabled=true

Awesome, thanks for the code! One more question. Can I have more than one if statement? Example, currently the code enables ControlName when ComboBox = 1, can I enable ControlName if ComboBox = 1 and 2?

In a form in Access 2007, I have a field that has a drop down box with four choices. The next field on the form is one that I only want available if one of the four previous choices is selected, and not avaiable if the other 3 are selected. Is this possible?

Thanks for the help Banana. Maybe I should have informed of my skill level, which is low.:D I tried the validation rule > 14 And < 30, but this limits it to a number between 14 and 30, instead of that many digits. I also have tried writing this code, but have only gotten this far. Private Sub...

I have a field in a form for account numbers. The account numbers entered are alpha-numeric. I need to make sure the user entering the number enters an account number that is between 14 and 30 digits. Thanks for any help.

I have a field in a form that a 12 alpha-numeric account number is entered. I want it to update the next three fields in the form. The first field should contain the first 6 characters of the account number. The next field, the next 6 characters. The last field, the last two characters...

I need a query to return the account number split into the 3 parts as discussed. Do I use an update query and place that expression in the "update to" line?

I'm using it in a query

I have a field in which a 14 digit alpha-numeric account number is entered. I need to have it split into three different fields. 6 characters in the first field, 6 in the second, and the last two in the last field. I am a beginner to intermediate access user. All help is appreciated!