Re: Translation of FORM functions into web-based function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 03/15/04 

Date: Mon, 15 Mar 2004 12:46:26 -0800

Michel,

Thank you for your follow-up, it's good to know. Here's
a further question along the line, I'm posting a Design
View of the FORM in question, what I intend to do is to
figure out all the subfunctions contained in subforms etc
from this View or other means via the FORM, any further
guidance would be much appreciated, the URL for the
screen capture of the FORM is,
http://68.32.63.205/AccessFORM/Form1.GIF

TIA

Don

>-----Original Message-----
>Hi,
>
>
> The data is captured through the relation between a
control (on the
>form) and the field (in the table) through the control
property
>ControlSource.
>
> Me.ControlName.ControlSource="fieldName"
>
>When a dirty record is to be saved (going to another
record, closing the
>form), the data will be exchange from the form to the
table. When a new
>record is about to be display, the exchange is reversed,
from the table to
>the control. You have no code to produce for a form
bound to a table (or
>query) through the form property RecordSource. That is
done automatically
>for you, in that case. That would not be the case for an
unbound form.
>
>
>
>Hoping it may help,
>Vanderghast, Access MVP
>
>
>"Don" <anonymous@discussions.microsoft.com> wrote in
message
>news:996501c4093b$1d2d6050$a601280a@phx.gbl...
>> Hi,
>>
>> I'm not a stranger to Access but I don't use FORMs for
>> applications.
>> Now, I'm tasked to develop a web app based on a complex
>> FORM -based
>> app, the current FORM -based app works but has
problems (
>> one indicator: the recordset type
>> = Dynaset (Inconsistent Updates) ).
>>
>> The design view points me to record source (query)
behind
>> the form (it's a SELECT query in this case I find),
>> however, the FORM in question embeds lots of business
>> rules, lots of functions and/or subforms, what's a good
>> way to get to all these functions/subforms,
>> their interaction, and equally important, how
>> the FORM is going to be processed (maybe, I'm talking
in
>> Web terms :), but bear with me, the question is, how
are
>> we going to capture the FORM data? What gives me the
>> clue? How could I find the VB code for
>> that?
>>
>> TIA.
>>
>
>
>.
>

Relevant Pages

  • Re: bypassing some of the parameters in a parameter query
    ... > Well, WHERE does work in design view, but having a lot of ANDs and ORs ... > query to design view and see if it makes sense to you. ... > Each parameter would be a control, likely a text box or combo box, ... then tests to see if it is an empty string. ...
    (microsoft.public.access.queries)
  • RE: Nothing is showing up in form view
    ... How would I set up a query that would take data from the Order Input Form ... Open the form in design view. ... Select the Data tab and see what is in Record Source. ... Select each control in the Proerties Dialog. ...
    (microsoft.public.access.externaldata)
  • RE: Suppress Line Printing on Null Fields
    ... GrandMaMa, ... and I don't know what kind of control you have over the app. ... > a database design. ... >> criteria line of the query design. ...
    (microsoft.public.access.reports)
  • Re: bypassing some of the parameters in a parameter query
    ... The other query I ... > Well, WHERE does work in design view, but having a lot of ANDs and ORs ... > Each parameter would be a control, likely a text box or combo box, ... then tests to see if it is an empty string. ...
    (microsoft.public.access.queries)
  • Re: bypassing some of the parameters in a parameter query
    ... So now I have another question...yesterday when I was playing with the query, ... > Well, WHERE does work in design view, but having a lot of ANDs and ORs ... what is simple and direct logic in SQL View ... > Each parameter would be a control, likely a text box or combo box, ...
    (microsoft.public.access.queries)