Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hm1sal

  1. hm1sal

    Record Update Problem

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

    Record Update Problem

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

    Record Update Problem

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

    How to refresh aggregate SUM function

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

    Easy SQL Date Format Question

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

    How to refresh aggregate SUM function

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

Part and Inventory Search

Back
Top