Search results

  1. K

    Import CSV to tabel, but only new data

    Hello, I have a production machine that writes its output to a CSV file every time it produces a good part (several times pr. day). It can produce identical part which means that the mashine will not put in another line in the csv, but just update the no of produced parts. I had to rename the...
  2. K

    Open a report from a form where...

    Hello, I´m fairly new at this, so please bear with we. I have a form where I would like to add a "Print Current page" button, but the print should be formated according to a standard print report I created. In the form there are to fields that makes the entry uniqe from other pages of the...
  3. K

    Permanent custom numbering

    Hello Forum, I have this problem. I have this project DB where I have a problem recording tool. Each problem has an ID (P-key), but it needs to have problem ID as well. The problem ID must start from 1 and continue towards x at each project. To describe the above with an example: ID...
  4. K

    Cascading combo Error

    Hello, I have now spend hours and hours trying to make my first cascading combos, but now I need som help. In the form FORM_Underark_aftaleseddel I have tried to make cascading combes in the last two cells Hovedaktivitet and Underaktivitet, but when I try to use the form it will not let me...
  5. K

    Limit options corresponding to previous choice

    Hey, Still working on my first db. :-) I have attached the db. I have two tables where TBL_Underaktiviteter (tbl_sub) is a subtable to TBL_Hovedaktiviteter (tbl_main) - meaning that if you choose the value 200 in tbl_main I can limit the possible outcome of tbl_sub. So fare so good. In...
  6. K

    Dlookup in a form

    Hello I'm a newbie, so go easy and overexplain :-) I have made this DB (attached) where I want to put in a Dlooup command in form. The form is For_T_Aftaleseddel and the field is Faktureret beløb. Currently my Dlookup command looks like this...
  7. K

    Creating a subform

    Hello, I have 2 forms based on 2 different tables that have a one to many relationship. When I open the parent form I want to be able to push a button that opens the subform that corresponds to the parent form only. I got the button covered, but how do I make the subform show only the info...
  8. K

    Linking one to many

    Hello folks, Newbie question: I have 2 tabels. One with info on an invoice and one that is a "sub" table to the other where the price on the invoice is devided into cost manhours, cost material, Admin cost and so on. The way the users are intended to use this DB is that they select the...
  9. K

    One cell in tbl 1 refers to sum of cells in tbl2

    Hey, I'm new at this and do not know if I posted this in the right toppic. Anyway I have an invoice where the total cost cell is the sum of a number of cells in another tbl. Example: Man hours 200£ Plasterboard 200£ Administration fee 10£ Total cost: 410£ In other words with each invoice...
  10. K

    Newbie from Denmark

    Hello all, I have just attended a beginners course in Access 2010, but I have not yet done my first DB except from during the training. I work at a house construction company where I have a task of constructing a DB for handling the economic side of a project. I´m ok skilled in excel when it...
Back
Top Bottom