Search results

  1. F

    Unbound Form

    Respected Pat Hartman, My tables are normalized. I dont need form-subform setup as per my specific need, otherwise i would have gone that way. An unbound form serves my purpose better than a bound one. Kindly guide me here sir.
  2. F

    Unbound Form

    hi again. as i figured out, i dont need the work date criteria anymore. i just want to keep current dispatch id as long as the same selection is being made in the "cboToLoc" combo box. The Dispatch ID gets incremented only when a new selection is made in the said combo box. For this, i deleted...
  3. F

    Unbound Form

    It worked. Really appreciate your guidance arnelgp (y)
  4. F

    Unbound Form

    error message pic attached
  5. F

    Unbound Form

    Hi, Last month I posted a query on this forum. It solved my problem to the extent that the form being used was a bound form. I am now trying to make it work with an unbound form in my specific scenario. The relevant code is posted here as well. Private Sub cboToLoc_AfterUpdate() Dim lngDispID...
  6. F

    Saving data to table using unbound form in MS Access 2010

    Thank you indeed for pointing out.
  7. F

    Saving data to table using unbound form in MS Access 2010

    Changed to 12, but still getting the same compile error message.
  8. F

    Saving data to table using unbound form in MS Access 2010

    so anything wrong with the code ?? or should i use DAO ?
  9. F

    Saving data to table using unbound form in MS Access 2010

    Hi, i have a database with extension .accdb. In the VBA code for Save button, following code is written. ' Create Variables Dim cnn1 As ADODB.Connection Dim rstcontact As ADODB.Recordset Dim strCnn As String ' Open a connection. Set cnn1 = ADODB.Connection mydb =...
  10. F

    Solved Envelope Number Assignment in unbound form field

    Thank you indeed. However, I would like to have better understanding of this code. Can you explain its working to me please, specially the inner DMax function line? Also, what is the benefit of using DBEngine.Idle here? I am also facing an unpleasant situation regarding a totally different...
  11. F

    Solved Envelope Number Assignment in unbound form field

    Hi all, I have created an unbound form in Access wherein I enter customer names, cities and invoice numbers being sent to them. i also have current date field and customerID fields on the form. Every thing on my form works as per my requirement and without any errors, except for one - the...
Top Bottom