?
Solved

adding more fields to form to add to table

Posted on 2011-04-26
2
Medium Priority
?
220 Views
Last Modified: 2012-05-11
hello,
this attached database - if you open - you will see you can enter multiple serial numbers into table-
problem entering other fields - which are not multiple-
like modelNumber - I placed on form
is this possible to have modelNumber and other fields populate fields where multiple serial numbers are added?
I asked similar question- but i only now realize what I am trying to do-
If i just bound form to table- then listbox does not work like i want
thank you

db-example.mdb
0
Comment
Question by:davetough
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 35465990
You need to modify your sql command to include the fields and datab values you want to insert.
0
 

Author Comment

by:davetough
ID: 35466129
can i do that and still have listbox enter more than one item?
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question