Search results

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...

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...

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...

looked at that sample database and i think that would be perfect. Am i right in thinking that the unbound text boxes are parameter entries for a query...just looking into how i can recreate this. viewing it on access xp but need to work it in '97

definetly gonna have to look into the last one mate......on theback burner at the mo though while i figure out a way to do this query builder form.......perservance will win hopefully....cheerz guys.....this is just what i need

cheerz mate..tried this and didnt get too far.....gonna have to doa bit more training first. needs to do the likes of giving them the ability to save different queries and print them.....bodged one up at the mo though.cheerz

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...

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...

I will do...cheerz for that. ANyone know of a good site for visual basic information. Its something i should learn really if im gonna get into this.

No,i'm not too good with the basic. Would i just type that in when in the visual basic format (if you see what i mean). And i presume i could use a similar statement to that on a button in a form to requery the databse for new records?

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...

thanks....will do......would have searched before but i didnt know what to search for........what a forum!!!:)

I tried this at first and found (as it says in access help) thaqt this will only refresh any existing records that have been changed and will not refresh the database with any new records. It will not add the records to anyone elses version unitl they hit 'shift-f9' or restart the application.

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...

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...