Search results

I managed to sort it. private sub Form_Current() Call fieldname1_AfterUpdate Call fieldname2_AfterUpdate Call fieldname3_AfterUpdate Worked perfectly.👍🤞

The code provided works perfectly on a single group of linked fields, however I have approximately five separate fields which have the visible (true/false) field codes. An error is displayed on form load if you try to apply to more than one as separate codes.

Hi Pat, really appreciate your reply. Are you able to share the code which you're suggesting that I should use?

Excellent. Thank you.

My access form has a series of fields which only appear on a certain criteria being input, normally yes or no. The code has been keyed in the build event menu and working perfectly for a new form. When I try and open an existing form with the data contained, the fields which I expected to be...

I must be keying something wrong.

Never keyed an sql entry before so apologies. My sql input displays an error. SELECT [Team field name],Count([Date field name]from[Table name][Date Field name]between[Start Date]and[End Date]group by [team name field];

I only have minimal experience of using MS Access. On my query I have added two fields Team and dates The date field I have added the criteria 》=[enter the start date] And《=[end date] What do I put in the total field.? Team displays - Group by Date - Count Error message displayed

Hi, I have a table with a range of dates within a field. If I wanted to run an ms access query to count occurrences of a criteria within another field within a specific date range is this possible? My existing query will display all the rows within the date range but I'm looking just for a...

Firstly, what a brilliant community. Really pleased to have found this place. Really appreciate the replies received - most useful. Thank you Charlie

Hi Within a form in MS access is it possible to auto generate the date based on two criteria. I have a date say 01/01/2021 displayed in field 1 Field 2 dislays the review frequency say 6 months, 1 year, 18 months and 2 years How would I autogenerate the field 3 value with the correct future...