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
|
|||
|
|||
label making
When I go to the "available fields" while attempting to make labels, I do not
see {address 1} or {address 2} fields to choose from. All the other fields are there to choose from. |
#2
|
|||
|
|||
label making
Are these fields present in the underlying table or query? Sounds to me like
they are not. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: When I go to the "available fields" while attempting to make labels, I do not see {address 1} or {address 2} fields to choose from. All the other fields are there to choose from. |
#3
|
|||
|
|||
label making
No, {address 1} and {address 2} are not listed. All the other choices are
there like name, city, state, zip. "newbie" wrote: When I go to the "available fields" while attempting to make labels, I do not see {address 1} or {address 2} fields to choose from. All the other fields are there to choose from. |
#4
|
|||
|
|||
label making
Are you using a table or a query as the source of records (recordset) for you
label report? If you are using a query, have you added the {address 1} and {address 2} fields to the QBE grid? If you are using a table, are these fields present in the table? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: No, {address 1} and {address 2} are not listed. All the other choices are there like name, city, state, zip. "newbie" wrote: When I go to the "available fields" while attempting to make labels, I do not see {address 1} or {address 2} fields to choose from. All the other fields are there to choose from. |
#5
|
|||
|
|||
label making
As instucted by the label making help section, I am going to the Contacts
navigation area. Then I select contact address book. Then I go to the create tab and select labels. Then I go to the area where I make my prototype label. This is where I do not see the address choice in the available fields. "Tom Wickerath" wrote: Are you using a table or a query as the source of records (recordset) for you label report? If you are using a query, have you added the {address 1} and {address 2} fields to the QBE grid? If you are using a table, are these fields present in the table? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: No, {address 1} and {address 2} are not listed. All the other choices are there like name, city, state, zip. "newbie" wrote: When I go to the "available fields" while attempting to make labels, I do not see {address 1} or {address 2} fields to choose from. All the other fields are there to choose from. |
#6
|
|||
|
|||
label making
Newbie,
Are you using Microsoft Access or some other program? If you are not using MS Access, then you are posting your question to the wrong newsgroup. This newsgroup is for Q&A related to using Microsoft Access. If you are using Access, then you need to answer the questions I asked, which you have not done. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: As instucted by the label making help section, I am going to the Contacts navigation area. Then I select contact address book. Then I go to the create tab and select labels. Then I go to the area where I make my prototype label. This is where I do not see the address choice in the available fields. |
#7
|
|||
|
|||
label making
Yes, I am using Microsoft Access 2007.
"Tom Wickerath" wrote: Newbie, Are you using Microsoft Access or some other program? If you are not using MS Access, then you are posting your question to the wrong newsgroup. This newsgroup is for Q&A related to using Microsoft Access. If you are using Access, then you need to answer the questions I asked, which you have not done. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: As instucted by the label making help section, I am going to the Contacts navigation area. Then I select contact address book. Then I go to the create tab and select labels. Then I go to the area where I make my prototype label. This is where I do not see the address choice in the available fields. |
#8
|
|||
|
|||
label making
Yes, I am using Microsoft Access 2007.
Okay, how about an answer to my other question? I will repeat this question he Are you using a table or a query as the source of records (recordset) for you label report? If you are using a query, have you added the {address 1} and {address 2} fields to the QBE grid? If you are using a table, are these fields present in the table? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: Yes, I am using Microsoft Access 2007. "Tom Wickerath" wrote: Newbie, Are you using Microsoft Access or some other program? If you are not using MS Access, then you are posting your question to the wrong newsgroup. This newsgroup is for Q&A related to using Microsoft Access. If you are using Access, then you need to answer the questions I asked, which you have not done. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html |
#9
|
|||
|
|||
label making
I used a query. When I view the report, the do addresses show up on the
report. "Tom Wickerath" wrote: Yes, I am using Microsoft Access 2007. Okay, how about an answer to my other question? I will repeat this question he Are you using a table or a query as the source of records (recordset) for you label report? If you are using a query, have you added the {address 1} and {address 2} fields to the QBE grid? If you are using a table, are these fields present in the table? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: Yes, I am using Microsoft Access 2007. "Tom Wickerath" wrote: Newbie, Are you using Microsoft Access or some other program? If you are not using MS Access, then you are posting your question to the wrong newsgroup. This newsgroup is for Q&A related to using Microsoft Access. If you are using Access, then you need to answer the questions I asked, which you have not done. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html |
#10
|
|||
|
|||
label making
And you are sure that you are using the same query?
What is the SQL statement for your query? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "newbie" wrote: I used a query. When I view the report, the do addresses show up on the report. |
Thread Tools | |
Display Modes | |
|
|