Search results

i didnt use an i expression, just selected field is greater than from the combos. Then typed Davg. Im a novice...so not too sure about the expression.

This was an interesting read however it did not really help. I really like the "listbox" system and just need to manipulate it to work with a sub-table. I have tried removing the listbox and naming and subtable/query the same. The debugger then picks up on the .requery command. Any ideas of...

I have a subtable containing a name and a percentage (score). I would like all of the percentages above the average to be green and those below the average to be red. I have tried "field is greater than Davg" however this proved unsuccessful. Could anyone tell me the expression Thanks Nick

I have already downloaded and implemented your dynamic search function, to some success. Could you tell me how you would, specifically, filter the subform? Therefore creating the same search function, but to filter by elimination through the sub-table. Thank you, I'm very great full for your...

Thanks a lot for your response, Heres a link to the post. I have uploaded my DB there: http://www.access-programmers.co.uk/forums/showthread.php?p=1046149#post1046149

Hi, I wish to create a search box which will filter through the names in my sub-table list on the switchboard. I would like it to be similar to the itunes search function or the one which JBB created: it shortens the list after the entry of each character. The reason for not creating a listbox...

Thanks for your help but this is not exactly what I am looking for. I have found how to open the "unhide columns selector" i want, Just rightclick the subtable and select "unhide columns". Basically i just want a button which does this. I have attached an image of the box i mean. Thanks a...

I have a sub table on my switchboard. I wish to have a button which opens a set of tickboxes allowing the user to select which fields are shown within the subtable. The "student template" ON MS Access 2007 features this. Thanks allot Nick

thanks for this but I specifically would like a search box into which letters can be typed and any names containing those letters are shown. Does anyone know how to do this?

Hi, I wish to make a search box which will search through a table full of student names. I would like it to be similar to the "itunes" search function which only displays albums containing the typed letters in them. Thanks

Hi, I am creating a DB which is similar in concept to the MS "student" template shown on Access 2007. I am wondering how to create the "sub table-looking" student list on the "main menu" that they have. Specifically the open student record function. When looking in design view it seems they have...

I have now normalized my table, how should the defult value "code" specifically read. I have been trying but this is not recognised. Thanks

There is a reasonably high chance. I have uploaded a copy of the DB to prevent confusion. Basically the client must go for a review every 12weeks and she want there to be a default value of 12 weeks after the last review date. *you want to be looking in the tblReviewDates table and the field...

Sorry I missed the last line of your response, I am recording the date using a subtable within my main form. The dates are entered using a datepicker. Hope that helps

Thats exactly correct DCrake, and DMax will be okay because the last recorded date will be the greatest...thanks for the concern BrianWarnock. I am just unsure of how these should be combined within the box. Thanks

Sorry I am still unsure of how to put these 3 together, could you specify a little more what i should type in the default value box. Thank you very much Nick

Hi, I have a sub table within a form containing some dates. I would like to create a default value which will be 12weeks (84 days) after the LAST RECORDED DATE. *I can make this work for 84 days after todays date but am unsure of how to specify the last record/date. Thanks allot Nick

Thanks allot, that seems a much better way of doing things. Could you explain what the "enter parameter" box means each time I load the main form? and how I could possibly stop this?

Hi, I am trying to create a code which will copy the contents of a "date/time" field to a "memo" field when the value of the "date/time" field changes. I am unsure of the code which i should use to copy this field to the other. I have attached a copy of the database to prevent confusion. *I...

That works perfect, Thank you all so much.