Search results

  1. A

    Date error when using Windows XP

    pbaldy When the database is copied the necessary reference should go with it which means that the library could be what is missing. I'll check that out. Thanks - Art
  2. A

    Date error when using Windows XP

    My client and I both are running Access 2010(32 bit) applications with copies of the same database. A difference is that I am using Windows 7 and he is using Windows XP. We both downloaded new versions of Access 2010. Attached is a image of his screen showing the compile error that he gets when...
  3. A

    Adding unbound field data to a field in a recordset

    Lagbolt, Thanks for the help. I implemented the changes you suggested and they produced the desired results. Your programming style was also of benefit in bringing an old software developer up to date. The last program that I wrote was in 2007 on Access 2003. Art
  4. A

    Adding unbound field data to a field in a recordset

    Okay - Starting over. I am using Access 2010 and am trying to use VBA to create a new record in a recordset and populate it with data from unbound fields on a client(not web) form when I click on a button named Post. This is my post routine: Private Sub cmdPost_Click() Dim rstPayments As...
  5. A

    Adding unbound field data to a field in a recordset

    Sorry, the code should have been: rstPayment("Type").Column(0).Value = Type.Column(0).Value rstPayment("Date Posted").Value = [Date Posted].Value Art
  6. A

    Adding unbound field data to a field in a recordset

    Using Access 2010 I have a client form with unbound fields where data is added manually. I have created a VBA subroutine that adds the data in these fields to a recordset and it works fine except for 2 field types: a date field and a combobox field. The code i'm using is...
Back
Top Bottom