Search results

yes you would be correct in what i am trying to do. But i was hoping to select the dates first then press a button and select the people i wanted to filter out.

i have a sub form with a calender on it and you enter a start and end date and then it runs a query between those two dates and opens a report. I want to have another form to also open up so they can select to only show the results for particualr clients. is there a easy way to do this.

i have tried your format below but the problem is if i select the start date as say 1st july and end date as end of july im still getting results for may and june. You need to format in US date format. Between Format([Forms]![Clients]![reports_subform]![cboStartDate],"mm/dd/yyyy") And...

i have a form which has to controls on it lets call them control A and Control B. If i put a date in Control A and one in Control B and then hit the button to open the report its not filtering out between the dates selected. Its showing dates previous to that. In the query that the reports...

i have a query and i want it to not show the results if the dates are the same in two columns.

I have a query with two fields in A: Date Payment Made B: Date Payment Due I want it to filter out and show if someone has an over due payment and also by how many days. i have tried [Payments]![Payment Date Due]>[Payment Date Made] and also in the Payment Date Made column tried putting in...

Re: Form Combo Boxes for Search I have a form with two combo boxes in both getting the customerid from the customer table. what i want to do is to select certain numbers from the list and then get the report to filter out and show the ones i have selected after hitting a button. what is...

i have resolved the issue. but thank you for your help anyway

i have two forms lets call them Form A and Form B on Form A there is a button that opens form b and shows up only the records that are related to the customer that i have open on Form A. e.g if im on Client A it shows up Client A in Form B. I can fill out the information on Form B and it...

Re: Groups in access report i have a query which is listing all the clients that are male and female and also if they have a disability and also there ethnicity. What i want to show is below: Male = Total Number Female = Total Number Disbilty = Total Number List of All Ethnicity's and how...

when you say fk in the training table what do you mean? also what is the best way to pass the ID to the subform.

i have a database with a number of tabs on the first tab it has all the details of the client e.g Name, Address etc. On the second it has a sub form and they can fill out there training. This all gets stored in a table called jobtrain. It seems to be logging the name and and there employment...

Re: Spaces in Field Names i have a field name with a space in it. With the code im using how can i stop it brining up the error. expected: list seperator or ) the fieldname is CFirst Name

Re: NZ Function Hi I tried using .Selection.Text = Nz((CStr(Forms!Clients!CFirstName)),"") but this still throws up the error.

i have this form in which when you press a button it opens up word and using bookmarks pulls in the data from the form. But if someone hasnt filled in one of the fields it brings up invalid use of null when i press the button how can i stop this. i have pasted the code below. can anyone help...

Re: Date Field Order I have a form with a text box in it where someone puts the date in. This was showing all the dates in order but now the most recent entry instead of going at the top is at the bottom. How do i order them in date order. I have heard you can use the Order By option. Can...

Samples where would i find these samples?. im not new to access but certaintly to do VBA in acccess.

No form fields no the word document doesnt have any form fields in. So what is the best way to do this

i have a database which i have created with a form. Now there is also a word document i have been given and i want to be able to add a button to the form and when i click the button it loads up word and then exports out the name and address from the record im on into the word docuement which is...

its stops on the first line if you mean after you click on debug: the line is pasted below: DoCmd.OpenForm "Incidents", acNormal, , "[Incidents.VIncidentID]=" & Me!VIncidentID