If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Phone number query in query form
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? |
#3
|
|||
|
|||
Phone number query in query form
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? |
#4
|
|||
|
|||
Phone number query in query form
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? |
#5
|
|||
|
|||
Phone number query in query form
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? |
#6
|
|||
|
|||
Phone number query in query form
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? |
#7
|
|||
|
|||
Phone number query in query form
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? |
#8
|
|||
|
|||
Phone number query in query form
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? |
Thread Tools | |
Display Modes | |
|
|