forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
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
 
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.
 
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
 
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
 
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?
 
Back
Top