If I have say (field1...name), (field2...Commercial_Ph), (field3...Bus_Ph), field 4...Cell_Ph) etc.
In a report, can I select which types of phone numbers are displayed next to each individual?
Ex.
John Doe Cell: 210-555-1111 Comm: 123-456-8910
Jane Doe Comm: 210-555-1212
Lil John Bus: 813-245-6789 Cell: 321-879-1119
Or would all numbers have to be displayed for all names?
Ex.
John Doe Cell: # Comm: # Bus: #
Jane Doe Cell: # Comm: # Bus: #
Lil John Cell: # Comm: # Bus: #
Thanks,
Jason
I'm assuming this data is stored in a database. You would have a field to store which type is preferred by the person.
If, for example, you wanted to show their cell number only if the cell number field wasn't blank, the if statement would look like this : - If field4 <> "" Then
-
phoneNums = phoneNums & " Cell: " & field4
-
End If
Where phoneNums start out as a blank string and you use if statements to build up what would be shown.
9 1668
If you have a way of determining which individual should display which type of phone number, then yes, you can write code to do that.
I'm not sure how I would distinguish who gets what type of number displayed...can you explain a little more?
Thx
Jason
I can't tell you that... you have to tell us that.
I don't know why you chose to display cell and comm on line 1 but only comm on line 2. I don't know why or how you made that decision not to display the other phone numbers. That's what you have to tell us.
several situations could cause the results needed.
One person may not have a cell or the business phone and/or cell may be the best way to contact a particular individual instead of comm.
If it seems like a huge amount of work to achieve the results I'll look at alternative ways to display....was just wondering if this would be possible
It'd doable, you just need to clearly define the rules that dictate what gets shown.
For example, if you want to collapse the blank numbers, then that's a simple matter of concatenating the phone numbers together with a series of if statements to ignore the blank ones.
If they have a preferred number, then you use an if statement to check which one is preferred and display only that.
And so on. You just need to define the rules.
Sorry for not being able to take more than one step at a time here but how can I mark them as preferred and what might the If statement look like?
Thx
I'm assuming this data is stored in a database. You would have a field to store which type is preferred by the person.
If, for example, you wanted to show their cell number only if the cell number field wasn't blank, the if statement would look like this : - If field4 <> "" Then
-
phoneNums = phoneNums & " Cell: " & field4
-
End If
Where phoneNums start out as a blank string and you use if statements to build up what would be shown.
Ok, I have is so when the user checks the checkbox next to his selected phone numbers, it places and/or combines them in a field called PrefPh. (perfect) However, there is one checkbox that if it is not check, he should not be able to move to the next record until it is checked. I have my code in the "on_current" event, and that works great if you move away from that record and then come back. Once he moves back, if that checkbox is not checked, he gets a msgbox saying "No extension can be checked if there is no commercial phone checked".
How can I get it to display that when he tries to move to another record (prev or next)?
thanks,
Jason
Rabbit,
Never mind on that last part, figured it out. I put it under the next event and previous event buttons. Works good.
thanks again
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Shay Hurley |
last post by:
this is probably a stupid question so apologies in advance.
I am trying to format a number to look like a phone number with "-"'s
between the numbers etc e.g. 15554256987 should be formatted as...
|
by: joemono |
last post by:
Hello everyone!
First, I appologize if this posting isn't proper "netiquette" for this
group.
I've been working with perl for almost 2 years now. However, my regular
expression knowledge is...
|
by: William Morris |
last post by:
Our application tracks contact information. One of our clients, a car
dealership, has asked about being able to enter a lastname and phone number
and getting as much of the main form filled out as...
|
by: Poewood |
last post by:
Is there a way to parse the contents of a textbox into a phone number format?
Actually I would like to save the input as a number but display it as a
phone number in the typical US format (000)...
|
by: Brian Henry |
last post by:
I have phone numbers like this in a data table
123-435-1234
1231231234
432.234.2321
they all have different formatting, what I want to do is get them all
formatted like this
(123) 123-1234
|
by: venu |
last post by:
Hi,
I have a different requirement and it is :
I need to validate a phone number field.
It may or may not be a US phone number.
The constraints are :
***********************
# It should...
|
by: bb nicole |
last post by:
Hi.. i would like to create a page that provide users to randomly run phone number. I know it is use rand() to code it, but how if i porvide a box for user to key in how many phone number they want...
|
by: Abhishek |
last post by:
Hi this is my another validator in javascript to validate the Phone
Number :-)
<script language='javascript'>
function funcCheckPhoneNumber(ctrtxtMobile,e){
if(window.event){
var strkeyIE =...
|
by: luke noob |
last post by:
This is my HTML...
<head>
<script type="text/javascript" src="js/jquery-1.2.6.pack.js"></script>
<script type="text/javascript" src="js/script.js"></script>
</head>
<body>
|
by: Johan Olsson |
last post by:
Hi,
Iam playing around with Telit GM862 using python script.
I have been able to store numbers in the internal phone book using AT&Z.
When i read out and trying to use the numbers something is...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |