Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > Programming Help
Reload this Page

Forms Problem

Discuss Forms Problem in the Programming Help forum on ASP Free.
Forms Problem Programming Help forum discussing programming solutions and code assistance related issues. Feel free to ask questions, or to offer your assistance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old May 25th, 2004, 05:51 AM
Barry Wash Barry Wash is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 5 Barry Wash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Forms Problem
Hello,

Have a working form
Part of it includes 5 Value boxes
The 6th is the total of the above 5 set up with
=([Box1]+[Box2]-[Box3]) and so on.
Box 6 is a "Balance owing" total.

The Problem I have is that I want to have this total
show in a Table [eg Table1] but it will not.

How can I achieve this please

Thanks
Barry






ay _
Reply With Quote
  #2  
Old May 25th, 2004, 08:02 AM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,760 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 5 h 18 m 17 sec
Reputation Power: 443
What are you doing this in, Access?, ASP?, .NET?
Reply With Quote
  #3  
Old May 25th, 2004, 05:26 PM
Barry Wash Barry Wash is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 5 Barry Wash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Yes - Using access 2000

What I am trying to achieve is to pick up the total in Box 6 as a Balance owing figure in a query
I am working towards a drop down box which picks up Name etc plus the last Balance.
I have created the drop down box which works fine but because not amount is showing in table1
the amount is not showing.

would appreciate any help

thanks



Quote:
Originally Posted by Memnoch
What are you doing this in, Access?, ASP?, .NET?
Last edited by Barry Wash : May 25th, 2004 at 05:36 PM.
Reply With Quote
  #4  
Old May 27th, 2004, 05:18 AM
Barry Wash Barry Wash is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 5 Barry Wash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thought I was entering an area where I could get a little Help from experts who could solve my problem as quick as a flash.

Hey come on please - it's a simple problem - can I get some help please

Thanks
Reply With Quote
  #5  
Old May 27th, 2004, 10:27 AM
sbaxter sbaxter is offline
Moderator: Access, SQL
ASP Free God (5000 - 5499 posts)
  
Join Date: Oct 2003
Posts: 5,126 sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
Why don't you post you question in the Access portion of this forum, where you can get the help you want.

S-
Reply With Quote
  #6  
Old May 27th, 2004, 01:44 PM
beercraft_asp's Avatar
beercraft_asp beercraft_asp is offline
Spell Breaker
ASP Free Novice (500 - 999 posts)
  
Join Date: May 2004
Posts: 990 beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level)beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level)beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 3 Days 8 h 33 m 42 sec
Reputation Power: 5
Send a message via AIM to beercraft_asp Send a message via MSN to beercraft_asp
Arrow
Quote:
Originally Posted by Barry Wash
Thought I was entering an area where I could get a little Help from experts who could solve my problem as quick as a flash.

Hey come on please - it's a simple problem - can I get some help please

Thanks
May be this will help
<%
TotalBox = request.form( "Box1" )+request.form( "Box2" )+request.form( "Box3" )


%>
Then insert TotalBox it into db or where do you need
<%=TotalBox%>
Reply With Quote
  #7  
Old May 27th, 2004, 05:47 PM
Barry Wash Barry Wash is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 5 Barry Wash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks for the reply.

Question where do I use/Place the string to get the result I want.
What I am trying to achieve is
1. To getThe total figure [already showing on the form] into the table1 so when I recall the record it shows the balance.
2. At the moment as indicated the total is achieved on the form by adding the Text boxes - this is fine for the form but
3. I also have another form which - using a drop down box calls up the Customer and his/her details but it does not call up the Balance Owing because it is not getting to Table1 record
The amounts in Box1-2 and 3 etc show on the table1 - fine but the Balance Owing is the problem.
Hope that makes sense

Form
Box 1
Box 2
Box 3
Box 4
Box 5 [using =([Box1]+[Box2]etc])

Table has
Info from
Box 1
Box 2
etc
But no figure for Box 5.

What I need is info on how to get the result of Box 5 into the table so I can used it in a query
to achieve 3 above.

If you can help it would be appreciated.

Also if this is not the right area for this type of help - what area is and how do I get there please

Thanks

Barry Wash
Reply With Quote
  #8  
Old May 28th, 2004, 07:44 AM
beercraft_asp's Avatar
beercraft_asp beercraft_asp is offline
Spell Breaker
ASP Free Novice (500 - 999 posts)
  
Join Date: May 2004
Posts: 990 beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level)beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level)beercraft_asp User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 3 Days 8 h 33 m 42 sec
Reputation Power: 5
Send a message via AIM to beercraft_asp Send a message via MSN to beercraft_asp
Arrow
Quote:
Originally Posted by Barry Wash
Thanks for the reply.

Question where do I use/Place the string to get the result I want.
What I am trying to achieve is
1. To getThe total figure [already showing on the form] into the table1 so when I recall the record it shows the balance.
2. At the moment as indicated the total is achieved on the form by adding the Text boxes - this is fine for the form but
3. I also have another form which - using a drop down box calls up the Customer and his/her details but it does not call up the Balance Owing because it is not getting to Table1 record
The amounts in Box1-2 and 3 etc show on the table1 - fine but the Balance Owing is the problem.
Hope that makes sense

Form
Box 1
Box 2
Box 3
Box 4
Box 5 [using =([Box1]+[Box2]etc])

Table has
Info from
Box 1
Box 2
etc
But no figure for Box 5.

What I need is info on how to get the result of Box 5 into the table so I can used it in a query
to achieve 3 above.

If you can help it would be appreciated.

Also if this is not the right area for this type of help - what area is and how do I get there please

Thanks

Barry Wash

Are you talking about tables as Database TABLE???
Did you try to do JOIN SELECT STATEMENT???
Reply With Quote
  #9  
Old May 29th, 2004, 10:52 PM
Barry Wash Barry Wash is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 5 Barry Wash User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Yes and Yes - although the Select situation will not relate to the form

Thanks
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > Programming Help > Forms Problem

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


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 On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway.