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  

cmd button many records info to one form to report from.



 
 
Thread Tools Display Modes
  #1  
Old October 30th, 2009, 02:10 AM posted to microsoft.public.access.forms
Aso
external usenet poster
 
Posts: 22
Default cmd button many records info to one form to report from.

Hi,
I am working on a database in which I need to be able to use a cmd button to
populate a new form but I need to be able to add many records from the
initial form in order to do so.

for example:
for lack of a better example I will just make one up that will mock my real
life database. I have candles of varying degrees of sizes, aromas, colors,
manufacturers, etc. So each candle has its specified number such as CDL-1248.
If you open the main form that the data entry occurs to record this data it
is filled with data relevant to the specified candle. If I am creating a
requesition to fulfill an order I want to be able to look at the candle
record, click a command button that dumps the necessary information about the
candle onto the requesition. I need to be able to find another candle in the
records and add it to to the same requisition. I am really not sure how to go
about this. Any help is greatly appreciated.

thank you.
  #2  
Old October 30th, 2009, 04:22 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default cmd button many records info to one form to report from.

Aso,

Are you having a problem finding your replies? This is the third time I
have seen this same question.

http://www.microsoft.com/office/comm...f-7dfd9fea02af

http://www.microsoft.com/office/comm...6-8f41ae21df4c

and now this one... Are you not understanding the replies?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Aso" wrote in message
...
Hi,
I am working on a database in which I need to be able to use a cmd button
to
populate a new form but I need to be able to add many records from the
initial form in order to do so.

for example:
for lack of a better example I will just make one up that will mock my
real
life database. I have candles of varying degrees of sizes, aromas, colors,
manufacturers, etc. So each candle has its specified number such as
CDL-1248.
If you open the main form that the data entry occurs to record this data
it
is filled with data relevant to the specified candle. If I am creating a
requesition to fulfill an order I want to be able to look at the candle
record, click a command button that dumps the necessary information about
the
candle onto the requesition. I need to be able to find another candle in
the
records and add it to to the same requisition. I am really not sure how to
go
about this. Any help is greatly appreciated.

thank you.



  #3  
Old October 30th, 2009, 04:43 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default cmd button many records info to one form to report from.

Use a combo box to find the candle record. You only need to capture the ID
of the candle, and perhaps the price. You will add the quantity manually. If
you are printing a requisition (a report), use a query which joins on the
CandleID value that you've saved, and adds the description data from the
Candle table. Have a look at the Northwind sample database that came with
Access to see the specifics of how it's done.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Aso" wrote in message
...
Hi,
I am working on a database in which I need to be able to use a cmd button
to
populate a new form but I need to be able to add many records from the
initial form in order to do so.

for example:
for lack of a better example I will just make one up that will mock my
real
life database. I have candles of varying degrees of sizes, aromas, colors,
manufacturers, etc. So each candle has its specified number such as
CDL-1248.
If you open the main form that the data entry occurs to record this data
it
is filled with data relevant to the specified candle. If I am creating a
requesition to fulfill an order I want to be able to look at the candle
record, click a command button that dumps the necessary information about
the
candle onto the requesition. I need to be able to find another candle in
the
records and add it to to the same requisition. I am really not sure how to
go
about this. Any help is greatly appreciated.

thank you.



 




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 03:51 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.