Problems with loading forms

Hi Everyone,

I am very new to this but so far have managed to create a small database
with a few tables linked together and a few queries.

I have also created some reports and forms.

Using the switch board I would like to open a form in edit mode, which has
been filtered by default
base on the following two conditions:
- Status = Open
- Trace date = Any date during this week. Basically I would like the date
range to change automatically depending on the current week. The current
week being Monday to Sunday.

What is the code and where do I enter it?

I am using Access 2000.

Many thanks

Anguel.


.

Relevant Pages

  • Problem with dates
    ... I am very new to this but so far have managed to create a small database ... with a few tables linked together and a few queries. ... range to change automatically depending on the current week. ... Anguel. ...
    (microsoft.public.access.gettingstarted)
  • Useless queries
    ... Anyone know of a program that can search your database ... and find queries, etc. that are no longer used? ... to try to trace back each form, query, etc. ...
    (microsoft.public.access.queries)
  • SQL queries tracing
    ... how can I trace all queries that are sent to an Ingres II database? ...
    (comp.databases.ingres)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)