Search results

I have a query named qryAgencyAssigned which identifies all the agencies assigned to a Report in table ReportID. Each ReportID may have many Agencies, and the query reflects this Is it possible to Concatenate all of the agency values into a single text box control source on a form or to do...

I had placed this thread in another forum but I don't think I was making myself clear as it is most likely a coding solution. I have attached a drawing to assist in the explanation. I need a user who has no coding experience to be able to update a maintenance table(tblAgency) in the front end...

I would like make a reference table tblRefTable (for maintenance changes) that identifies Sectors and the Agencies assigned to them. The table will have a 1 to many relationship: 1 Sector may have various Agencies. I would then like to be able to use tblRefTable to auto populate a Sector...

Hello Using a cmdButton On Click I have increased the font size of some List Boxes and memo fields in my database. I am wondering is it possible to have a form so that if our visual impaired user enters it, they can click a cmdButton that would allow all the field labels and field font...

Hi I have never declared a parameter in a query before any help welcomed I have a crosstab query based on another query called qryCountAgency2 in this query one of the columns is ReportYear which has the criteria set to Between [StartDate] And [EndDate]. When I run my crosstab qry I get a...

Hi, while responding to another issue one of the forums members suggested for good practice I also limit user impute into the RecNum field by inserting the following code into RecNum field so it self populates with the next number Private Sub RecNum_BeforeUpdate(Cancel As Integer) If...

I posted this in Forms but think I need a code solution- I have 3 tables all linked by a Report_ID. I would like to populate a field from the other form frmRecommendations if a value is entered into a field Agencies_ID that matches a recommendation number in frmRecommendations . I have...

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

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

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

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

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