Recent content by hm1sal

I have a form bound to an access table via ADO. Several txt boxes that get their value based on what the user selects with several option boxes. If new record, all is well. If editing existing record, controls function normally, and txt boxes show new values. If the user only uses the option...

Sorry, I should have posted the code with the initial question. Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Number As Integer Dim newdate As String If Option1(0) = True Then IntervalType = "m" ' "m" specifies months as interval...

I have a form bound to an access table via ADO. Several txt boxes that get their value based on what the user selects with several option boxes. If new record, all is well. If editing existing record, controls function normally, and txt boxes show new values. If the user only uses the option...

Thanks for the reply Jel, now, can you point me in the direction of how and where to accomplish this. The form has a ado connection to the database (datprimaryrs) I cannot figure out how or where to close and reopen the recordset. Help appreciated. jsalvin

Greetings, I have a datalist field that gets its data from this SQL statement in the Dataenvironment command: SELECT TDate FROM tblTable ORDER BY TDate All works well, the entries are sorted in date order. I just want entires like 1/22/2004 to show as 01/22/2004 simply so it looks better. I...

I have a rather simple database application. Using an ado connection to an access database. I have a form with a text field that get its data from a dataenvironment/command/aggregate SUM that simply totals the value of one column in the database and displays that number in the field. Works well...