Search results for query: *

I think I will just break it up into 4 different arrays, one for North, South, East, and West cities, like this. The finished project will end up having hundreds of cities: $northCities = array("Aldenville", "Analomink", "Archbald"); $arrlength = count($northCities); for($i = 0; $i <...

What am I doing wrong? I have 4 salesman ID's and the cities they cover in an array called "cities". How do I obtain the Salesman ID based on the city entered in a form, Field-name "city"? I don't know how to search through an array inside of another array. $cities = array ( 0 =>...

Awesome, pure genius. Thank you so much.

No, not my intention. I have my form add up all scores from urls and from bad or spammy words like Sex, Viagra... And if the score reaches 4 points, the form won't submit and user gets a error message saying Marked as SPAM. Anyway, this does look much cleaner. I see the reg expression is...

I'm checking my form fields for links to other websites, if I find more than two I mark as SPAM. Is there a way to simplify this code? Maybe put all of my form fields in an array and loop through it and just write the preg_match code once? I just don't know how to do it...

That worked perfectly! You are awesome!

I have a webpage with a textbox that displays the users name - which comes from a database that I don't have access to. I want to display their email address in a textbox below their name. I have a list of their names and emails in an external javascipt file. My html fields: <label...

Thanks again!

OMG, I can't believe that is all that was needed! It worked! Thank you so much. Are you able to explain how that works? I assume it means any fields that are Not null. Scott

I have an html Orderform for safety products for our employees, consisting of checkboxes. The user checks whichever items they want. No quantities are involved, it is always just 1 item. Example: <input name="Butyl-Gloves" id="Butyl-Gloves" type="checkbox" value="yes"> <label><strong>Butyl...

I modified this from an Internet Search. It tests to see if the user is connected to a company network. It works, but the first time I run it, whether connected to network or not, it takes about 27 seconds - VERY SLOW! Then each time, it is almost instant. Anyway to speed the initial runtime up...

Andy, good idea!

Andy, this line that you have near the end: WhoIsTheSuprev = strOut Is that just another way of saying Case Else Me.txtSupervisor = ""

Andy, the public function looks like the perfect fix for my current situation. And Skip, you are absolutely right! We need to bite the bullet, make the proper changes and update our employee table, create another department, and update all of our queries and reports to reflect the new...

Skip and mintjulep, Actually I wanted to do this without requiring anyone to select the supervisor, because when an employee is first entered into the system, the girl doing the entry might not know which supervisor to choose. In Department 160, we currently have around 12 employees. 5 of them...

Yes you are right, I should just add a Supervisor field to the employee table. That would solve all of my problems! The only thing is that would require the person adding new employees to have to know which supervisor to assign and then make the mouse click. But I guess that is the way to go. THANKS

I have an Access Form, my code functions, but needs serious help! I need to assign a group of employees in Department 160 to their own special group with their own Supervisor, based on their employee number that shows up in Me.txtEmpNumber. How can I make this code easy to maintain as it will be...

Skip, you are right. I didn't realize that named ranges and variables assigned to a range were two different things, which guess explains the lack of quotes.

I DID IT! I'M SO HAPPY, IT NOW WORKS PERFECTLY! Someone else created the original workbook, and it is really large! I found this function inside a module to determine the sheetname: Function GetMainInvoiceSheetName() As String With wkbCall If...

Still working on it, but I have to put it on hold for a few days, will post back the results. Thanks again!