Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Second Sales Tax Field

 
   Database Help (Home) -> MS Access -> Tables DB Design RSS
Next:  Connect To SQL Server / Database  
Author Message
Jason

External


Since: Jan 23, 2008
Posts: 29



(Msg. 1) Posted: Tue Dec 02, 2008 6:32 pm
Post subject: Second Sales Tax Field
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

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

 >> Stay informed about: Second Sales Tax Field 
Back to top
Login to vote
Mark Han[MSFT]

External


Since: Aug 15, 2008
Posts: 99



(Msg. 2) Posted: Wed Dec 03, 2008 3:25 am
Post subject: RE: Second Sales Tax Field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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: msdnmg.DeleteThis@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.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/subscriptions/aa948874.aspx

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

 >> Stay informed about: Second Sales Tax Field 
Back to top
Login to vote
Jason

External


Since: Jan 23, 2008
Posts: 29



(Msg. 3) Posted: Sun Dec 07, 2008 8:26 pm
Post subject: RE: Second Sales Tax Field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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: msdnmg.RemoveThis@microsoft.com.
> ===========================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.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/subscriptions/aa948874.aspx
>
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================
>
>
 >> Stay informed about: Second Sales Tax Field 
Back to top
Login to vote
Mark Han[MSFT]

External


Since: Aug 15, 2008
Posts: 99



(Msg. 4) Posted: Sun Dec 07, 2008 9:27 pm
Post subject: RE: Second Sales Tax Field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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: msdnmg.TakeThisOut@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Second Sales Tax Field 
Back to top
Login to vote
Mark Han[MSFT]

External


Since: Aug 15, 2008
Posts: 99



(Msg. 5) Posted: Tue Dec 09, 2008 6:25 am
Post subject: RE: Second Sales Tax Field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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/access/FX100646911033.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: msdnmg.RemoveThis@microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Second Sales Tax Field 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Sales - Hello, I am looking to create a database that stores sales figures for a restaurant. I have four tables. tblSales wich has sales by 1/4 hour. I add the sales to get sales by whichever time slot I need. tblReconsile ------------ reconsileID..

Is there a sales tracking template for Access? - I make a lot of cold calls and would like to track them from initial attempt to close ratio. Any templates available for Access?

Sales orders and Delivery notes - In my Sales order database one customer can have many orders. One order can have many products. These products are often delivered in batches, so I need multiple deliveries to one sales order. Can you help?

Memo Field in Access 2007 - On Lose Focus, Field Jumps To .. - When scrolling through a memo field, and then clicking on any other field, the memo field goes back to displaying the text at the very top of the memo field. How can this be prevented? When I exit the memo field, I'd like the cursor to stay where I....

Field type txt or nos for relating to autonumber field ? - Hi, Should I make the field called ID in my second table a number or text type of field when that field relates to my first table's primary key field called ID which is an Autonumber field or does it not matter ? This second tables PrimaryKey field..
   Database Help (Home) -> MS Access -> Tables DB Design All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]