Search results

Current error message: Run Time Error 3464: Data Type Mismatch in criteria expression. My questions are below Module1 code A value is entered in the Textbox1 (on a subform) and a button run this code and fails due to Run Time Error 3464: Data Type Mismatch in criteria expression Private Sub...

I want to nest an update query inside a Do Loop. I am not sure which loop is the best for this. The user will enter a number in a textbox and then an update will run until the value in the textbook is reached. This Query is to run to select records by checking a box (title is update) in a...

I need to extract out the time, convert to time in 24 hour format and then use it to sort a report by time. The time needs to sort chronological order. Not in number value order. 1 pm (etc) comes after 12 noon on. Using this expression: Realtime: CStr(Format(CDate(Left([Start Time],2) & ":"...

I have a main form with a subform on it. The subform has three combo boxes and two list boxes. The data source is a table/query. The edit list items feature does not work (greyed out) when access via the main form/subform, but edit list items icon is active and functional when just using the...

Hello everyone.... I have been working with Access since 1995, but I am far from an expert. I have minimal coding skills (e.g. I suck at it). I have built several databases using Northwind as my base example to work from. There is not much more to share.....