PC Review


Reply
Thread Tools Rate Thread

How to auto enter a form field?

 
 
Omar K
Guest
Posts: n/a
 
      20th Apr 2005
Hi, I am new to FP 2002 and I have no prior HTML programming
experience.

I have a submission form with fields such as Supplier and Employee.
When the user is ready to input the Supplier or Employee data, s/he can
click on a separate search page for the list of Suppliers or the list
of Employees available. When they find the correct item, they will
click on it, and it will be entered into the submission form field
automatically. (then the search page can close automatically)

The previous data entered cannot be lost/refreshed.

I am thinking that the POST or GET option has to be used, but I am
clueless.

Any help is appreciated
Omar K

 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      20th Apr 2005
You need to have then select the Supplier and Employee prior to entering the form and filling in
data or you need to pre-populate individual drop down menus with the Suppliers and Employees while
on the form.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Omar K" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, I am new to FP 2002 and I have no prior HTML programming
> experience.
>
> I have a submission form with fields such as Supplier and Employee.
> When the user is ready to input the Supplier or Employee data, s/he can
> click on a separate search page for the list of Suppliers or the list
> of Employees available. When they find the correct item, they will
> click on it, and it will be entered into the submission form field
> automatically. (then the search page can close automatically)
>
> The previous data entered cannot be lost/refreshed.
>
> I am thinking that the POST or GET option has to be used, but I am
> clueless.
>
> Any help is appreciated
> Omar K
>



 
Reply With Quote
 
Omar K
Guest
Posts: n/a
 
      20th Apr 2005
so having the user pre-select the supplier and employee values avoid
the use of drop down boxes? how is this if the search pages for
supplier and employee are on separate pages?

I am following a structure I saw on a car rental site (avis.com) where
the user must enter a date, but can click on a calendar to select the
date and it will then be entered automatically into the original form.
Is it possible to do this in FP2002 with minimal HTML programming? and
how?

Thanks

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      20th Apr 2005
You would select the value, say for Supplier, and it would then be pass to the next page, where it
is stored in a session, then you would select Employee, then it and the Supplier is pass to the
form, where the rest of the info is enter, and then pass to the database or email as a hidden form
field.

What you saw on Avis, with the date, is most likely a JavaScript calendar function which when a date
is selected, it is inserted into a form file. JavaScript is run client side in the browser and if
the user happens to have JavaScript disabled, then the use has to manually type in the date.

I think the easiest approach is to use drop down menu on the actual form, that way the user never
leaves the form which can be done directly in FP.

The passing of variable/session requires knowledge of JavaScript or Server-Side Scripting written in
ASP, PHP, etc.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Omar K" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> so having the user pre-select the supplier and employee values avoid
> the use of drop down boxes? how is this if the search pages for
> supplier and employee are on separate pages?
>
> I am following a structure I saw on a car rental site (avis.com) where
> the user must enter a date, but can click on a calendar to select the
> date and it will then be entered automatically into the original form.
> Is it possible to do this in FP2002 with minimal HTML programming? and
> how?
>
> Thanks
>



 
Reply With Quote
 
Omar K
Guest
Posts: n/a
 
      20th Apr 2005
thanks ...

can you suggest a website or example that can show me the basics /
format of the ASP programming for passing of variables. I have three
other functions that may need that.

1) The outgoing / incoming qty of stock (another form) must be
subtracted/added to the overall qty of that stock which is saved in a
different database. i want the out/in stock qty to be stored in a
different table as well for future reference.

2) the date of stock transaction (one form field) must be saved to two
different tables - how can i do this?

3) i want to alert the user when the overall qty is less than the
'minimum qty' (min level of stock before re-order) both are stored in
their own column and the same table.

are these things possible with the FP interface? maybe with advanced
options? or must i use the retrieval of data coding? I was looking at a
document 'How to complete mathematical calculations on a form before
you send data to a database in FP2002' - would this be of any help?

much thanks
o.k.

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      20th Apr 2005
Yes, FP can be used, and you may be able to use the FP database component, however you will find it
easier to learn to code ASP/VBScript directly, as that will allow you to easily incorporate examples
that you do find on the internet.

There is no one site that will help, you would need to visit many resources to find various
examples.

http://www.asp101.com, samples
This is the site that I found most helpful with examples when I first started with ASP/VBScript.

The following provides you with a reference to VBScript
http://msdn.microsoft.com/library/de...rivbscript.asp


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Omar K" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> thanks ...
>
> can you suggest a website or example that can show me the basics /
> format of the ASP programming for passing of variables. I have three
> other functions that may need that.
>
> 1) The outgoing / incoming qty of stock (another form) must be
> subtracted/added to the overall qty of that stock which is saved in a
> different database. i want the out/in stock qty to be stored in a
> different table as well for future reference.
>
> 2) the date of stock transaction (one form field) must be saved to two
> different tables - how can i do this?
>
> 3) i want to alert the user when the overall qty is less than the
> 'minimum qty' (min level of stock before re-order) both are stored in
> their own column and the same table.
>
> are these things possible with the FP interface? maybe with advanced
> options? or must i use the retrieval of data coding? I was looking at a
> document 'How to complete mathematical calculations on a form before
> you send data to a database in FP2002' - would this be of any help?
>
> much thanks
> o.k.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter info in one sheet, auto enter in another based on one field =?Utf-8?B?VGhlIEJ1c3lIaWdoTGlnaHRlcg==?= Microsoft Excel New Users 1 1st Aug 2007 10:54 PM
how to enter one field in a form and have the other fields auto-fi =?Utf-8?B?bXl6dGlxdWVz?= Microsoft Access Forms 2 17th May 2007 09:19 PM
Auto Enter Data in Field from Table =?Utf-8?B?U0c=?= Microsoft Access Macros 3 7th Jul 2005 07:25 PM
Auto enter record after last field =?Utf-8?B?U3Ryb2tlcg==?= Microsoft Access Forms 4 10th Apr 2005 03:21 PM
auto enter data in a field =?Utf-8?B?bHlubiBhdGtpbnNvbg==?= Microsoft Access Forms 6 6th Jan 2005 03:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:58 PM.