N
Nancy
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?
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?