Recent content by GoodLife22

I went with this for my final line If Me.CUST_CODE Like "*[0-9]*" then MsgBox "This is a location only client. Only send product via FedEx" And it worked great. Its clean and simple and easy to understand. Seriously THANK YOU all 3 for your help. This was perfect.

This one worked. I am assuming the 'mid' part just means if there is a number anywhere in the field?

I just tried this and received an error: Compile error: Wrong number of arguments or invalid property assignment And it highlights the top line in yellow: Function hasNumber (str As String) as Boolean and it also highlights the "isnumeric" in blue

Poorman & London. THANK YOU both for the answer. I will try it now and post my results soon. Seriously thank you !!!

I did a quick search & didn't see anything, sorry if this is a repost. I hope this is an easy one. I have a varchar field called [CUST_CODE] Each customer has a unique code. Some include numbers, some do not. So the data looks like: SMS.DELTA.1952 CRY.DOWN.NA SMS.ALPHA.NA CRT.ALPHA.5555...

OK I am in form "frm_CUSTOMER" (which has a couple subforms) looking at my customer information. I can click a button which opens "frm_CONTACTS" for that same customer. My "frm_CUSTOMER" stays open in the background. I add my new information, then close "frm_CONTACTS" and go back to...

OK I made one small change to Private Sub YourCommandButton_Click() With Me.YourCommandButton If .Caption = "Unlock" Then Me.AllowAdditions = True Me.AllowEdits = True .Caption = "Lock" Else Me.AllowAdditions = False Me.AllowEdits...

thank you so far. I looked at those code and it looks like it should work perfect but it doesn't. I created a new button and simply named it: "YourCommandButton" so I could simply copy and paste the rest of your code exactly as it is. When I open my form I cannot make any changes in the...

I have a main form with a combo box drop down with a list of my clients. You select the client then the subform will show the information for that client. I want to set the subform to open in READ-ONLY mode so my users cannot change any data for most of the fields. However there are a handful...

OK your script worked PERFECT. You are a great help there Mr Bob Larson

First off THANK YOU for the work. I will add it to my system right now and try it out. We have to keep track of it at the table level. We use this date to pull reports and export data from this system into another system.

Hello everyone. I hope you all had a great 4th of July. I have 2 date fields on my form. When a user enters a date in the first date field I want it to automatically add the date to the second date field. So far I have this: Private Sub Date_Started_AfterUpdate() Me.Date_Finished =...

This worked like a charm. This is exactly what I needed. THANK YOU. Does anyone have a really good cheat sheet explaining the differences between all of the difference EVENT TYPES? There are: on current after insert before update on dirty after del confirm on open on load (how is that not...

I have a standard check box in my form. I need write my code that IF the box is NOT checked and then my user goes and clicks on the box it will give a message box. I first thought of a LOST FOCUS event, but that doesn't help if it wasn't checked and then checked. I thought about an on...

that did it. I am working fine now. Funny part is I was pulling the report in Print Preview mode and the text fields would now show that way, but once I switch it to normal mode they look good. Most likely just a buggy print driver issue. Either way I am good. Thank you James!