Search results
-
R
Filter subform by multiple textbox options
So I have my form with a subform displaying open inspections, On the parent form I have text boxes and combo box's for user input's to filter what is shown in the subform. I have got this working as intended through the subforms select SQL but the method really doesn't feel like it is a good... -
R
alter a week number ww/yyyy recorded as a text field
Im recording a week number as defined from a date as a constant in a table ( Live_week ) this is then used for reference through many areas, what Im struggling with is simply adding 1 to the week number so to show the current live_week I have a text box with... -
R
Query to check records for matches to form text box
Pretty new to access, Im trying to create a query that shows all the results that are like a forms input - The premise is I have a form for raising inspections - on submitting it checks the input address for possible existing records of inspections to that property - if none it inputs a new...