Search results

  1. R

    Sum of calculated values on a form

    Hi Guys, I have encountered the following problem and despite my efforts to find the solution through the o mighty google, I couldn't come up with anything useful so far: I've set up my table where I register manually issued invoice receipts. Invoice total -wise, the table only stores the Net...
  2. R

    DateAdd on form

    works like a charm! :)
  3. R

    DateAdd on form

    hello, I'm working on a form where I can register incoming vendor invoices. The invoices table has a payment term field, an issue date field, a transaction date field and a a due date field. I have a different table containing the payment terms with [Id], [Name] and [Number of days] the latter...
  4. R

    auto suggest value (text)

    holy cucumbers it is working! sweeet! the code is the following: Private Sub Vendor_name_and_pmt_AfterUpdate() Me.Paymentterms = Me.Vendor_name_and_pmt.Column(2) End Sub I guess the problem was that I wasn't using the VBA editor, I merely copied the Me.Paymentterms =...
  5. R

    auto suggest value (text)

    you have a good point indeed, I have renamed my controls so my line looks like as follows: me.Paymentterms=me.Vendor_name_and_pmt.column(2) still "Something is rotten in Denmark, my friends" is what Shakespeare would say if he was trying to get to the bottom of this because I get almost the...
  6. R

    auto suggest value (text)

    gee, even if I knew there was a column property of the combo box I have doubts I could come up with such a solution. thanks! :) so I created the combo box with the desired three (0, 1, 2) columns. now this combo box with the [vendor name] and the related [payment term] on my form is "Combo36"...
  7. R

    auto suggest value (text)

    Hello, I have a table where I keep track of [vendors] and an other table where i register [vendor invoices]. On the [vendor] table for every vendor there is field indicating the payment terms agreed with the particular vendor (eg. payment 30 days, payment 45 days, cash etc.). The payment terms...
  8. R

    Greetings from Hungary!

    Hello Everyone, I am basically a simple user with an intention of taking advantage of the functions of the ms office platform to their full extent. I am managing the family small business (commerce and garment manufacturing) and the firm outgrew the sole usage of ms excel for keeping track of...
Back
Top Bottom