Phone number query in query form

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

Just in case there has been a error in the form design try using "view
fields" in design on the form and bring the field in again. Don't forget the
delete the original feidl as you can't have two fields with the same name
(ensure the name on the new field is that used in the OBF)


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

Wayne,

Thanks for your attempts, but.......

The form isn't bound to anything. It was created just so the user can input
values, select a button on the form and run the report they want. It save my
users from having to go to multiple places and to honest, I don't want them
to leave that form.

"Wayne-I-M" wrote:

Just in case there has been a error in the form design try using "view
fields" in design on the form and bring the field in again. Don't forget the
delete the original feidl as you can't have two fields with the same name
(ensure the name on the new field is that used in the OBF)


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

OK - you just in case there is some form of other mix up. A good way to test
this is to create a calculated field in the query (with no formating)
something like
TelNumber: [tblTable]![TelphoneNumber]
and place the QBF in the criteria of this.

Worth a try !! at least then you will know if the problem is with the form
or query



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

Wayne,

Thanks for your attempts, but.......

The form isn't bound to anything. It was created just so the user can input
values, select a button on the form and run the report they want. It save my
users from having to go to multiple places and to honest, I don't want them
to leave that form.

"Wayne-I-M" wrote:

Just in case there has been a error in the form design try using "view
fields" in design on the form and bring the field in again. Don't forget the
delete the original feidl as you can't have two fields with the same name
(ensure the name on the new field is that used in the OBF)


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

Nothing, it has to be something in the format of the data that is handed off
to the query.

"Wayne-I-M" wrote:

OK - you just in case there is some form of other mix up. A good way to test
this is to create a calculated field in the query (with no formating)
something like
TelNumber: [tblTable]![TelphoneNumber]
and place the QBF in the criteria of this.

Worth a try !! at least then you will know if the problem is with the form
or query



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

Wayne,

Thanks for your attempts, but.......

The form isn't bound to anything. It was created just so the user can input
values, select a button on the form and run the report they want. It save my
users from having to go to multiple places and to honest, I don't want them
to leave that form.

"Wayne-I-M" wrote:

Just in case there has been a error in the form design try using "view
fields" in design on the form and bring the field in again. Don't forget the
delete the original feidl as you can't have two fields with the same name
(ensure the name on the new field is that used in the OBF)


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?

OK Solved,

Here's what I had to do;

I change the Text Field on the QBF to a combo box pulling info from a Query
I created collecting all of the phone numbers. I set the input format of the
combo box to the phone number format so you can just type in the number
without having to type it in the proper format. Changed my lookup query to
the new List Box ID number. Now it works just fine.

"RA" wrote:

Nothing, it has to be something in the format of the data that is handed off
to the query.

"Wayne-I-M" wrote:

OK - you just in case there is some form of other mix up. A good way to test
this is to create a calculated field in the query (with no formating)
something like
TelNumber: [tblTable]![TelphoneNumber]
and place the QBF in the criteria of this.

Worth a try !! at least then you will know if the problem is with the form
or query



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

Wayne,

Thanks for your attempts, but.......

The form isn't bound to anything. It was created just so the user can input
values, select a button on the form and run the report they want. It save my
users from having to go to multiple places and to honest, I don't want them
to leave that form.

"Wayne-I-M" wrote:

Just in case there has been a error in the form design try using "view
fields" in design on the form and bring the field in again. Don't forget the
delete the original feidl as you can't have two fields with the same name
(ensure the name on the new field is that used in the OBF)


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

They both are text with the phone number input mask.

"Wayne-I-M" wrote:

Hi

Open the table that holds the Telephone Number and set the field format as
text.
Do the same in the form design.

Hope this helps

Note - as a very loose rule you should use numbers when you want to do some
form of calculation with the data (e.g 1+1=2) or sort it in some calculated
method (e.g 1234 or 4321) if not then even if the data is technically a
"number" you are really want to see a textual (learned that english word
today ha ha ha - so going to use it lots) representation of the number i.e
text.

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


"RA" wrote:

I have a database on customer and business contact phone numbers, as well as
some other data linked to that number. I created a QBF (Query By Form) where
I input the number, in the phone number formate just as in the table ( (xxx)
XXX_XXXX ).

When I type the value, in the mentioned format, in the query I get the data,
but if I use a link to the QBF, it apparently doesn't recognize the value and
returns - nothing. Any idea where the format problem is, I can't find it?