|
| 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 |
|
#11
January 21st, 2008, 12:16 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
label making
Where do I look to see if the fields are present in the underlying query?
"Tom Wickerath" wrote: 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. 
|
|
#12
January 23rd, 2008, 01:47 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
I have the same problem... The address field is in the database, but does not
show up when I try to print lables...Help! "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.
|
|
#13
January 23rd, 2008, 02:06 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
I have the same problem.. The address field is in my contact list, but cannot use it for lables... Any suggestions? "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.
|
|
#14
January 23rd, 2008, 05:18 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
Dap,
Did you create this database yourself, or did you download it from somewhere? If you downloaded it, please provide a link and I will have a look at it. Also, which version of Access, including service packs, are you using? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "DAP" wrote: I have the same problem.. The address field is in my contact list, but cannot use it for lables... Any suggestions?
|
|
#15
January 23rd, 2008, 10:37 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
I have the same problem as dap and newbie. what is the answer?
Terry Tom Wickerath" wrote: Dap, Did you create this database yourself, or did you download it from somewhere? If you downloaded it, please provide a link and I will have a look at it. Also, which version of Access, including service packs, are you using? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "DAP" wrote: I have the same problem.. The address field is in my contact list, but cannot use it for lables... Any suggestions?
|
|
#16
January 24th, 2008, 12:16 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
Does this page on my site help?
http://accessjunkie.com/faq_15.aspx -- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- "Terry" wrote in message: ... I have the same problem as dap and newbie. what is the answer?
|
|
#17
January 24th, 2008, 03:02 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
Hi Jeff,
Why would the author of this template have chosen the memo data type for an address field??? That's just plain nuts! Any chance of getting them to fix this? To Terry: You got lucky this time with a speedy reply, since Jeff (a Microsoft employee) replied to this thread. In the future, you will very likely get a much faster resolution to your issue if you can provide more useful information, instead of just saying "I have the same problem...". This includes identifying the version of Access that you are using, along with service packs applied. Yesterday, I asked Terry if he created this database himself, or downloaded it as a template. If you were having the same problem, then you likely downloaded the database as a template, right? In which case, you could have said so and provided a link. That way, other people such as myself can quickly grab a copy of the sample and start looking into the issue instead of just guessing what the user is or is not seeing. Just my 2 cents worth. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Jeff Conrad [MSFT]" wrote: Does this page on my site help? http://accessjunkie.com/faq_15.aspx -- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx
|
|
#18
January 24th, 2008, 04:55 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
"Tom Wickerath" wrote in message:
... Hi Tom, Why would the author of this template have chosen the memo data type for an address field??? This is the "standard" with all the existing templates. Any template with a contacts or employees table will see this because they are all taken from one "base" master template table. (Like an assembly line if you get the picture.) The Contributors and Employees table in the Charitable Contributions, for example, inherit the same attributes as the base tables. That's just plain nuts! I'm sure you can guess my opinion. g Any chance of getting them to fix this? Most likely not because they would have to change virtually every template and I would surmise they're not willing to do that especially when it's an easy change to make for the user if they so choose. -- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ----------
|
|
#19
January 24th, 2008, 07:49 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
Hi Jeff,
Most likely not because they would have to change virtually every template and I would surmise they're not willing to do that especially when it's an easy change to make for the user if they so choose. Given that this silly decision to make an address field a memo data type has affected three people in just this thread alone ("newbie", "DAP" and "Terry"), I can see why you've prepared a web page to address this issue. Looks like it's going to be a very popular sticking point with many users. Any chance of getting this fixed for the templates available in the next release of Office 14? Thanks, Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Jeff Conrad [MSFT]" wrote: "Tom Wickerath" wrote in message: ... Hi Tom, Why would the author of this template have chosen the memo data type for an address field??? This is the "standard" with all the existing templates. Any template with a contacts or employees table will see this because they are all taken from one "base" master template table. (Like an assembly line if you get the picture.) The Contributors and Employees table in the Charitable Contributions, for example, inherit the same attributes as the base tables. That's just plain nuts! I'm sure you can guess my opinion. g Any chance of getting them to fix this? Most likely not because they would have to change virtually every template and I would surmise they're not willing to do that especially when it's an easy change to make for the user if they so choose. -- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ----------
|
|
#20
January 25th, 2008, 04:49 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
label making
"Tom Wickerath" wrote in message:
... Hi Tom, Given that this silly decision to make an address field a memo data type has affected three people in just this thread alone ("newbie", "DAP" and "Terry"), I can see why you've prepared a web page to address this issue. Looks like it's going to be a very popular sticking point with many users. Exactly, and I would very surprised if a KB article would be made on it so I thought it would be prudent to make a FAQ page. (Emphasis of course on the first letter g.) Any chance of getting this fixed for the templates available in the next release of Office 14? I'll bring it up with the team. -- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access 2007 Info: http://www.AccessJunkie.com ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ----------
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
