Recent content by crazymarvin

  1. C

    Need VBA in a database - but cant think what for

    I have a simple database - 4 tables, 10 records in each. It's for a fictional company called DC Glass; it holds customer information and order information. I need to put some sort of VBA in it; I want to know what I could use VBA for (no matter how useless it would be in relation to the intended...
  2. C

    Lookup Fields

    I have two tables(tblInvoiceItem and tblItems). On both of these tables there is; ItemNo and ItemCost. tblItems already has various records about items. I want to be able to have a lookup field for ItemNo on tblInvoiceItems which will populate the ItemCost from tblItems. Basically when I pick...
  3. C

    Adding up Time

    One of the fields on my report is "Duration" and at the buttom of the report i need to have a total duration. I tried useing =sum([Duration]) and got a decimal value, i need to have in in hours and minitues. Any one got any ideas? thanks
  4. C

    Looking up fields from other tables

    Hey, I have two tables, one with order information and another with client details. The primary key in each of them is a 'ClientID' field. As well as the two tables, I have forms letting you enter data into each table. On the booking form i want to be able to look up the Client ID based on a...
See more
Back
Top Bottom