A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Second Sales Tax Field



 
 
Thread Tools Display Modes
  #1  
Old December 3rd, 2008, 03:32 AM posted to microsoft.public.access.tablesdbdesign
Jason
external usenet poster
 
Posts: 713
Default Second Sales Tax Field

I would like to use the "Service Call Management Database" template but it
only has a single sales tax field. I need one with two sales tax fields
(local and Federal) or at least some help in making the changes to the
template to add the additional field. I am using Office Access 2003. Please
help

  #2  
Old December 3rd, 2008, 09:07 AM posted to microsoft.public.access.tablesdbdesign
Mark Han[MSFT]
external usenet poster
 
Posts: 56
Default Second Sales Tax Field

Hi Jason,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to add a field into
the template. Is it correct? If I have misunderstood, please let me know.

in order to address your concern, I would like to explain the following.
1 what we can see after creating the template is form format. it is not
allowed for us to change. So we need to open the database by "shift"
method. please click the "shift" and open the database and then we can
design the database.

2 to add field into the template, we might need to add column into
underlying table and need to change the design of the form.

Hope the above helpful.

If there is anything unclear, please let me know

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

  #3  
Old December 8th, 2008, 02:50 AM posted to microsoft.public.access.tablesdbdesign
Mark Han[MSFT]
external usenet poster
 
Posts: 56
Default Second Sales Tax Field

Hi Jason,

This is Mark. I'm writing to follow the post.

I would like to know if the previous explanation address your concerns.
Thanks

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

  #4  
Old December 8th, 2008, 05:26 AM posted to microsoft.public.access.tablesdbdesign
Jason
external usenet poster
 
Posts: 713
Default Second Sales Tax Field

Thanks Mark.....

But I have no idea how to program or design in access........so I have no
idea what to do in the second step......was hoping someone could help.


"Mark Han[MSFT]" wrote:

Hi Jason,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to add a field into
the template. Is it correct? If I have misunderstood, please let me know.

in order to address your concern, I would like to explain the following.
1 what we can see after creating the template is form format. it is not
allowed for us to change. So we need to open the database by "shift"
method. please click the "shift" and open the database and then we can
design the database.

2 to add field into the template, we might need to add column into
underlying table and need to change the design of the form.

Hope the above helpful.

If there is anything unclear, please let me know

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======


  #5  
Old December 9th, 2008, 11:50 AM posted to microsoft.public.access.tablesdbdesign
Mark Han[MSFT]
external usenet poster
 
Posts: 56
Default Second Sales Tax Field

Hi Jason,

Thank you for th reply.

For your convenience, I would like to share our Help for Access 2007 linke
with you. if you still have concerns on how to design/program database in
access, it is better for you to open case to our advature service.

http://office.microsoft.com/en-us/ac...646911033.aspx

Besides, if you meet a detail issue when designing/programming database in
access, we welcom you posting here.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.