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 =>...
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...
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...
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, 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.