forms

  • Thread starter Patrick Stubbin
  • Start date
P

Patrick Stubbin

I open a form on the basis of a query of an underlying table. Once the form
is open is it possible to then alter the undelying query (or select a
different group of records from the source table) as the basis as the inout
for the form. If it is fhow do i do it???.

there are times when i just want the form to be opened on the basis of the
default query, and times when i want it based on ALL records. but the
default needs to be the query with fewer records in it, not all records, so
not sure if a filter would would.
 
S

Steve Schapel

Patrick,

Depending on what the selection criteria you want to use for your query
are, it may be applicable to use a suitable event (maybe on a command
button on the form), to change the Record Source of the form. For
example, if it is showing a selected set of records, code like this will
cause all records to be included...
Me.RecordSource = "SELECT * FROM YourTable"
 
M

Missy

Please explain how I can insert a form into my web page that I created in my
Access Database. And if so, explain how I can display ONLY the data that the
user inputs at that moment?
Thanks So Much
Missy
 
S

Steve Schapel

Missy,

Sorry, this can't be done.

You could explore Data Access Pages using an Access project, or the use
of ASP or ASP.Net to write a web application that links to your Access
data. But Access forms are not in themselves applicable to a web interface.
 
M

Missy

Steve,
Thank you so much for explaining how and what I must do. Your expertise is
greatly appreciated and I most definitely will follow through. Again, I thank
you.
Missy
 
M

Missy

I also have a similar question as Patrick stated, and that is....I now have a
form that does open according to my query so that the user can view what data
they've inputed, but ALL the data is showing. However, I want to know how to
alter the query so that only a single row of data will show for that
particular user?
Thanks,
Missy
 
S

Steve Schapel

Missy,

What is the basis of the selection of which record you want the user to
see? Can you give an example? Also, is this a continuous view form?
If so, it may be more applicable for you to use a single view form?
 
Top