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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MSoffice Form Template Help



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2008, 05:48 PM posted to microsoft.public.access.forms
Nancy
external usenet poster
 
Posts: 446
Default MSoffice Form Template Help

I am pretty new to Access. I am using MSAccess2007 and the MSOffice Template
for Managing orders from 2003. Here is my question and I hope someone can
help me. I have changed some of the underlying tables headings to met my
needs. Such as "Product" I changed to "Nomenclature". On the Add an Order
Details Form there is a subform called "Order Details Subform". I changed
the heading in this form to meet my needs, i.e. "Nomenclature". In the
orginal template form the "Nomenclature box" is a dropdown list box and pulls
list entries from the table. I changed this drop down list box to an unbound
text box. I want to be able to enter nomenclature items in the unbound box
and save this record as a OrderForm. Each time I place an order I want to
use this form. I do not want to order items that are on a list in a table as
I order many, many different items and I have no way of knowing from one day
to the next what an item might be. Therefore I can not use a list of
products to choose from. When I changed the dropdown list box to a unbound
box, I enter the item that I want to order in the "Nomenclature unbound box".
When I hit the enter button or tab button, each line below the first line in
the subform automatically populates with the item that was entered into the
first line box. If I change the Nomenclaure box from an unbound text box to
a bound text box, I get an error msg, #Name?. What am I doing wrong. I want
to be able to enter an item on each line and have the items saved to a table.
Each main form should be a stand alone order form from one company with a
number of different items that I am ordering from that company. I kept the
integrity of the template the same as when it was downloaded. The only
changes were Product name was changed to Nomenclature name. Once I get this
ironed out I will need to make a few more changes such as calulations in the
query. Can anyone please help me?
 




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 05:27 AM.


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