Search results

I have attached a word doc which shows the structure of the DB let me know if it helps

Each Recommendation is unique to each ReportID. So each ReportID may have many recommendations. Each ReportID may also have many agencies that need to implement 1 or more of the recommendation. Additional data needs to be inputted against each agency so each agency casn be reported on...

I tried this but I still couldn't get the information to populate in to the recommendation field. I had linked the field by the recommendation key and it populated but not the recommendation

I have 3 tables all linked by a key field call Report_ID I have a form called Reports_tabled (top level) This form has 2 sub forms – frm_Recommendations (2nd level) and frm_Agency (3rd level) A completed list of recommendation (long text) for each report is entered into the sub...

Thank you all for your thoughts they all have given me options Thanks Ron

Good afternoon, I have a report which filters the data by a between [Start date] and [Last date] in a query. How do I get those two dates to appear on the report so the user knows what data range was selected when the report is printed. Thanks Ron

Thank you all I have started at the listbox and will look at the form as an option. My user will really appreciate you help. Thanks Ron

I have a user who is visual impair I was wondering if there is a way to increase the font size of a list box by clicking on a command button. For example font is currently 14 if the user clicks the command button it increases the font to 22. But if another user logs on it has returned to 14...

Thank you very much for this it worked very well, I really appreciate you time and assistance Regards Ron

I have 2 tables tbl_Reports_Tabled (key =Report_ID) and tbl_Recommendations (key REC_ID) they are link 1-many by Report_ID, based on the tables I created a Subform with frm_Reports_Table as the parent and frm_Recommendation as the embedded form. I have built a search form frmSearchREC based on...

Thank you very much it worked

I have a form created from a query Report Recommendations. On the form there are two field one showing the total recommendations for a report the other identifies what recommendations you are reading. The number changes everytime the user clicks the next record button. I would like to write an...

My name is Ron and I am new to access. I am from Australia