What I am looking at doing is I have a couple of forms, when I enter
the number of products been despatched on the order form, it then
creates a record in the transaction table and also the product
history. I have created a couple of update queries which worked well,
but did not perform the way that I wanted them to.
I wanted to do it using code so that when the despatch order button is
pressed it creates the above.
The information of the order is in a sub form called Order details on
a form called orders., this then wants to create a record in the form
transaction history, and another in the product history. I have tried
to work on the code but to no avail.
sort of looked like this.
Forms!transacti on history.form![qty required] = forms![order details].
[qty despatched]
Were it takes it from the field qty despatched on the order form in
the order details sub form and puts it into the form transaction
history in the field qty required.
I am looking for help on the coding part ie what are the parts made up
of i.e. what each part of the code relates to in respect of what it
isd doing.
Any help much appreciated if you can understand what I am trying to
get at. Please Help, 3 1882
A form is just a way of viewing/editing/adding data and doesn't store
anything. You can view what you change in one form on any other form, so
that if you enter a number in despatched in one form you can view it another
form and label it required. You don't want to double enter data. I would
guess that you have a way of identifying the product in both forms and it
would be a common ID number.
feeman wrote:
>What I am looking at doing is I have a couple of forms, when I enter the number of products been despatched on the order form, it then creates a record in the transaction table and also the product history. I have created a couple of update queries which worked well, but did not perform the way that I wanted them to.
I wanted to do it using code so that when the despatch order button is pressed it creates the above.
The information of the order is in a sub form called Order details on a form called orders., this then wants to create a record in the form transaction history, and another in the product history. I have tried to work on the code but to no avail.
sort of looked like this.
Forms!transact ion history.form![qty required] = forms![order details]. [qty despatched]
Were it takes it from the field qty despatched on the order form in the order details sub form and puts it into the form transaction history in the field qty required.
I am looking for help on the coding part ie what are the parts made up of i.e. what each part of the code relates to in respect of what it isd doing.
Any help much appreciated if you can understand what I am trying to get at. Please Help,
--
Message posted via http://www.accessmonster.com
Iunderstand that the forms are just for viewing/editing and adding
data, but this way does not actually duplicate the records it creates
a record with different information, gained from the original records.
Orginial record has the following on
stock ID
Stock Location
Qty Despatched
Transaction table has
date
action
stock id (from original stock form)
qty (from original stock record)
so from the original stock record I would like to take the sotck id
and qty and put it into the transaction form, date will be
automatically todays date and the action will be standard as of the
order record it will be a despatch and of the delivery note it will be
a delivery.
So I am trying to get the information from one form onto the other and
the this will automatically update the table .
I think you are doing inventory. Take a look at the Northwinds sample
database that ships with most versions of Access. It has an inventory
component.
feeman wrote:
>Iunderstand that the forms are just for viewing/editing and adding data, but this way does not actually duplicate the records it creates a record with different information, gained from the original records.
Orginial record has the following on stock ID Stock Location Qty Despatched
Transaction table has date action stock id (from original stock form) qty (from original stock record)
so from the original stock record I would like to take the sotck id and qty and put it into the transaction form, date will be automaticall y todays date and the action will be standard as of the order record it will be a despatch and of the delivery note it will be a delivery.
So I am trying to get the information from one form onto the other and the this will automatically update the table .
--
Message posted via http://www.accessmonster.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Randell D. |
last post by:
Folks,
Perhaps someone can figure this out - this is 'the process of my script'
I have a form whereby I can add multiple contacts to a single address.
There is only one firstname/lastname/telephone box - when the user
clicks the add button, I read the values from the form fields and
record them into a hidden text input field. This part works because
during debugging, I have converted the <input type=hidden> into a <input
type=text>...
|
by: Dave B |
last post by:
Does anyone know of a program that will read a text file and fill in a web
form with the contents of that file? We need to get about 3000 records (5
fields to each record) into a database owned by another company and the only
way it can be done (according to them) is to enter them one at a time into a
web form. We can get the records into a comma or tab separated text file
and would like to just read the file and auto insert the fields...
|
by: fig000 |
last post by:
Hi,
I'm relatively new to Javascript so please bear with me on what
might sound like silly questions.
This is what I want to do:
I'm working in classic asp (I have to for this project). I need
to:
1. Click a submit button on an asp page, calling another page
that saves the contents of that form to a database and then displays
|
by: Andy Hutchings |
last post by:
Hi everybody - hope you can help out here.
I have a form in a database, which is a columnar form from one of the tables
in the db - there is a sub-form to the form which is a datasheet view of
another table in the db. The LinkChilds property is set to show connected
records from both tables.
What I'd like to do is copy and paste, or use some other method of writing,
the contents of one field in one table in the form, to a field in the...
|
by: meganrobertson22 |
last post by:
hi everybody-
what is the best way to add data from one form to another?
i have 2 tables: person and contract. here are some of the fields.
table: person
personid (autonumber and primary key)
ss#
| |
by: Sanjay |
last post by:
Hi,
Is it possible to save all the names/values of a form to another memo
textfield before a Insert to the database then when required on another page
split that memo textfield into the name and their corresponding values
retrieved from the recordset ?
Thanks,
Sanj
|
by: planetthoughtful |
last post by:
Hi All,
I have a calendar form that updates a date field on the form from which
it was called. I have code in the OnChange event of the date field that
I would like performed whenever the date value in the field is changed,
including when changed by selecting a new date from the calendar form.
The calendar form works as expected - when I select a date the date is
placed in the date field of the calling form, but the OnChange event...
|
by: sellcraig |
last post by:
Microsoft access
2 tables
table "data main" contains a field called "code"
table "ddw1" is created from a make table query of "data main"
Goal-
the data in "code" field in needs to be inserted into a standard web
address in the table (the filed name is link) in ddw1
Example address ---
|
by: Adrienne Boswell |
last post by:
I have a form which I am letting the user enter more than one event at
a time. I need to check whether one date is less than another. If the
display to date is earlier than the event date, then of course that's
an error.
I am getting values like:
areaevent_display_from: 09/29/2006, 09/209/2006
areaevent_display_to: 09/29/2006, 08/29/2006
I could say:
|
by: AccessIdiot |
last post by:
I feel really dumb asking this but I'm not sure why it isn't working.
I have a form that has a text field. You type a number into the text field, it gets concatenated with a string, then gets put into the table as a string in the field "Survey_Num".
Press a button on the form and another form pops up. There is a "Survey_Num" field in the table behind this form as well and they are tied in a one-to-many relationship.
I want the value on...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |