Search results

  1. S

    Creating fields in a report with information from fields in a query

    I have created a report based on a query. It is all working fine apart from one small niggle. In the query i have to enter a start date and an end date. I would like these dates to also show in the report. All the other information show but i dont know where to point the fields towards to...
  2. S

    Help needed with creating a query involving number of days

    I am creating a database that records people holiday movements. On the front form it allows the user to select the day that they are going from and they day that they are staying till. what i would like is a box next to it that will calculate and show the amount of nights that they will have...
  3. S

    form based query

    I know that this has been answered many times but i cannot get it to work. I am wanting the user to run a query and for it to show the results without them actually going into the query design view. At present they can clikc on a command button which will load a query. The only view they get...
  4. S

    Filtering query results.

    In one of the forms on my database the user ahs the ability to view the results of a preset query by clicking on the relevant button. The only problem is that they dont have the ability to filter the results as they so wish and currently only have the filtered view which i preset. Is there a way...
  5. S

    Form example - Queries

    I'm still learning on Access but i;ve made a fairly comprehensive database for lots of user to store information for trend analysis. They use a series of forms to input the data and can view some basic preset queries but what i would like to do now is make a form that the user could use to cary...
  6. S

    automatic update of query used as rowsource

    I'm synchronising 2 combo boxes so that the 1st will force the type of data in the 2nd. In the 2nd combo box ive set a simple query in the rowsource property. Now when i close down the property box for the query th query runs and produces the correct info in combo2. But after that if i change...
  7. S

    query based on combo box

    I have 2 combo boxes. 1 relating to a table with 4 fields (desk) and the other relating to a table with 2 columns (desk and system). I would like the 2nd combo box to only show data depending on what is in the 1st. I would be able to do this if i could make a query which would include combo...
  8. S

    Automatic Requery of Form??

    I've set up a form comprising of several combo boxes nad free text fields. Now, 8 people run the same form at the same time and are constantly entering new records and need to see other peoples records. I'm not too sure if i can set the system up to refresh the database automatically. Using...
Back
Top Bottom